---
title: "Airtable"
slug: "airtable"
description: "Extract Airtable data in just a few steps with Dataddo and send it securely to any destination of your choice, including data warehouses and dashboarding tools."
updated: 2025-08-08T06:40:03Z
published: 2025-08-08T06:40:03Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Airtable

**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](https://airtable.com/developers/web/api/introduction).

## 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**](https://airtable.com/create/tokens) (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](https://airtable.com/developers/web/api/scopes).
  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**](https://airtable.com/create/oauth) (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](https://airtable.com/developers/web/api/scopes).
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](https://app.dataddo.com/service/new) and select Airtable.
2. Provide your Airtable [**API Key/Token**](/docs/airtable#personal-access-token).
3. Rename your ***authorizer*** for easier identification and click on **Save**.

**Airtable Custom**

1. On the **Authorizers** page, click on [Authorize New Service](https://app.dataddo.com/service/new) and select Airtable Custom.
2. Provide your Airtable [**client ID** and **client secret**](/docs/airtable#client-id).
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](https://airtable.com/developers/web/api/scopes).
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**](https://app.dataddo.com/sources/new) 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**](https://app.dataddo.com/service/new).
5. On the **Attributes and Metrics** step, select the **metrics and attributes** you want to extract.  

![Create a source using a custom-schema connector.](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Create%20Source%20-%20Custom-Schema%20Connector.png)
6. On the **Metadata** step, select which [**metadata fields**](/docs/metadata-inclusion) such as extraction time to add to your data.
7. On the **Snapshot** step:
  1. Configure your [**sync frequency**](/docs/extraction#extraction-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**](https://docs.dataddo.com/docs/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](https://docs.dataddo.com/docs/data-backfilling).
- **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**

- [Simple Data Integration to Dashboards](https://docs.dataddo.com/docs/simple-data-integration-to-dashboards)
- [Data Backfilling to Dashboarding Apps](https://docs.dataddo.com/docs/data-backfilling-to-dashboarding-apps)

**Sending Data to Data Storages**

- [Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
- [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)

**Other Resources**

- [Troubleshooting](https://docs.dataddo.com/docs/troubleshooting)
- [Extraction Logs](https://docs.dataddo.com/docs/extraction-logs)
- [Data Duplication](https://docs.dataddo.com/docs/data-duplication)

An API token is a code snippet used to secure API access. It's sent to API servers as identification, confirming whether the user or application has access, and provides both authentication and user/application information to the API server.

Authorizers act as credentials for external services (e.g. Facebook or Google). To enable Dataddo to access and retrieve your data, you need to grant access to accounts that possess admin-level permissions or higher within these services.