## Airtable integration

Airtable is a cloud-based platform that combines the simplicity of a spreadsheet with the power of a database. Integrating Airtable with Frontegg allows your application to access and manage bases, tables, records, and fields on behalf of your users through OAuth 2.0 authentication.

Prerequisites
- An Airtable account (free or paid plan)
- Access to the Airtable Builder Hub


### Connect Airtable

#### Step 1: Open the Builder Hub

Log in to your [Airtable](https://airtable.com) account. Click your profile icon in the top-right corner and select **Builder Hub**. In the left sidebar, under **Developers**, click **OAuth integrations**.

![Airtable Builder Hub](/assets/airtable-1.634f1019da0e4bddb3c27078a0f99a89450653d162d9518b0e883c1d6c9fb5ba.1ce25488.png)

#### Step 2: Register a new OAuth integration

On the **OAuth integrations** page, click the **Register new OAuth integration** button.

![Register new OAuth integration](/assets/airtable-2.eb460d618eb92935d3c24821742cf9c19a4acba6221c4983cbb43068ffdb205a.1ce25488.png)

#### Step 3: Fill in the registration form

In the registration form, fill in the following fields:

- **Name** -- Enter a descriptive name (e.g., "Frontegg Integration")
- **OAuth redirect URLs** -- Enter the redirect URI listed below


Add the following redirect URI:

- `https://YOUR_MCP_GATEWAY_URL/integration-callback`


Click **Register integration** to create the application.

![Airtable registration form](/assets/airtable-3.3279aa0ab5140a5d7b94383b28c79f1ff959c31a36270a1db8b0b78423f546d6.1ce25488.png)

#### Step 4: Review the application settings

After registration, you are redirected to the application settings page. Here you can configure additional details such as a tagline, homepage URL, and logo.

![Airtable application settings](/assets/airtable-4.5273e9be01ac6866cfe2d1b863de5c622e2fe2475b0324eb62bd0e6c7dccb1ff.1ce25488.png)

#### Step 5: Generate a client secret

Scroll down to the **Developer details** section. You can see the **Client ID** value displayed in a read-only field.

To generate a **Client Secret**, click the **Generate client secret** button. A confirmation dialog appears -- click **Generate** to proceed. Copy the secret immediately and store it in a safe location, as it will only be shown once.

Keep your credentials secure
Never share or commit your Client Secret to version control. The secret is only displayed once after generation.

![Airtable client secret](/assets/airtable-5.1dd6c9b1ff3cfd377f47f685883638a90949cf70bd9f69fe3a3ac100fa335369.1ce25488.png)

#### Step 6: Copy the client ID

In the **Developer details** section, copy the **Client ID** value. You will need both the Client ID and Client Secret to configure the integration in the Frontegg portal.

![Airtable client ID](/assets/airtable-6.c6f5e19f2faba0d82dd360716e74041f5f48c75c8e653784c4eb9d535a29468b.1ce25488.png)

#### Step 7: Configure OAuth scopes

Scroll down to the **Scopes** section. Select the following scopes required for the integration:

| Scope | Description |
|  --- | --- |
| `data.records:read` | See the data in records |
| `data.records:write` | Create, edit, and delete records |
| `schema.bases:read` | See the structure of a base, like table names or field types |
| `schema.bases:write` | Edit the structure of a base, like adding new fields or tables |
| `user.email:read` | See the user's email address |
| `webhook:manage` | View, create, delete webhooks for a base, as well as fetch webhook payloads |


Minimum required scopes
For basic functionality, you need: `data.records:read`, `schema.bases:read`, `user.email:read`.

![Airtable scopes - records and schema](/assets/airtable-7.6a4e99584dd4b092449ee18f2b8ad8bcadc6c49c353e44ea9ff565e22fa88663.1ce25488.png)

![Airtable scopes - user metadata and webhooks](/assets/airtable-8.8dd4f091e939ceda32128644e2cded9db8fb04838584df4bb69dda31041a85c5.1ce25488.png)

#### Step 8: Verify redirect URIs

In the **OAuth redirect URLs** section, verify that the redirect URI is configured correctly.

![Airtable redirect URIs](/assets/airtable-9.657ab891102607dc36e917659e8e3ccc04890e0eec5d288f06826052948ca620.1ce25488.png)

#### Step 9: Save changes

Click the **Save changes** button at the bottom of the page to save your configuration.

### Configure the Frontegg portal

Once you have obtained your **Client ID** and **Client Secret** from the steps above, enter them in the integration configuration page of the Frontegg portal:

1. Open the **Frontegg portal** and navigate to [ENVIRONMENT] → Integrations → Airtable.
2. Enter the **Client ID** and **Client Secret** in the corresponding fields.
3. Select the required **scopes**.
4. Click **Save**.


### Additional resources

- [Airtable OAuth integrations guide](https://airtable.com/developers/web/guides/oauth-integrations)
- [Airtable API scopes reference](https://airtable.com/developers/web/api/scopes)
- [Airtable REST API documentation](https://airtable.com/developers/web/api/introduction)
- [How to get your Redirect URL](/agen-for-work/connectors/redirect-url)