Airtable is an online collaboration platform for creating and sharing relational databases.
Prerequisites
To connect Airtable to Savant, you need an Airtable account.
Set Up Google Sheets in Savant
In Airtable
Retrieve your Base ID
Open your base in a compatible web browser.
Locate the URL in the address bar, which looks like the example below. The Base ID is the string following "app".
Generate a Personal Access Token
To create a Personal Access Token:
Log in to your Airtable account.
Go to the Developer Hub from the Account menu.
Select "Personal Access Tokens" and click on "Create new token."
Remember to save this token for configuring the connector in Savant.
Add scopes: Grant all available scopes for Savant to function correctly.
Configure Access: Specify the bases this token should access, including those expected to connect to Savant.
In Savant
Enter the Base ID from the URL of the Airtable you want to connect to.
Enter your generated Access Token.
Enter the table name exactly as it appears in Airtable for the connection.
NOTE: Table names must be one word and contain no special characters.
Read Data from Airtable
Learn how to create datasets from Savant’s Airtable connector here.
Available Objects
Each Airtable table connected to Savant includes three objects: the table itself, table_Attachments, and table_Collaborators.
Write Data to Airtable
Step 1: Create/Update Tab
Choose whether to create a new table or update an existing one in your destination.
Select a table from the dropdown or specify the new table name.
Step 2: Replace/Insert
Replace: Replace all existing data in the selected worksheet/tab with the latest output from Savant.
Insert: Append (insert at the bottom) Savant's data to the existing data in your workbook based on column names.
Step 4: Select/Map Fields
Creating a New Tab: Choose the columns to include in the destination.
Updating an Existing Tab: Map columns from Savant to your worksheet/tab. Use Savant’s Automap to fill in matching column names between Savant and your destination automatically.
Understanding Airtable's Limitations
Refer to Airtable’s API Help Documentation to understand Scopes and Rate Limits.