✨ Instagram integration is live! Tutorial

How to Import Google Calendar Events to Airtable

Sep 26, 2022Rosie Threlfall

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.

Install Data Fetcher

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.

Group 1Data Fetcher Sign Up .png

You can also sign-up for Data Fetcher with your Google account by selecting 'Continue with Google'. 

Import Google Calendar Events to Airtable

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.

Create your first request in Data Fetcher

On the create request screen, select 'Google Calendar' for Application to use the Google Calendar Airtable integration.

Google-Calendar-1.jpg

Under Authorization click on "+ New Google Calender connection".

Google-Calendar-2.jpg

Sign into your Google account on the popup screen.

Google-Calendar-3.jpg

Next, authorize Google Calendar access to your Data Fetcher account.

Click 'Continue'.

Google-Calendar-4.jpg

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.'

Google-Calendar-5.jpg

From the dropdown menu, choose the Google Calendar you want to import data from.

Google-Calendar-6.jpg

Select the Start date you wish to import data from (i.e. only events after this date).

Google-Calendar-7.jpg

Select the End date you wish to import data up until (i.e. only events before this date).

Google-Calendar-8.jpg

Ensure your Airtable Output Table & View are selected, then click 'Save & Run.' 

Google-Calendar-9.jpg


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'.

Google-Calendar-10.jpg

You will now be able to view your Airtable output table, where all of the data relating to your Google Calendar events has populated.

Google-Calendar-11.jpg

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.)

Click 'Save'

toggl-Id.png

Automatic Google Calendar Airtable Integration

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'.

schedule-requests.png

Choose a plan from the different options depending on your needs and enter your payment details.

data fetcher upgrade options

Back in Data Fetcher, click 'I've done this'.

schedule-upgrade.png

Click 'Add API key' and copy and paste your Airtable API key. You can find your Airtable API key here.

Group 11(1).png

Enter your Airtable API key and click 'Save'.

save-airtable-api-key.png

Toggle Schedule this request to on.

schedule-data-fetcher-request.png

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.

schedule-a-sequence-intervals.png

Other Recent Posts

Get a Favicon from a Website in Airtable

Get a Favicon from a Website in Airtable

Oct 27, 2022

Rosie Threlfall

Icon