Airtable

  • 4 minute(s) read
Prev Next

Airtable is a cloud-based platform that combines the simplicity of a spreadsheet with the functionality of a database, allowing users to organize, collaborate on, and manage information visually. It supports features like custom fields, linked records, views, and automations, making it useful for project tracking, content planning, CRM, and more.

Refer to Airtable's official documentation to see all available endpoints from the Airtable API.

Authorize Connection to Airtable

In Airtable

Depending on the Airtable authorizer type, you will a different type of credentials:

Connector Necessary Credentials
Airtable A personal access token (= API token)
Airtable Custom Client ID and client secret

To get your personal access token:

  1. In Airtable, go to the Builder Hub (also accessible through Account > API > Developer hub).
  2. On the Personal access tokens page, click on Create token.
  3. Label your token (e.g. Dataddo), and:
    1. Configure the Scopes for the token. To extract data, read permissions for your endpoints must be added. To see what permission scopes you need, refer to Airtable's official documentation.
    2. Select what data the token has access to. You can Add all data or select specific bases Dataddo can extract data from.
  4. Click on Create and copy the value. Make sure to store this value safely as you can display it only once.

To get your client ID and client secret:

  1. In Airtable, go to the Builder Hub (also accessible through Account > API > Developer hub).
  2. On the OAuth Integrations page, click on Register new OAuth integration.
  3. Label the integration (e.g. Dataddo) and provide the following OAuth redirect URL: https://app.dataddo.com/settings/service/airtableCustom.
  4. Click Register integration to confirm.
  5. In the Developer details section:
    1. Copy the Client ID to provide to Dataddo.
    2. Generate a new Client Secret. Copy the value and make sure to store this value safely as you can display it only once.
  6. Configure the Scopes for the integration. To extract data, read permissions for your endpoints must be added. To see what permission scopes you need, refer to Airtable's official documentation.
  7. Finish by clicking on Save changes.

In Dataddo

Then create an Airtable authorizer, use one of the following two connectors:

  • Airtable
  • Airtable Custom

Airtable

  1. On the Authorizers page, click on Authorize New Service and select Airtable.
  2. Provide your Airtable API Key/Token.
  3. Rename your authorizer for easier identification and click on Save.

Airtable Custom

  1. On the Authorizers page, click on Authorize New Service and select Airtable Custom.
  2. Provide your Airtable client ID and client secret.
  3. Select which Scopes will be granted to Dataddo. To extract data, read permissions for your endpoints must be added. To see what permission scopes you need, refer to Airtable's official documentation.
  4. Rename your authorizer for easier identification and click on Save.

How to Create an Airtable Data Source

  1. On the Sources page, click on the Create Source button.
  2. Select the connector from the list and name your data source.
  3. On the Dataset step, select your dataset.
    DATADDO TIP

    If you're unsure which dataset to select, use the search bar to look for datasets with the desired attributes or metrics.

  4. On the Account step select your authorizer from the drop-down menu.
    Didn't find your authorizer?

    Click on Add new Account at the bottom of the drop-down and follow the on-screen prompts. You can also go to the Authorizers tab and click on Add New Service.

  5. On the Attributes and Metrics step, select the metrics and attributes you want to extract.
    Create a source using a custom-schema connector.
  6. On the Metadata step, select which metadata fields such as extraction time to add to your data.
  7. On the Snapshot step:
    1. Configure your sync frequency or click Show advanced settings to set the exact synchronization time.
      DATADDO TIP

      If you need to load historical data, refer to the Data Backfilling article.

    2. [Optional] Enable the Allow Empty Data Extractions toggle to allow the extraction when no data is available.
  8. In the top-right corner, click Test Data button to preview extracted data. You can adjust the date range for a specific time frame.
  9. Click on Save and congratulations, your new data source is ready!

DATADDO TIP

If you have more bases in your Airtable account, to extract all data, you will need to create a source per base.

Troubleshooting

Data Preview Unavailable

No data preview when you click on Test Data might be caused by an issue with your source configuration. The most common causes are:

  • Date range: Try a smaller date range. You can load the rest of your data afterward using manual data load.
  • Insufficient permissions: Please make sure your authorized account has at least admin-level permissions.
  • Invalid metrics, attributes, or breakdowns: You may not have any data for the selected metrics, attributes, or breakdowns.
  • Incompatible combination of metrics, attributes, or breakdowns: Your selected combination cannot be queried together. Please refer to the service's documentation to view a full list of metrics that can be included in the same data source.

Related Articles

Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.

Sending Data to Dashboarding Apps

Sending Data to Data Storages

Other Resources