Much like new events, you need to create a zap with a trigger from your calendar app of choice.If it does, turn on your zap and you’re good to go. Test this step to make sure the sample calendar data shows up in your base where you expect it.When you have Airtable connected, choose New Record as this step’s action and fill in Zapier’s template so that the sample calendar data you got from your trigger setup matches with the correct fields in your Airtable base. If you haven’t used Airtable with Zapier before, make sure to follow these setup steps before you continue.Choose the calendar that Zapier should watch, test the trigger to get sample data to work with, and then create a new action step that uses Airtable.Other apps tend to split these actions up, so we’ll focus on new events first. Google Calendar has the unique option of triggering on new and updated events in a single trigger. Create a zap that triggers on a New Event added to your calendar.Let’s go over the basic steps in this process. If you use a different calendar app, however, you need to create a set of zaps that work in a similar way. Again, this will not sync updated records from Airtable but we’ll discuss workarounds in a bit. Let’s start with the easy stuff first and worry about the more complex details afterwards.įirst, if you use Google Calendar, you’re in luck-you can just use these pre-made zaps to set up sync. You can work around this limitation but it requires a more complex setup. However, Zapier can only find new events in Airtable, so any updated records in Airtable won’t sync through standard methods. Zapier can also perform similar operations with services like Cronofy. Zapier can grab new and updated events from Google Calendar and Microsoft Office 365 but not Apple Calendar. Some of this process requires multi-step zaps, so make sure you have an account type that allows this. Setting up a two-way sync with Zapier can range from simple to complex depending on how much you need to accomplish. This allows you to add events in Airtable and another calendar app and have them show up in both. If neither one-way method fits your workflow, you can set up two-way sync using a third-party tool like Zapier. For a video walkthrough of this process, check out this support article.
You can repeat this process for any other calendars you need to import now or in the future. Now everything in your exported calendar should show up in the table you chose in Airtable. Click the Create records button when you’re ready and wait for the import to complete.You’ll see real examples of the imported data arranged in the way you select on the right side of the block so you’ll know if anything’s mismatched. Match up the event information from your calendar with the fields in your chosen table.Grab an ICS file you want to import and drag it onto the block to begin the import process.Add the calendar import block to your base.Click the Blocks button in the toolbar to open your blocks dashboard (if it isn’t open already).Choose the table you want to use for your calendar import.Once you have your ICS file(s) ready to go, navigate to the base you want to use and follow these steps:
#Airtable calendar how to#
Here are instructions on how to export to ICS format for the most popular calendar apps: ICS is an open standard for digital calendars, so most calendar apps should export in this format (or at least offer it as one of its export format options). To set up the import process, you’ll need to grab copies of your calendars as ICS files so they’re in the proper format for import.
#Airtable calendar pro#
When you need to perform a one-way import that takes events from your existing calendar app and imports them as new records in Airtable, you can achieve this with the calendar import block ( a pro account feature). In some cases, you may want to move events in the other direction. One-way import: Another calendar app → Airtable It will walk you through this process visually if you need some extra help and offers assistance on subscriptions for specific apps toward the end.