Connect Airtable and Microsoft Office 365 to power AI-driven automation
- No-code AI automation
- Full audit trails and controls
- SOC 2 and GDPR compliant
- Easy visual workflow builder
- 9,000+ apps, 450+ AI tools
- Free tier available
Launch your first automated workflow
Start with a template that brings Airtable and Microsoft Office 365 together. Build enterprise-grade automation in minutes.
Our most popular template
Top companies trust Zapier to automate work that solves their unique business problemsβno coding required.
How Zapier works
Zapier makes it easy to integrate Airtable with Microsoft Office 365 - no code necessary. See how you can get setup in minutes.
Choose a trigger
A trigger is the event that starts your Zapβlike a "New Record" from Airtable.
Add your action
An action happens after the triggerβsuch as "Add Attendees to Calendar Event" in Microsoft Office 365.
Youβre connected!
Zapier seamlessly connects Airtable and Microsoft Office 365, automating your workflow.
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
- BaseRequired
- TableRequired
- Limit to View
- Include attachment content
- Include empty fields
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- BaseRequired
- TableRequired
- RecordRequired
- CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- CacheCopy
- BaseRequired
- TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- BaseRequired
- TableRequired
- Helptext
- Primary lookup fieldRequired
- Secondary lookup field
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- BaseRequired
- TableRequired
- RecordRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- BaseRequired
- TableRequired
- Number of RecordsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
ActionThis is an event a Zap performs.SearchFind existing data in your app- BaseRequired
- Search KeywordRequired
- Search In
ActionThis is an event a Zap performs.SearchFind existing data in your app- Search KeywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- BaseRequired
- TableRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- Shared Inbox
- Parent FolderRequired
- Child Folder
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Parent Folder
- Child Folder
- Search termsRequired
- Note
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- EventRequired
- Merge with existing attendees?
- AttendeesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Distribution ListRequired
- User EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Calendar
- SubjectRequired
- Start Date & TimeRequired
- End Date & TimeRequired
- All Day Event?
- Description
- Show me as Free or Busy
- Attendees
- Categories
- Location
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Shared Mailbox
- To Email(s)Required
- CC Email(s)
- BCC Email(s)
- SubjectRequired
- Body FormatRequired
- BodyRequired
- Attachment
- Action for Files Larger Than 150MB
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Shared Mailbox
- Folder NameRequired
- Parent Folder
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Shared Mailbox
- Email IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Shared Mailbox
- Email IDRequired
- Flag ActionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Shared Mailbox
- Email IDRequired
- Mark asRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Shared Mailbox
- Categories to RemoveRequired
- Email IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Send From (Shared Mailbox)
- Draft Email IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Shared Mailbox
- Email IDRequired
- ImportanceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact Folder
- ContactRequired
- First Name
- Last Name
- EmailAddresses
- BusinessPhones
- HomePhones
- MobilePhone
- JobTitle
- CompanyName
- Department
- Business Website URL
- PersonalNotes
- Street
- City
- State
- Postal Code
- Country or Region
- Street
- City
- State
- Postal Code
- Country or Region
- Street
- City
- State
- Postal Code
- Country or Region
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact Folder
- First Name
- Last Name
- Email
ActionThis is an event a Zap performs.SearchFind existing data in your app- Folder_info
- FolderRequired
- Search terms
- From address
- Start date
- End date
ActionThis is an event a Zap performs.SearchFind existing data in your app- Calendar
- Start date and timeRequired
- End date and timeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
- Help Text
- BaseRequired
- TableRequired
- Last modified time columnRequired
- Limit to view
- Include file contents?
- Include empty fields
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- BaseRequired
- TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
- Workspace IDRequired
- Number of TablesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- BaseRequired
- Table NameRequired
- Table Description
- Primary Field Name
- Primary Field Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- BaseRequired
- TableRequired
- RecordRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Api_docs_info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- BaseRequired
- TableRequired
- Record IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- BaseRequired
- Table IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Base IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- BaseRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Calendar
- Time BeforeRequired
- Time Before (Unit)Required
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- New Flagged Email
Triggers when a new email is flagged.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan - Email IDRequired
- CategoriesRequired
- Mark as Read
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Shared Mailbox
- Destination FolderRequired
- Email IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact Folder
- First NameRequired
- Last Name
- EmailAddresses
- BusinessPhones
- HomePhones
- MobilePhone
- JobTitle
- CompanyName
- Department
- Business Website URL
- FileAs
- PersonalNotes
- Street
- City
- State
- Postal Code
- Country or Region
- Street
- City
- State
- Postal Code
- Country or Region
- Street
- City
- State
- Postal Code
- Country or Region
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Shared Mailbox
- Email IDRequired
- To Email(s)
- CC Email(s)
- BCC Email(s)
- Reply-To Email
- Subject
- Body Format
- Body
- Attachment
- Action for Files Larger Than 150MB
- Reply to All
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact to DeleteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- EventRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Send From (Shared Mailbox)
- Email IDRequired
- To Email(s)Required
- Comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Email IDRequired
- Destination FolderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Email IDRequired
- Comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Send From (Shared Mailbox)
- To Email(s)Required
- CC Email(s)
- BCC Email(s)
- SubjectRequired
- Body FormatRequired
- BodyRequired
- Attachments
- Action for Files Larger Than 150MB
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- EventRequired
- Subject
- Start Date & Time
- End Date & Time
- All Day Event?
- Is Online Meeting?
- Hide attendees list?
- Description
- Show me as Free or Busy
- The importance of the event
- Merge with existing attendees?
- Attendees
- Categories
- Location
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Calendar
- Search TermRequired
- Start Date & Time
- End Date & Time
ActionThis is an event a Zap performs.SearchFind existing data in your app- Search_info
- Search valueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Shared Mailbox
- Email IDRequired
- Attachment IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Contact Folder
- First NameRequired
- Last Name
- Email
- BusinessPhones
- HomePhones
- MobilePhone
- JobTitle
- CompanyName
- Department
- Business Website URL
- FileAs
- PersonalNotes
- Street
- City
- State
- Postal Code
- Country or Region
- Street
- City
- State
- Postal Code
- Country or Region
- Street
- City
- State
- Postal Code
- Country or Region
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023
93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Practical ways you can use Airtable and Microsoft Office 365
Automatically log customer emails in Airtable
Keep track of all customer communication effortlessly. When a new email is received in Microsoft Office 365, Zapier will automatically create a record in Airtable to log the email details. This ensures all interactions are documented without manual effort, improving customer tracking and follow-ups.
Business OwnerSync user updates with a central Airtable database
Simplify IT management by keeping a centralized database of user updates. When a new record is added or updated in Airtable, Zapier will trigger Microsoft Office 365 to send a notification via email or update key metrics. This creates better insights into IT asset tracking and user changes.
ITGenerate meeting notes in Airtable after calendar events
Streamline project workflows by creating structured meeting notes. When a new calendar event is created in Microsoft Office 365, Zapier will automatically generate a new record in Airtable. This boosts efficiency by ensuring every meeting is promptly logged and assigned for follow-up.
Project ManagementLearn how to automate Airtable on the Zapier blog
Learn how to automate Microsoft Office 365 on the Zapier blog
Make work flow with AI
Frequently Asked Questions about Airtable + Microsoft Office 365 integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Airtable and Microsoft Office 365
