Sync Airtable Data into a Google Sheet - Used for full table syncing
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
- General Function Configuration
- Function Configuration - Google Sheets Table Sync
- Test Your Function
- Install Your Function
[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
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 - Source Connection, Source Configuration, and Trigger ModeCommon Function Configurations
- 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
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
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.
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
- Next, ✔Test Your Function
Before using your Function, you must test it.
Install Your Function
- Then, ✔ via a Schedule (recommended), a Zapier zap, an Airtable Automation, a Script in the Scripting app, or directly via REST API.Install Your Function in Your Base