This easy-to-follow tutorial will run through how to import Google Calendar events into Airtable using the free Data Fetcher extension.
Google Calendar is cloud-based time management and scheduling calendar software available for free and provides an easy way to share calendars and events with others.
Data Fetcher's Google Calendar Airtable integration is an easy way to connect to the Google Calendar API in Airtable without code.
Firstly, add Data Fetcher to your Airtable base by visiting the Airtable marketplace. Data Fetcher is a free extension for importing different types of data into Airtable, such as Google Calendar events.
Once you've added the extension to your Airtable base, create a Data Fetcher account or sign in to your existing account using the 'Have an account?' button on the bottom left.
You can also sign-up for Data Fetcher with your Google account by selecting 'Continue with Google'.
Click on 'Create your first request' from the Data Fetcher home screen.
Data Fetcher requests enable data importing into Airtable. You can create multiple requests within one installation of Data Fetcher in an Airtable base.
On the create request screen, select 'Google Calendar' for Application to use the Google Calendar Airtable integration.
Under Authorization click on "+ New Google Calender connection".
Sign into your Google account on the popup screen.
Next, authorize Google Calendar access to your Data Fetcher account.
You'll now see the connection to your Google account. Give your request a name such as 'Import Google Calendar Events' and click 'Save & Continue.'
From the dropdown menu, choose the Google Calendar you want to import data from.
Select the Start date you wish to import data from (i.e. only events after this date).
Select the End date you wish to import data up until (i.e. only events before this date).
Ensure your Airtable Output Table & View are selected, then click 'Save & Run.'
The Response field mapping modal will open. This is where you specify which data fields to import using the Google Calendar Airtable integration.
You can either map each field to an existing field in your spreadsheet or create a new one. You can also choose an Airtable field type for any new fields and give it a name.
Click Filter all to remove any pre-selected fields, then use the Find field search bar to locate the fields you want to import.
For our Google Calendar example, we will import the following fields: 'Id', 'Name', 'Start time', 'End time', 'URL', 'Status'.
Map the 'Name' field to the existing 'Name' field in Airtable and make sure you import the 'Id' field as we'll use this to ensure our data is syncing properly.
Click 'Save & Run'.
You will now be able to view your Airtable output table, where all of the data relating to your Google Calendar events has populated.
To ensure Data Fetcher can match up data from our Google Calendar events with our records in Airtable, navigate to 'Advanced settings' in Data Fetcher and for Update Based on Field select 'Id'. (We can use any unique field such as 'Id' to do this.)
At the moment, you need to manually run your Data Fetcher request to import any new Calander events or updates to existing ones. It is possible to run the Google Calendar Airtable integration automatically using Data Fetcher's scheduling feature.
You will need to upgrade your workspace to this, so in Data Fetcher, scroll to Schedule and click 'Upgrade'.
Choose a plan from the different options depending on your needs and enter your payment details.
Back in Data Fetcher, click 'I've done this'.
Click 'Add API key' and copy and paste your Airtable API key. You can find your Airtable API key here.
Enter your Airtable API key and click 'Save'.
Toggle Schedule this request to on.
Select a schedule for the Google Calendar Airtable integration based on intervals of 'Minutes', 'Hours', 'Days' or 'Months'. Click 'Save', and any changes to your Google Calendar events will automatically import into your Airtable base on your chosen schedule.