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

1. While logged into Airtable, click the Account icon in the top right corner.
   
2. Scroll down the page and click Generate API Key:
   
3. 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

1. 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:
   
2. Once you click in to your base, you’ll see your API URL details displayed in the documentation, like this:
   
3. 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:

   https://api.airtable.com/v0/appd80HFp4KuBLNQY/Dishes

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.

1. Open up Google Sheets and click Add-ons > API Connector > Open.
2. In the Create tab, enter the Request URL we just created
   
3. Under Headers, enter Authorization as your Key, and Bearer YOUR_API_KEY as the value:
   
4. Create a new tab and click ‘Set current’ to use that tab as your data destination.
5. Name your request and click Run. A moment later you’ll see your Airtable base data printed into your sheet:

Part 4: Handle Pagination

1. 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.
   
2. To access more than 100 records, add the ‘offset’ parameter like this:

   page 1: https://api.airtable.com/v0/appd80HFp4KuBLNQY/Dishes

   page 2: https://api.airtable.com/v0/appd80HFp4KuBLNQY/Dishes?offset=itrwyeZMguBUWaIqB/rec41l0SKwP8nSuWk

   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.
   

   
3. 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: cursor
   • Next token parameter: offset
   • Next token field: offset
   • Number of pages: enter the number of pages you’d like to fetch