Search API Connector Documentation
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: Fetch Data from Airtable
- Part 3: Create a Custom Request
- Part 4: Handle Pagination
- Part 5: API Documentation
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: Fetch Data from Airtable
The easiest way to get started with the Airtable API is through API Connector’s built-in integration.
- Select Airtable from the drop-down list of applications
- Under Authorization, enter your API key with the word
Bearerin front of it.
- There’s only one endpoint for Airtable so skip straight to the required
table_idvariables. Airtable provides these values for you in the documentation at https://airtable.com/api, so grab them there and copy/paste them in.
- For now you can skip the non-required parameters. If you like,you can use them later to customize your report.
- Set a destination sheet, name your request, and click Run to see data from your Airtable base in your sheet.
Part 3: Create a Custom Request
Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration. When you create a custom request, add your complete URL into the request URL field and a Header where Key =
Authorization, Value =
By default, the Airtable API will return all the data in your base, which can result in many more columns than you need. To limit the data you return, add a parameter for each field you want with the syntax fields=field name, like this:
Part 4: Handle Pagination
- Airtable limits the number of records returned in each request. By default, only 100 records will be returned.
- To access more than 100 records, loop through with the offset parameter as described. With API Connector you can do this automatically with cursor pagination handling (paid feature), like this:
- Pagination type:
- Next token parameter:
- Next token path:
- Run until: choose when the request should stop running
- Pagination type:
Part 5: API Documentation
Official documentation: https://airtable.com/api