Airtable Sync integration: Outlook Calendar
  • 02 Aug 2022
  • 2 Minutes to read
  • Dark
    Light

Airtable Sync integration: Outlook Calendar

  • Dark
    Light

Airtable Sync integration allows you to bring information from external tools into a single, centralized table within Airtable. This article covers how to sync with an external Outlook Calendar in order to bring detailed information from events in an Outlook Calendar into Airtable.

If you haven’t set up a sync before, we recommend first reading the Sync - Basic setup article to become familiarized with how sync works.

Add a new synced table

You can find the option to sync with Outlook Calendar by pressing the “+” button next to the table furthest to the right in your base.

4405309062807addOutlookSync4Fields.png

Select Outlook Calendar account

Next up, if this is the first time you are connecting your Airtable account with Outlook Calendar, then you will need to press the “+ Connect new account” button.

4405309073303connectNewAccountOutlookCalendar.png

This will bring up a new window where you will enter your Microsoft credentials. In some cases, you may need to try other “Sign-in options” in order to connect your Outlook Calendar account with Airtable. Jump down to the section below for more information on security and OAuth scopes.

Select Calendar and date range

After successfully connecting to your Outlook Calendar account you should see a list of all of the Calendars you have under that Microsoft login.

4405313858839outlookSelectCalendar.jpeg

After choosing your preferred Calendar, you will need to select a start and end date range.

4405309116951outlookDateRange.jpeg

your title goes here

Due to limitations within Microsoft’s API, the maximum date range that you set cannot be longer than 5 years. You will see an error message after clicking “Next” if you attempt to set a date range longer than 5 years. 4405313901463outlook5YearLimit.jpeg

Select fields to sync

After clicking next, you’ll be presented with two sync options; you can sync:

  1. All fields from the Outlook Calendar source, including any fields added by Outlook in the future.
  2. Specific fields from the Outlook Calendar source.

4405309182359selectFieldToSyncOutlookCalendar.jpeg

If you choose to sync specific fields you’ll be shown a menu where you can toggle each individual field that you want to sync from your Outlook Calendar. There are 14 fixed fields that will sync from Outlook Calendar if the “All fields in the source view and fields added in the future” option is chosen.

1. Title6. Importance11. Updated
2. Start7. Location12. Event Link
3. End8. Description13. Meeting Link
4. All Day9. Attendees14. Event ID
5. Creator10. Created

Create synced table

Before creating your synced table, there are some “Settings” options that allow you choose how often you want to sync, and how to handle records deleted or hidden in the Outlook Calendar source.

  • The frequency of syncing. Right now, the options are manual syncing and automatic syncing which happens around every 5 minutes.
  • Whether or not deleted Outlook Calendar events should be removed from the Airtable table. By default, deleted events will be removed.

4405309226135syncSettingsGeneral.jpeg

Once you’ve selected your desired settings, click the “Create table” button. This will cause a new table to be created in your base.
4405314282775outlookCalendarCreateTable.gif

Security and OAuth scopes

Authentication

We request the minimum read/write scopes necessary to make the Airtable Sync integration work. The OAuth consent screen will look like this:

4405309100439outlookSignInOutlookCalendarSync.png

The access approval screen will appear next. Clicking "Yes" means that you will allow us to access the necessary scopes to allow the automation to work.

4408095197207OutlookCalendarScopeAccess.svg

Outlook scopes

Scope nameScope purpose
offline_accessFor refresh token
profileFor user metadata
openidFor sign-in
Mail.ReadWriteFor reading/writing emails (Only for Outlook Email automations)
Mail.SendFor sending mail (Only for Outlook Email automations)

We use delegated permissions for all of our Outlook integrations and tokens are transmitted between Airtable and Microsoft’s servers securely via HTTPS. On Airtable’s side, the tokens are stored in databases that are encrypted at rest.

For more information on Outlook scopes, check out Microsoft's documentation here.


Was this article helpful?