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 record is created. Optionally: triggers when any record (new or existing) is first added to a selected view.

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

    Create a new row in a specific spreadsheet.

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • BaseRequired

    • TableRequired

    • Limit to View

    • Include file contents?

    Trigger
    Scheduled
    Try It
    • BaseRequired

    • TableRequired

    Action
    Write
    • BaseRequired

    • TableRequired

    • Lookup FieldRequired

    • Secondary Lookup Field

    Action
    Write
    • BaseRequired

    • TableRequired

    • RecordRequired

    Action
    Write
    • BaseRequired

    • TableRequired

    • Help Text

    • Which timestamp field should this Zap use to check for updates?Required

    • Limit to View

    • Include file contents?

    Trigger
    Scheduled
    Try It
    • Cache Copy

    • BaseRequired

    • TableRequired

    Action
    Write
    • BaseRequired

    • TableRequired

    • RecordRequired

    Action
    Write
    • HTTP MethodRequired

    • URLRequired

    • Query String Parameters

    • Headers

    • Additional Request Headers

    • Body

    Action
    Write
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 moreHelp

Related categories

  • Databases

Similar apps

Quickbase integrationsQuickbase integrations

Quickbase

Databases
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet 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 moreHelp

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets