Import Airtable Data to Google Sheets
Airtable is a spreadsheet/database service with flexible query and visualization functionality. While it is often used as a replacement for Sheets, it can still be useful to sync or retrieve data from Airtable into Google Sheets. Therefore, this guide will walk through how to pull data from the Airtable API directly into Google Sheets, using the API Connector add-on. We'll first get an API key from Airtable, and then set up a request to pull in Airtable API data to your spreadsheet.
- Part 1: Get your Airtable API Key
- Part 2: Create your API Request URL
- Part 3: Pull API Data into Sheets
- Part 4: Airtable API Notes
Part 1: Get your Airtable API Key
- While logged into Airtable, click the Account icon in the top right corner.
- Scroll down the page and click Generate API Key:
- An API key will appear. That's it! Copy this and keep it safe, we'll need it shortly.
Part 2: Create your API Request URL
- Start by navigating to https://airtable.com/api to find the access details for your bases. Airtable creates separate APIs for each base, so click your base of interest to find your access details:
- Once you click in to your base, you'll see your API URL details displayed in the documentation, like this:
- These URLs will be customized for your specific base, so just copy the URL you want to your clipboard. It should look something like this:
Part 3: Pull Airtable API Data into Sheets
We can now enter all our values into API Connector and import Airtable data into Google Sheets.
- Open up Google Sheets and click Add-ons > API Connector > Create New API Request.
- In the Create Request interface, enter the Request URL we just copied.
- Under Headers, enter Authorization as your Key, and Bearer YOUR_API_KEY as the value:
- Create a new tab. My table tame is Dishes so I'll call my sheet 'Dishes,' too. While still in that tab, click 'Set' to use that tab as your data destination.
- Name your request. Again we'll call it 'Dishes'
- Click Run and a moment later you’ll see your Airtable base data printed into your sheet:
Part 4: Airtable API + Sheets Notes
- Note that Airtable limits the number of records returned in each request. By default, only 100 records will be returned unless you use the 'offset' parameter as described in their documentation.
- To access more than 100 records, add the 'offset' parameter like this:
You can find the value to populate the 'offset' parameter in the 'offset' field. It will only be present if there are still additional records available.
- In API Connector, you can run these requests separately, or loop through them automatically using pagination handling (paid feature)