How to Import Google Sheets Data to Airtable

Aug 24, 2022Rosie Threlfall

It's easy to import data from Google Sheets into Airtable using the free Data Fetcher Airtable extension. In this step-by-step guide, you'll learn to connect Google Sheets to Airtable and import the rows of Sheets data as records in an Airtable table. Then you'll learn to schedule the Google Sheets Airtable integration to run automatically.

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 extension 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 extension, click 'Create your first request'.

Click Create Your First Request

Next, for Application, select 'Google Sheets' to use the Google Sheets Airtable integration.

Google Sheets Application

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

New Google Sheets connection

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

google oauth select account.png

On the next screen, 'Select all' to give Data Fetcher all the permissions it needs. Then click 'Continue'.

google sheets oauth permisions.png

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

google sheets save and continue.png

On the next screen, click on the Spreadsheet input to open a new window on datafetcher.com.

select google sheets spreadsheet input.png

Click the 'Select Google Drive Spreadsheet' button.

select Google Drive spreadsheet button.png

Choose the Google Sheet you want to import into Airtable, and click 'Select'.

select spreadsheet in drive.png

The window will close automatically, and you will be taken back to Data Fetcher with the spreadsheet selected.

Select the Sheet you want to import data from using the Google Sheets Airtable integration. The sheet is another name for the tab in your Google Sheet.

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

By default, Data Fetcher will import the entire sheet into Airtable, ignoring any empty rows/ columns. You can enter a Range (e.g. 'A1:B20') to import only a particular range of data from the sheet.

google sheets range.png

First row is field names is set as true as default, but you can toggle this off if the first row of your data does not contain field names.

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

Then 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

Automatic Google Sheets Airtable Integration

Currently you need to manually click 'Run' to import any updates to your Google Sheets Data. It's possible to run the Google Sheets Airtable integration automatically at regular intervals, so any changes in the Google Sheet are synced in the Airtable. 

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 pricing plans.png

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

schedule-upgrade.png

Under Schedule click '+ Authorize'.

Schedule Data Fetcher

A window will now open, allowing you to authorize the Airtable bases you want Data Fetcher to have access to.

If you select 'All current and future bases in all current and future workspaces' this should avoid any issues with unauthorized bases in the future.

Then, click 'Grant access'.

schedule-authorize-bases.jpg

Schedule this request will now be switched on in Data Fetcher.

Select a schedule for the Google Sheets Airtable integration 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 this request

Related Posts

Google Sheets to Airtable Sync with Linked Records

Google Sheets to Airtable Sync with Linked Records

May 7, 2024

Andy Cloke

GoogleGoogle Sheets
How to Import Google Ads Data to Airtable

How to Import Google Ads Data to Airtable

May 26, 2022

Rosie Threlfall

Google