Skip to Content

Airtable

The Airtable enables tools and to call Airtable APIs  on behalf of a using OAuth 2.0 authentication.

Want to quickly get started with Airtable in your or AI app? The pre-built Arcade Airtable MCP Server is what you want!

What’s documented here

This page describes how to use and configure Airtable auth with Arcade.

This is used by:

Configuring Airtable auth

When using your own app credentials, make sure you configure your to use a custom user verifier. Without this, your end-users will not be able to use your app or in production.

In a production environment, you will most likely want to use your own Airtable app credentials. This way, your will see your application’s name requesting permission.

Before showing how to configure your Airtable app credentials, let’s go through the steps to create an Airtable app.

Create an Airtable app

To integrate with Airtable’s API, you’ll need to create an OAuth integration:

Access the Airtable Developer Hub

Navigate to the Airtable Developer Hub  and sign in with your Airtable .

Create a new OAuth integration

  1. Go to the Create OAuth Integration  page
  2. Fill in the required details:
    • Integration Name: Choose a descriptive name for your application
    • Description: Provide a brief description of your app’s purpose

Configure OAuth settings

  1. Set the Redirect URL to the redirect URL generated by Arcade (see configuration section below)
  2. Configure the required Scopes for your application:
    • data.records:read - Read records from tables
    • data.records:write - Create, update, and delete records
    • schema.bases:read - Read base schema
    • Add other scopes as needed for your use case

Obtain your credentials

  1. After creating your integration, you’ll receive a Client ID
  2. Generate a Client Secret from your integration settings
  3. Copy both values for use in Arcade configuration

For detailed instructions, refer to Airtable’s OAuth documentation .

Next, add the Airtable app to Arcade.

Configuring your own Airtable Auth Provider in Arcade

Configure Airtable Auth Using the Arcade Dashboard GUI

Access the Arcade Dashboard

To access the Arcade Cloud dashboard, go to api.arcade.dev/dashboard . If you are self-hosting, by default the dashboard will be available at http://localhost:9099/dashboard . Adjust the host and port number to match your environment.

  • Under the OAuth section of the Arcade Dashboard left-side menu, click Providers.
  • Click Add OAuth Provider in the top right corner.
  • Select the OAuth 2.0 tab at the top.

Enter the provider details

  • Choose a unique ID for your provider (e.g. “arcade-airtable”).
  • Optionally enter a Description.
  • Enter the Client ID and Client Secret from your Airtable integration.
  • Configure the OAuth 2.0 endpoints:
    • Authorization URL: https://airtable.com/oauth2/v1/authorize
    • Token URL: https://airtable.com/oauth2/v1/token
  • Note the Redirect URL generated by Arcade. This must be set as your Airtable integration’s Redirect URL.

Create the provider

Hit the Create button and the provider will be ready to be used.

When you use tools that require Airtable auth using your Arcade credentials, Arcade will automatically use this Airtable OAuth provider. If you have multiple Airtable providers, see using multiple auth providers of the same type for more information.

Using Airtable auth in app code

Use the Airtable in your own and AI apps to get a token for the Airtable API. See authorizing agents with Arcade to understand how this works.

Use client.auth.start() to get a token for the Airtable API:

Python
from arcadepy import Arcade client = Arcade() # Automatically finds the `ARCADE_API_KEY` env variable user_id = "{arcade_user_id}" # Start the authorization process auth_response = client.auth.start( user_id=user_id, provider="arcade-airtable", scopes=["data.records:read", "data.records:write", "schema.bases:read"] ) if auth_response.status != "completed": print("Please complete the authorization challenge in your browser:") print(auth_response.url) # Wait for the authorization to complete auth_response = client.auth.wait_for_completion(auth_response) token = auth_response.context.token # Do something interesting with the token...

Using Airtable auth in custom tools

You can use the pre-built Arcade Airtable MCP Server to quickly build and AI apps that interact with Airtable.

If the pre-built tools in the Airtable Server don’t meet your needs, you can author your own custom tools that interact with the Airtable API.

Use the OAuth2() auth class to specify that a requires authorization with Airtable. The context.authorization.token field will be automatically populated with the ’s Airtable token:

Python
from typing import Annotated import httpx from arcade_tdk import ToolContext, tool from arcade_tdk.auth import OAuth2 @tool( requires_auth=OAuth2( provider_id="arcade-airtable", scopes=["data.records:read", "schema.bases:read"] ) ) async def list_bases( context: ToolContext, ) -> Annotated[dict, "The user's bases."]: """ Retrieve the list of bases accessible to the authenticated user. """ url = "https://api.airtable.com/v0/meta/bases" headers = { "Authorization": context.authorization.token, } async with httpx.AsyncClient() as client: response = await client.get(url, headers=headers) response.raise_for_status() return dict(response.json())

Available Scopes

Airtable supports various OAuth scopes that determine the level of access your application has:

  • data.records:read - Read records from tables
  • data.records:write - Create, update, and delete records
  • data.recordComments:read - Read comments on records
  • data.recordComments:write - Create and update comments on records
  • schema.bases:read - Read base schema information
  • schema.bases:write - Modify base schema
  • webhook:manage - Create and manage webhooks
  • user.email:read - Read email address

For a complete list of available scopes, refer to the Airtable Scopes documentation .

Last updated on