Airtable automation triggers: Outlook

Note

If your organization uses Microsoft Exchange email servers, only the cloud-based version of that service will work with our Automations feature. On-prem Microsoft Exchange servers are currently not able to integrate with Airtable.

In this article, we will be setting up an automation that creates an Airtable record for any newly created Outlook events that are created. We also have Automation actions for Outlook which you can read more about in this article.

Outlook account authorization

As a prerequisite, you will need to already have a Microsoft account. This account will need to be connected to the Airtable base that you are working in. After choosing which trigger you would like to set up, you will have the option to Manage connected accounts or Connect new account. This authorization process is scoped to each Outlook service, so you will need to perform this process multiple times, at least once for each Outlook trigger, and also for reauthorizations in the future as needed. Jump down to the section below for more information on security and OAuth scopes.

Understanding Outlook triggers in automations

When building an Automation we offer several triggers that can be used with Outlook including:

• When a new email is received in Outlook Email - This trigger fires whenever a new email is received in an Outlook Email account’s inbox.

  • Basic details about the email such as its ID, sender, to/cc/bcc recipients, reply to addresses, message body, received date, importance, and its permalink are included in the output of the trigger. Attachments are not included in the output.

  • Please note that this trigger will only work for brand-new emails received in your account after the automation is turned on. This trigger will not work retroactively on emails transferred to the selected folder that were received before the automation was enabled. As a workaround to get the automation to trigger, you could forward the existing emails to yourself. This would then trigger the automation since those emails would be considered new emails received after turning the automation on.

    • Additionally, the automation logic looks to the “Received Date” of the email to determine if the email is "new" or not. Customers using email rules to automatically route emails into the desired folder shouldn't run into an issue with this automation triggering, however, those who are manually moving or copying emails into the folder may. If the “Received Date” of the email that they're manually moving is before the date of the last email in that folder chronologically, then the automation will not trigger. For example, if the most recent received date of an email in the desired folder is April 23rd and the user attempts to move an email with the received date of April 22nd, the automation will not trigger.

    • As a best practice, we recommend setting up rules in Outlook to automatically move emails into your desired folder. If you need to manually move emails into the folder, please make sure that the Date Received of the email you're moving is after the most recent email.

• When an event is created in Outlook Calendar - The trigger fires whenever an event is created in a specified Outlook Calendar.

  • The trigger’s output includes information about the created event such as its ID, title, description, start time, end time, location, creator, importance, when it was created, when it was last updated, the email addresses of its attendees, its video conferencing link if it has one, and it’s permalink.

  • A reference to an Outlook Calendar's Event ID is necessary for the “Update event” Outlook Calendar action. If you plan to create an automation to update Outlook Calendar events at any point in the future we strongly recommend creating and storing a separate field on your table to keep track of the Outlook Calendar Event ID for any events you intend to update from Airtable.

• When an event is changed in Outlook Calendar - This trigger fires whenever an Outlook Calendar event has any saved changes to the event details.

  • For this trigger to find and match an Outlook Calendar event in your table, you’ll need to include the Outlook Event ID in your Airtable record (or in whatever source you’re using to store calendar events).

Using Outlook triggers in automations

Security and OAuth scopes

FAQs