Skip to main content
Connect Adapt to Airtable to read your bases, tables, and records and analyze your data using natural language. Adapt reads from Airtable through its API, so you can explore your data without exporting it by hand.

​
Set up credentials

Airtable deprecated legacy API keys on February 1, 2024. You now authenticate with a personal access token that you create with specific scopes and base access.
1

Open the token page

Go to airtable.com/create/tokens in the Builder Hub and click Create new token.
2

Name your token

Give the token a descriptive name so you can recognize it later.
3

Add scopes

Click Add a scope and add the read scopes Adapt needs, such as:
  • data.records:read
  • schema.bases:read
4

Add base access

Click Add a base and select the specific bases (or workspaces) you want Adapt to access.
5

Create and copy the token

Click Create token, then copy and store the token immediately. Airtable shows it only once.
A personal access token acts as your Airtable user and is limited to the scopes and bases you grant. Add only the read scopes and bases Adapt needs.

​
Connect to Adapt

1

Open Integrations

In Adapt, go to Settings > Integrations.
2

Find Airtable

Search for Airtable and select it from the catalog.
3

Start the connection

Click Connect to open the connection form.
4

Add your credentials

Enter the values you gathered above, then click Add connection:
Secret NameValue
AIRTABLE_API_KEYYour Airtable personal access token
You can rename the connection and choose whether it is shared with your organization or kept personal to you.
5

Test the connection

Ask Adapt to list your bases or read records from a table.

​
Security

  • Credentials are encrypted at rest with AES-256
  • Grant only read scopes (data.records:read, schema.bases:read) and limit the token to the specific bases Adapt needs
  • Regenerate or delete the token in the Builder Hub if it is ever exposed
  • Never share your token publicly or commit it to source control

​
Capabilities

Adapt can read your Airtable bases, tables, and records. Explore your data and analyze it using natural language.

​
Examples

Explore data: 
What tables are in my Airtable base?
Inspect a table: 
Show me the fields in my Projects table.
Summarize records: 
How many records in my Tasks table are marked complete?
Analyze trends: 
What are the top 5 clients by total project value in my base?