How to integrate Google Sheets – Airtable bundle using Zapier?

Easily sync new Google Sheets rows with Airtable records using Zapier’s seamless integration. Follow our step-by-step guide to streamline data transfer and boost efficiency.

Creating a new record on Airtable when a new row is created on a spreadsheet on Google Sheets 

A step by step guide for integrating Google Sheets – Airtable bundle using Zapier

1. Setting up Google Sheets

• First, create a spreadsheet in Google Sheets that will contain data, like in the example:
  • Name
  • Email
  • Status
  • Date
  • We’re going to fill out those fields with test data.

2. Setting up Airtable

• Create an Airtable database, adding rows from your Sheets. Example:
  • Name -> type single line text
  • Email -> type email
  • Status-> type single line text
  • Date -> type date

How the integration works:

• A new row is created on Google Sheets;
• Zapier adds the data to the corresponding fields on Airtable.

1. On the Home tab, click on “Create”: 

2. Select “Zaps”.

Adding a trigger event

3. Click on the “Trigger” button.

4. Select Google Sheets as trigger app

5. Select the trigger: In “Trigger Event” field select “New Spreadsheet Row” (fig. 1). Link your Google account (fig. 2-3), Click on “Continue (fig.4).

6. Select what Spreadsheet and Worksheet Zapier should check, and click on “Continue”.

7. Test the trigger by clicking on “Test trigger” button.

8. Then the system should find and display all the information. Click on “Continue with selected record”.

Adding an action to Airtable.

1. Select the app

2. Select the trigger: In “Action Event” field select “Create record” (fig. 1). Link your Airtable account (fig. 2-3) Click on “Continue (fig.4)..

Don’t forget to select the database and click on “Grant access”

3. Set up the action:

• Select your Airtable database where new data should be transferred to.

Link Google Sheets rows with corresponding rows in the Airtable database.. 

• Connect “Name” field on Google Sheets to the same field on Airtable.

• Connect “Email” field on Google Sheets to the same field on Airtable.

• Connect “Status” field on Google Sheets to the same field on Airtable.

• Connect “Date” field on Google Sheets to the same field on Airtable.

When done, click “Continue”.

4. Testing the integration

Test & Continue: Click on  “Test Step” to check if the is transmitting correctly between Airtable and Google Sheets.

5. If everything is correct, click “Publish” to publish the data to Airtable.

6. Check your Airtable database and make sure that the data is correct.

7. If yes, click on “Transfer existing data” to transfer the remaining data.

8. Select the rows you need to transfer and click “Next”, then click on “Send data”.

9. If everything is correct, click on “Turn on Zap”.
10. From now on, everytime new rows get created on the spreadsheet, the data from the specified rows will be sent to an according Airtable database.