Search documentation...

ChangelogBook a demoSign up


Sync your database or data warehouse to your Airtable bases for DataOps, CRM, and much more

Supported syncing

Sync TypeDescriptionSupported Sync Modes
ObjectsInsert new objects without updating others or push new objects and update fields that changeInsert, Upsert
Object fieldsUpdate particular fields on existing objects without adding new objectsUpdate

Connect to Airtable

Go to the Destinations overview page and click the Add destination button. Select Airtable and click Continue. You can then authenticate Hightouch to Airtable using an Airtable personal access token.

Create Airtable personal access token

Navigate to your Airtable Personal access tokens page and click Create token.

Airtable account overview page

Give your token a descriptive name, for example, "Hightouch Integration Key," and grant your token the following scopes:

  • data.records:read
  • data.records:write
  • schema.bases:read
  • schema.bases:write

Airtable account overview page

Grant your token access to the bases and workspaces you need Hightouch to access, and then copy your token to use it in Hightouch.

Sync configuration

Once you've set up your Airtable destination and have a model to pull data from, you can set up your sync configuration to begin syncing data. Go to the Syncs overview page and click the Add sync button to begin. Then, select the relevant model and the Airtable destination you want to sync to.

Choose the Airtable base and table you want to sync to using the two drop-down lists.

Airtable configuration in the Hightouch UI

Then select the mode for how to alter Airtable objects:

  • Insert: pushes new objects to Airtable. It doesn't update any objects.
  • Upsert: pushes new objects to Airtable and updates fields that change in your warehouse.
  • Update: updates particular fields on existing objects in Airtable. It doesn't add new objects.

Record matching

If you are using Upsert or Update mode, you must select a record matching field. You can match records from your source to your Airtable workspace by the table's primary key or any other unique fields in the table. You can choose the field you would like to use from the dropdown.

Airtable record matching in the Hightouch UI

You should match the record using a unique identifier with a string type, otherwise the sync may not update the intended records properly.

Field mapping

You can sync columns from your source to any of your Airtable properties. The Airtable API performs best-effort automatic data conversion from string values. You can choose the field names from the drop-down lists.

Airtable field mapping in the Hightouch UI

Tips and troubleshooting

Common errors

If you encounter an error or question not listed below and need assistance, don't hesitate to . We're here to help.

Duplicated records

Duplicated records in Airtable may occur because you've chosen a column for your model primary key that isn't a string data type.

Though Hightouch automatically stringifies the model column you select for your primary key, you can override this behavior by setting the column to a different type in your model configuration.

This isn't recommended since it isn't as performant. In the Airtable destination it can also lead to duplicated records because, 1234 does not match "1234", for example.

If you need to sync the primary key column as a non-string value, use SQL aliasing in your model to create a new column specifically for syncing.

Live debugger

Hightouch provides complete visibility into the API calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks to learn more.

Sync alerts

Hightouch can alert you of sync issues via Slack, PagerDuty, SMS, or email. For details, please visit our article on alerting.

Ready to get started?

Jump right in or a book a demo. Your first destination is always free.

Book a demoSign upBook a demo

Need help?

Our team is relentlessly focused on your success. Don't hesitate to reach out!

Feature requests?

We'd love to hear your suggestions for integrations and other features.

Last updated: May 17, 2023

On this page

Supported syncingConnect to AirtableCreate Airtable personal access tokenSync configurationRecord matchingField mappingTips and troubleshootingCommon errorsLive debuggerSync alerts

Was this page helpful?