Skip to main content


Connect Airtable to Google Sheets

Castodia automatically imports fresh data from your Airtable Bases to your Google Sheets on a highly customizable schedule. Auto-refresh data as often as every 1 minute for near real-time data.

How to Connect Airtable Bases to Google Sheets

Castodia lets you pull data from your Airtable Bases directly into Google Sheets.

To connect your Airtable Bases, follow the steps below:‍

  1. Open the Castodia Admin Dashboard
  2. From the Databases Menu, click on Create
  3. Add a nickname for your source connection
  4. From the dropdown menu, select Airtable
  5. Gather and enter your data source API key. How to get a key?
  6. Click the "Test" button to verify your credentials
  7. Click the "Save" button once a green notification pops up, indicating that the add-on was successfully installed.

And that's it! Enjoy running your queries.

How to Get your Airtable API Key


You only need these steps if you don't already have an API key.

  1. Go to and login to your account

  2. On the top right corner, go to Account > Developer hub Developer Hub

  3. Go to the Personal Access Tokens tab on the left side menu Personal Token

  4. Click on Create new token button, located on the top right corner New token

  5. Input a name for your token

  6. Click on Add a Scope and add the following scopes one at a time: data.records:read and schema.bases:read (Note: we only require read-only access scopes. Learn more about Airtable API scopes) Scope records

Scope schema

  1. Select which bases you’d like to access using this token Access

Access selected

  1. Click on Create token Create token

  2. Your Personal access token is created. Copy and store it in a safe place. Click on Done. Copy token

Verify token

  1. You are done! With your Personal access token you are able to connect Airtable on the Castodia admin app. If you need help creating a source on Castodia, please refer to our Integrations page. For more information on Airtable access tokens, please refer to their guide.