Skip to content
Contact us
  • There are no suggestions because the search field is empty.

Airtable connection

Create records in an Airtable base from survey responses. Organize your response data in Airtable's flexible spreadsheet-database format.

Overview

The Airtable connection creates a new record in your chosen table for each survey response. You map survey questions to table fields, and Centiment formats the data based on each field's type. With lookup support, you can update existing records instead of creating duplicates. Airtable records are synced in efficient batches of 10 for faster processing.

Prerequisites

  • An Airtable account with at least one base and table

  • A survey with at least one question

Setup

Step 1: Connect your Airtable account

Select an existing connected Airtable account or click Connect an account to authenticate with Airtable via OAuth.

Step 2: Select a base

Choose the Airtable base that contains the table you want to send data to.

Step 3: Select a table

Choose the specific table within the base where records should be created. The available fields will load automatically from your table schema.

Step 4: Map fields and set trigger rules

Map your survey questions to Airtable fields. Centiment detects each field's type and formats the data accordingly. Optionally set a lookup field to update existing records instead of always creating new ones. Then choose which response statuses trigger the sync: Complete, Disqualified, or Over Quota. You can also add conditions to filter which responses are sent.

Field mapping

Each survey question can be mapped to a field in your Airtable table. Centiment automatically formats values to match the field type. Make sure your table has the right field types set up before mapping.

Lookup field

When you set a lookup field, Centiment searches for an existing record where that field matches the mapped survey answer. If a match is found, the record is updated. If no match is found, a new record is created.

Backfill

When first enabled, existing responses that match your trigger rules are automatically synced to Airtable. Backfill is processed in batches for efficiency, so large datasets sync quickly.

Good to know

  • Airtable's API allows a maximum of 10 records per request. Centiment handles this automatically by batching records during backfill.

  • If you add new fields to your Airtable table, they'll be available for mapping the next time you edit the connection.