Import Airtable Data to Google Sheets
This guide will walk through how to pull data from the Airtable API directly into Google Sheets, using the API Connector add-on for Sheets. We’ll first get an API key from Airtable, and then set up a request to pull in Airtable API data to your spreadsheet.
- Before You Begin
- Part 1: Get your Airtable API Key
- Part 2: Create your API Request URL
- Part 3: Pull API Data into Sheets
- Part 4: Handle Pagination
Before You Begin
Click here to install the API Connector add-on from the Google Marketplace.
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 > Open.
- In the Create tab, enter the Request URL we just created
- Under Headers, enter Authorization as your Key, and Bearer YOUR_API_KEY as the value:
- Create a new tab and click ‘Set current’ to use that tab as your data destination.
- Name your request and click Run. A moment later you’ll see your Airtable base data printed into your sheet:
Part 4: Handle Pagination
- 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.
- With API Connector you can loop through pages automatically with cursor pagination handling (paid feature), like this:
- API URL: enter your request URL as usual
- Pagination type:
- Next token parameter:
- Next token field:
- Number of pages: enter the number of pages you’d like to fetch