> ## Documentation Index
> Fetch the complete documentation index at: https://v1-docs.adapt.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Airtable

> Connect Airtable to read your bases and analyze your records with natural language

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](https://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.

> [!NOTE]
>
> 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 Name | Value |
| - | - |
| `AIRTABLE_API_KEY` | Your 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?
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.