Function - Google Sheets Table Sync

Google Function
Table Management

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

Important: 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.

_________________________________

[Google Sheets Table Sync Instructions Video Coming Soon!]

_________________________________

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.

Set up your Common Function Configurations - Source Connection, Source Configuration, and Trigger Mode

Set up your Function Configuration

_______________________________________

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

_______________________________________

Next, Test Your Function

Before using your Function, you must test it.

Then, Install Your Function
Was this article helpful?
Cancel
Thank you!