App Holder
Airtable

Airtable and Google Sheets Integration

Create new rows, search and update them in Google Sheets. Do much more by connecting Airtable and Google Sheets.

Get Started for FREE

Popular Integrations

Google Sheets - New Row (Recommended) Airtable - Add a Record

Sync new Google Sheets rows with Airtable records

If you are working with a spreadsheet and a database simultaneously to store data, keeping them up to date can be tough. You need to regularly switch between the two apps and perform some tedious copy-and-paste work until you’re tired. Save yourself from such a headache using this readymade Google Sheets to Airtable integration template.

When you use this template, every time there is a new row in your Google spreadsheet, a new record will be automatically created in your Airtable database. You can even map the fields you have from your Google spreadsheet to your Airtable so that your data stays in sync.

Simply connect your Google Sheets and Airtable accounts to Automate.io, map the required fields and turn on this integration.

How it works

  • Step 1:

    This Bot runs whenever there is a new row in your Google spreadsheet.

  • Step 2:

    Automate.io creates a record for that row in your Airtable database.

Read More
Airtable - New Record Google Sheets - Add Row (Recommended)

Import Airtable records to a Google spreadsheet

This readymade Airtable to Google Sheets integration template will automatically import or copy every new Airtable record as a new row in your Google Sheets spreadsheet.

To set up the integration, first, connect your Airtable and Google Sheets accounts to Automate.io. Then, select the Base and Table in your Airtable account, and the spreadsheet and worksheet in Google Sheets. Now map the fields you want from Airtable to your Google spreadsheet. The fields you see in Google Sheets will be the column names in your worksheet.

This template even gives you the flexibility to update a row in your Google spreadsheet instead of adding one.

How it works

  • Step 1:

    This Bot runs whenever there is a new record in Airtable.

  • Step 2:

    Automate.io creates a new row in your Google spreadsheet.

Read More
Google Sheets - New Row (Recommended) Airtable - Update a Record

Update a Record in Airtable on a New Row (Recommended) in Google Sheets

Airtable - New Record Google Sheets - Update Row (Recommended)

Update Row (Recommended) in Google Sheets on a New Record in Airtable

Google Sheets - New or Updated Row (Recommended) Airtable - Add a Record

Add a Record in Airtable on a New or Updated Row (Recommended) in Google Sheets

Google Sheets - New or Updated Row (Recommended) Airtable - Update a Record

Update a Record in Airtable on a New or Updated Row (Recommended) in Google Sheets

Looking for something else?


Create your own Integration

Connect Airtable and Google Sheets the way you want. Start by selecting the trigger and action events listed here.

When This Happens

TRIGGERS
  • Airtable - New Record

    New Record

    Triggers when a new record is added to the specified table
  • Google Sheets - New Row (Recommended)

    New Row (Recommended)

    Triggers when a new row is added in a worksheet.
  • Google Sheets - New or Updated Row (Recommended)

    New or Updated Row (Recommended)

    Triggers when a new row is added or existing row is updated in a worksheet
  • Google Sheets - New Spreadsheet

    New Spreadsheet

    Triggers when a new spreadsheet is created.
  • Google Sheets - New Worksheet (Recommended)

    New Worksheet (Recommended)

    Triggers when a new worksheet is created.
  • Google Sheets - New Row (Old version)

    New Row (Old version)

    Triggers when a new row is added in a worksheet. Not recommended. This will stop working from September 29, 2020.
  • Google Sheets - New or Updated Row (Old version)

    New or Updated Row (Old version)

    Triggers when a new row is added or existing row is updated in a worksheet. Not recommended. This will stop working from September 29, 2020.
  • Google Sheets - New Worksheet (Old version)

    New Worksheet (Old version)

    Triggers when a worksheet is created. Not recommended. This will stop working from September 29, 2020.

Do this

ACTIONS
  • Google Sheets - Add Row (Recommended)

    Add Row (Recommended)

    Adds a new row to a given Worksheet
  • Google Sheets - Search Row (Recommended)

    Search Row (Recommended)

    Searches a row based on column value
  • Google Sheets - Update Row (Recommended)

    Update Row (Recommended)

    Updates a row in a given worksheet based on row number
  • Google Sheets - Add a Worksheet

    Add a Worksheet

    Adds a new worksheet to a given spreadsheet
  • Google Sheets - Delete Row (Recommended)

    Delete Row (Recommended)

    Deletes a row from the specified worksheet based on the row number
  • Google Sheets - Add Row (Old version)

    Add Row (Old version)

    Adds a new row to a given worksheet. Not recommended. This will stop working from September 29, 2020.
  • Google Sheets - Delete a Row (Old version)

    Delete a Row (Old version)

    Deletes a row from the specified worksheet based on the row Id. Not recommended. This will stop working from September 29, 2020.
  • Google Sheets - Search Row (Old version)

    Search Row (Old version)

    Searches a row based on column value. Not recommended. This will stop working from September 29, 2020.
  • Google Sheets - Update a Row (Old version)

    Update a Row (Old version)

    Updates a row in a given Worksheet based on row Id. Not recommended. This will stop working from September 29, 2020.
  • Airtable - Add a Record

    Add a Record

    Create a new record in the specified table
  • Airtable - Update a Record

    Update a Record

    Update the selected column cells based on the Record ID
  • Airtable - Search Records

    Search Records

    Search Records using the Field specified

Let's Integrate

Create your custom integration by selecting the Trigger event and Action to be performed.

Run Workflows

Typeform
Wufoo
Google Forms

Forms

Airtable Workflow
Google Sheets Workflow
Mailchimp
AWeber
GetResponse

Marketing

Connect Airtable and Google Sheets with your other apps and run workflows across them. Trigger workflows automatically when things happen in any of the apps.

Try Now

Why Automate.io?

Easy

No coding. No change in your apps. Setup and get going in 2 minutes.

Secure

Runs on secure HTTPS channel & all sensitive data is stored in an encrypted format.

Reliable

Used by 1000+ organizations globally - big and small. Live chat support available.

Automate Work. Have Fun!

Say Goodbye to those busy days

Get Started for FREE

No credit card required.