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.

Part 1: Get your Airtable API Key

  1. While logged into Airtable, click the Account icon in the top right corner.
    airtable-img1
  2. Scroll down the page and click Generate API Key:
    airtable-img2
  3. An API key will appear. That’s it! Copy this and keep it safe, we’ll need it shortly.
    airtable-img3

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:
    airtable-img4
  2. Once you click in to your base, you’ll see your API URL details displayed in the documentation, like this:
    airtable-img11
  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 > Create New API Request.
  2. In the Create Request interface, enter the Request URL we just copied.
    airtable-img5
  3. Under Headers, enter Authorization as your Key, and Bearer YOUR_API_KEY as the value:
    airtable-img6
  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:airtable-img7

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.
    airtable-img8
  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.

    airtable-img9
  3. In API Connector, you can run these requests separately, or loop through them automatically using pagination handling (paid feature), like this:
    airtable-img10

Leave a Comment