Overview
In this tutorial we're going to show you how to sync data from Airtable into Google Sheets using the SyncWith addon to talk to the AirTable API. We'll assume that you already have an Airtable account, and at least one table of data there.
Step 1: Get your API key
Airtable has an API and will let you access it using a key.
Go to https://airtable.com/account and you can find your API key there.
Step 2: Get the ID of the base to get your data from
AirTable stores data in Bases.
- Go to https://airtable.com/api to see a list of your bases
- Click on the one you want
- Find the base ID in the text
The ID of this base is
Step 3: Make sure you know the name of the Table
On the base page you clicked on just above, there will be a list of your tables, you need the table's name that you want to get data from.
Step 4: Setup the connection
We'll use the endpoint /v0/{base}/{table} to fetch data about the table.
- Paste
https://api.airtable.com/v0/{base}/{table}into the SyncWith addon
- Enter your API key, base ID and table name
- Hit Preview (or Run)
- Use the
+ Expandbutton to unpack the nested fields into columns
Try it now!
Replace
<ApiKeyHere> with your Airtable API Key.