ūüĒ• Google Sheets integration is live! Learn more

How to Import Google Sheets Data to Airtable

Aug 24, 2022‚ÄĘRosie Threlfall

It's easy to import data from Google Sheets into Airtable. All you'll need is the free Data Fetcher Airtable extension and to follow this step-by-step guide. Data Fetcher enables a connection to be established between Google Sheets and Airtable in order to transfer data back and forth. Data Fetcher can also be used with a huge variety of other different applications, including Google Analytics, Google Ads and Google Maps.

Install Data Fetcher

Install Data Fetcher from the Airtable app marketplace. Sign up for a Data Fetcher account by entering your name, email address and password and clicking 'Sign up for free'. Alternatively, sign up using your Google account.

If you already have a Data Fetcher account, then sign in using the link at the bottom left of the screen.

Data Fetcher Sign Up

Import Google Sheets Data into Airtable

Requests in Data Fetcher enable you to import data to or send data from an Airtable base. On the home screen of the Data Fetcher app, click 'Create your first request'.

Click Create Your First Request

Next, for Application, select 'Google Sheets'.

Google Sheets Application

Under Authorization, select '+New Google Sheets Connection'.

New Google Sheets connection

You'll be prompted to sign into the Google Account where your Google Sheets data is.

Sign into Google

Next, check the two boxes to authorize Data Fetcher access to your Google account and click 'Continue'.

Connect Google to Data Fetcher

Give the request a name such as 'Import Google Sheets Data' and click 'Save & Continue'.

Google Sheets to Airtable  Import

On the next screen select the Google Sheets Spreadsheet you want to import data from.

Google Sheets to Airtable Import

And the Sheet you want to import data from.

Google Sheets to Airtable

For Major Dimension select whether your data is stored as rows or columns in your spreadsheet (rows is pre-selected by default.)

Google Sheets Data Fetcher Settings

First row in Sheet is field names is set as true as default, but you can toggle this off if required.

Google Sheets Data Fetcher

This means that the field names will be taken from the first row in the spreadsheet.

google-sheets-14.png

Or if no field names have been specified, then toggle this option off to set them yourself when the spreadsheet data imports.

google-sheets-13.png

Make sure Output Table & View are set to the Airtable table you want to import Sheets data into and click 'Save & Run.'

Google Sheets Data Fetcher Settings

Data Fetcher will now connect to Google Sheets and the Response field mapping modal will open. This is where you can specify which fields to import from Google Sheets and how they will map to your output table. 

For each field, you can either import or filter it out, and you can either map data to a new field or to an existing field. For this example, we'll import all the fields from the Google spreadsheet, which will all be pre-selected and mapped to new fields. 

Here you can also set the 'type' of the Airtable fields, so for this example, we'll set both the 'Unit Cost' and the 'Total' fields to 'Currency'.

Click 'Save & Run'.

Google Sheets Import

You'll now see all of your Google Sheets data in your Airtable Spreadsheet. New fields will have been created to match the name of your columns in Google Sheets.

Google Sheets import into Airtable

In order to ensure Data Fetcher is able to check all data is syncing correctly with Google Sheets, navigate to 'Advanced settings' in Data Fetcher. Open the advanced output settings, and for Update Based on Field, select 'Reference number'. This needs to be a unique field such as an Id, Order number of Reference number to keep our Airtable records in sync with the rows in our Google Sheet.

Click 'Save'.

Google Sheets Output Table

Schedule Google Sheets Data to import into Airtable Automatically

Currently, you'd need to manually click 'Run' in Data Fetcher to import any updates to your Google Sheets Data, but it is possible to run the request automatically at regular intervals, so Data Fetcher will periodically import any changes from your Google Sheet. 

This is a paid Data Fetcher feature, so if you haven't already, you will need to upgrade your account. 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 based on intervals of 'Minutes', 'Hours', 'Days' or 'Months'. Click 'Save', and any new data from your Google sheet will automatically import into your Airtable base on your chosen schedule.

schedule-a-sequence-intervals.png

Related Posts

How to Import Google Ads Data to Airtable

How to Import Google Ads Data to Airtable

May 26, 2022

‚ÄĘ

Rosie Threlfall

‚ÄĘGoogle
How to Import Google Analytics Data to Airtable

How to Import Google Analytics Data to Airtable

May 23, 2022

‚ÄĘ

Rosie Threlfall

‚ÄĘGoogleGoogle Analytics
How to Import YouTube Analytics Data to Airtable

How to Import YouTube Analytics Data to Airtable

Jan 31, 2022

‚ÄĘ

Andy Cloke

‚ÄĘGoogleYouTubeYouTube Analytics