Select Page
Function - Google Sheets Full Table Sync
Function - Google Sheets Full Table Sync

Function - Google Sheets Full Table Sync

Sync Airtable Data into a Google Sheet - Used for full table syncing

🔴 On2Air Docs has been shutdown to focus on our On2Air Backups Airtable app Learn more about automated Airtable backups - on2air.com

Before setting up this Function, you need to have a Google Sheet file already created in your Drive. It can be blank or it can have other information.

In this article

[Google Sheets Table Sync Instructions Video Coming Soon!]

General Function Configuration

  • Click Create New Function
  • Click Add Configuration
  • Set up Sync Mode
  • Sync Mode (Required) - Select how to sync between Airtable/Google Sheets

OPTIONS:

Airtable ----> Google Sheets - Sync from Airtable to Google Sheets Google Sheets -----> Airtable - Sync Mode not currently supported. If interested in that approach, please contact us and let us know via the help widget.

Dual (2-Way) Sync between Google Sheets and Airtable - Sync Mode not currently supported. If interested in that approach, please contact us and let us know via the help widget.

Function Configuration - Google Sheets Table Sync

Google Connection (Required) - Select a Google Connection to use

Source Worksheets File (Required) - Select the source Google Sheets File where you want to sync Airtable

Source Sheet Tab Name (Sheets Tab) (Required) - Manually enter the Source Sheet (Tab) name to sync with Airtable

Table Start Cell (Required) - Manually enter the Cell Location (Ex: A1) of where the Table Starts (include headers if applicable - see next step)

Headers (Required) - Choose how to process headers

OPTIONS:

Use Existing Header in Sheet - Existing Headers should begin in cell A1 Create Header from Airtable Fields - Headers will be created starting in cell A1 Not Using Header - No Headers will be created. Data will begin in cell A1

Data Source (Required) - Select how to process Airtable data source fields

OPTIONS:

Map Fields & Order - Map each Airtable field to the corresponding field in Sheets Use Sheet Header Names - Use the Header Names in Sheets Using Header Names must match exactly (including Case) with the Airtable Field names. If any column does not match, it will be ignored. Be sure to keep Header Names in sync with any changes you make in Airtable.

Map Airtable Fields to Sheet Columns (Displayed with 'Map Fields & Order) - Select the Airtable Field on the Left

If you want to customize which specific Sheets column you want for each field, you can enter the Sheets Column Start Letter on the Right. (However, it's recommended to leave them blank.) If the Sheets Column is left blank, it will use the next incremental column from the start cell. Add as many as needed.

Note: Sheets will only display 26 columns. If you have more than 26 columns in Airtable that you are displaying, you will need to go into Sheets and manually add new columns the first time before beginning the automation process.

Advanced Options

Linked Record Names - If enabled, this will replace the Linked Record IDs with the Linked Record Primary Field Value

Caution: This will count towards your record monthly usage on each execution. We're not able to bring in the actual value names due to limitations from the Airtable API. This option allows us to process additional information but requires an additional query to the Linked Table Record table. You can avoid this option by using a Lookup field that looks up the name of records and using it as a field

Remove Deleted Records - Remove deleted records when processing the sync Deleting Removed Records from Sheets is only available when Trigger Mode is 'All View Records'

  • Click Save Action Function Details

Test Your Function

Before using your Function, you must test it.

Install Your Function