> ## Documentation Index
> Fetch the complete documentation index at: https://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.

<Steps>
  <Step title="Open the token page">
    Go to [airtable.com/create/tokens](https://airtable.com/create/tokens) in
    the Builder Hub and click **Create new token**.
  </Step>

  <Step title="Name your token">
    Give the token a descriptive name so you can recognize it later.
  </Step>

  <Step title="Add scopes">
    Click **Add a scope** and add the read scopes Adapt needs, such as:

    * `data.records:read`
    * `schema.bases:read`
  </Step>

  <Step title="Add base access">
    Click **Add a base** and select the specific bases (or workspaces) you want
    Adapt to access.
  </Step>

  <Step title="Create and copy the token">
    Click **Create token**, then copy and store the token immediately. Airtable
    shows it only once.
  </Step>
</Steps>

<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.
</Note>

## Connect to Adapt

<Steps>
  <Step title="Open Integrations">
    In Adapt, go to **Settings > Integrations**.
  </Step>

  <Step title="Find Airtable">
    Search for **Airtable** and select it from the catalog.
  </Step>

  <Step title="Start the connection">
    Click **Connect** to open the connection form.
  </Step>

  <Step title="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.
  </Step>

  <Step title="Test the connection">
    Ask Adapt to list your bases or read records from a table.
  </Step>
</Steps>

### 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?
```