Loading

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
Try this template
  • 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

      (Optional) Limit to records added to a specific View, and return records in the View order.

    • Include file contents?

      Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.

    Trigger
    Scheduled
    Try It
    • BaseRequired

      Base in which to create the record.

    • TableRequired

    Action
    Write
    • BaseRequired

      Pick the Airtable base containing the records you wish to update.

    • TableRequired

      Pick the Airtable table containing the records you wish to update.

    • RecordRequired

      Pick the Airtable record that you wish to update.

    Action
    Write
    • Api Docs Info

      API docs for Airtable are located here https://airtable.com/api

    • HTTP MethodRequired

    • URLRequired

      Requests can only be made to domains associated by this application.

    • Query String Parameters

      These params will be URL-encoded and appended to the URL when making the request.

    • Headers

      Authentication headers are included automatically

    • Additional Request Headers

      Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.

    • Body

      Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.

    Action
    Write
    • BaseRequired

    • TableRequired

    • Help Text

      You must have at least one "Last Modified Time" type column in your Table in order to use this Trigger. Learn more about those here.

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

      When this column changes to a new timestamp, your Zap will trigger on the corresponding record. Note: Must be a Last Modified Time column type.

    • Limit to View

      Filter on updates to a specific View in your Table.

    • Include file contents?

      Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.

    Trigger
    Scheduled
    Try It
    • BaseRequired

      Base in which to create the record.

    • TableRequired

    Action
    Write
    • Owner

      Determines which App Extensions will appear in the dropdown below.

    • App ExtensionRequired

    Action
    Write
    • BaseRequired

      Base to search for a record.

    • TableRequired

      Pick an Airtable table that you want to search.

    • Search by Field

      Pick a field from the base to match against the search value.

    • Search Value

      The value of unique identifier for the record.

    • Search Formula

      (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.

    • Limit to View

      Limit the search to a specific view. Useful for sorting results.

    • Include file contents?

      Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.

    Action
    Search
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

  • Databases

Similar apps

Quick Base integrationsQuick Base integrations

Quick Base

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 more

Related categories

Similar apps

Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
Quip integrationsQuip 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.