Sync your database/warehouse to your airtable bases for ops, CRM, or anything you can imagine
Setup
Navigate to https://airtable.com/account and generate a new API key.
Use the API key generated to create a new Airtable destination in the Destinations catalog.
Syncing
Configuration
You will need to copy your Base ID from your project's API page and write in the table's name that you want to sync to.
Sync Modes
Here are the possible modes for how to alter Airtable objects:
- Insert — pushes new objects to Airtable. It does not 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 does not add new objects.
Record Matching
If you are using Upsert or Update mode, you will need to select a record matching field. Records can be matched from your source to Airtable workspace by id of the row or any unique fields in the table. You will have to type in your Airtable's field. Make sure the spelling and case are correct.
The record should be matched using a unique identifier, otherwise the intended records may not be updated properly.
Field Mapping
You can sync columns from your source to any of your Airtable properties. The Airtable API will perform best-effort automatic data conversion from string values. Like the Recording Matching field, you will have to type out the exact field names.
