• Airtable logoAirtable logo
  • Google Sheets logoGoogle Sheets logo

Airtable + Google Sheets

Add new Airtable records in views to Google Sheets

Create a back up for your database records with this Airtable to Google Sheets automation. Once set up, each time a new record is added to a selected view in Airtable, Zapier will automatically add a new row into your selected Google Sheets spreadsheet. Prevent losing data when you create copies, and use this integration as an easy way to export Airtable database info to a spreadsheet.

Create a back up for your database records with this Airtable to Google Sheets automation. Once set up, each time a new record is added to a selected view in Airtable, Zapier will automatically add a new row into your selected Google Sheets spreadsheet. Prevent losing data when you create copies, and use this integration as an easy way to export Airtable database info to a spreadsheet.

  1. When this happens...
    AirtableAirtable
    New Record

    Triggers when a new new record is created, optionally limited to a view

    TriggerScheduled
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Spreadsheet Row

    Create a new row in a specific spreadsheet.

    ActionWrite
  • Airtable triggers, actions, and search
    New Record
    Triggers when a new new record is created, optionally limited to a view
    Trigger
    Scheduled
  • Airtable triggers, actions, and search
    New or Updated Record
    Triggers when a record is created or updated.
    Trigger
    Scheduled
  • Airtable triggers, actions, and search
    Create Record
    Creates a new record with auto-populating fields.
    Action
    Write
  • Airtable triggers, actions, and search
    Update Record
    Update the values of specific cells in an Airtable record.
    Action
    Write
  • Airtable triggers, actions, and search
    Find Record
    Use simple field search or Airtable's powerful formula syntax to find a matching Airtable record. Learn more at
    Action
    Search
  • Airtable triggers, actions, and search
    Find or Create Record
    Find or Create Record
    Action
    Search or write
  • Google Sheets triggers, actions, and search
    New Spreadsheet Row (Team Drive)
    Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
    Trigger
    Scheduled
  • Google Sheets triggers, actions, and search
    New Spreadsheet Row
    Triggered when a new row is added to the bottom of a spreadsheet.
    Trigger
    Instant
  • Google Sheets

    Triggered when you create a new spreadsheet.

    Scheduled

    Trigger

  • Google Sheets

    Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.

    Scheduled

    Trigger

  • Google Sheets

    Triggered when a new row is added or modified in a spreadsheet.

    Instant

    Trigger

  • Google Sheets

    Triggered when you create a new worksheet in a spreadsheet.

    Scheduled

    Trigger

  • Google Sheets

    Create a new column in a specific spreadsheet.

    Scheduled

    Action

  • Google Sheets

    Create a new row in a specific spreadsheet.

    Scheduled

    Action

  • Google Sheets

    Create one or more new rows in a specific spreadsheet (with line item support).

    Scheduled

    Action

  • Google Sheets

    Create a new worksheet by copying an existing worksheet.

    Scheduled

    Action

  • Google Sheets

    Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.

    Scheduled

    Action

  • Google Sheets

    Create a blank worksheet with a title. Optionally, provide headers.

    Scheduled

    Action

  • Google Sheets

    Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.

    Scheduled

    Action

  • Google Sheets

    Update a row in a specific spreadsheet.

    Scheduled

    Action

  • Google Sheets

    Finds many matched rows (10 max.) by a column and value.

    Scheduled

    Action

  • Google Sheets

    Returns many rows (20 max.) as a single JSON value and flat rows (line items).

    Scheduled

    Action

  • Google Sheets

    Finds a row by a column and value. Returns the entire row if one is found.

    Scheduled

    Action

  • Google Sheets

    Finds or creates a specific lookup row.

    Scheduled

    Action

airtable logo
airtable logo

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.
Learn more

Related categories

Similar apps

Quick Base integrations

Quick Base

Databases
Zoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrations

Smartsheet

Spreadsheets
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn more

Related categories

Similar apps

Zoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrations

Smartsheet

Spreadsheets
Quip integrations

Quip

Documents

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

Or
By signing up, you agree to Zapier’s Terms of Service and Privacy Policy