Connect Mage to Airtable as a destination to load data into your bases. This guide explains how to configure authentication using a Personal Access Token and the required base ID.


Configuration Parameters

To use Airtable as a destination, provide the following configuration values:

KeyDescriptionExample ValueRequired
tokenAirtable Personal Access Token with the required scopespat1234abcd...
base_idThe unique ID of the Airtable base you’re writing to (starts with app)app5678efgh...

Generating Credentials

To generate your Airtable Personal Access Token:

  1. Visit the Airtable Developer Hub.
  2. Click Create token.
  3. Assign the appropriate scopes (listed below).
  4. Save the token securely and include it in your Mage destination configuration.

Required Scopes

Make sure your token includes the following scopes:

  • schema.bases:write — Required for schema access
  • data.records:write — Required to insert, update, or delete records in Airtable

FAQs

What is base_id in Airtable?

The base_id is a unique identifier for your Airtable base. It typically starts with app and can be found in the base’s URL or retrieved using the Airtable API.

How should I store my Airtable token securely?

Use environment variables or Mage’s secrets manager to store your token. Avoid hardcoding tokens in your configuration files or version control.

Can Mage write data to multiple Airtable bases?

Yes, but you must configure each destination with its corresponding base_id and ensure the access token has permission for each base.