Overview
Airtable is a flexible database and collaboration platform used by organizations to organize, track, and manage data in a structured, spreadsheet-like interface. It combines the simplicity of a spreadsheet with the power of a relational database to support a wide range of business workflows.
The Alchemer integration with Airtable supports pushing new records and updating existing records. The Alchemer Airtable integration allows Alchemer to use survey response data to create new rows in Airtable tables and update existing Airtable records, keeping your Airtable bases synchronized with data collected in Alchemer.
Common uses for the Alchemer Airtable integration
- Automatically push survey response data into Airtable as new records
- Update existing Airtable records when a respondent submits a survey
- Reduce manual data entry by syncing survey data directly to Airtable
- Keep Airtable bases up to date with the latest respondent information
- Trigger downstream Airtable automations from survey submissions
What can the Alchemer Airtable integration do?
You will need
- Airtable API access and credentials. More details in the authentication how-to guide.
- An Alchemer plan that includes integrations with the Integration Manager permission enabled.
- Contact us if you are unsure if your plan includes integrations.
Setup Alchemer Airtable integration in surveys
Airtable | Push Data to Airtable
You will need:
- Airtable API credentials
- The Airtable base and table you want to push data into
- Survey fields containing the data you want to send to Airtable
Configure the action
- Open your survey in Survey Builder.
- Select Add New: Action.
- In the Add Action modal, scroll to the Your Integrations section.
- Select Airtable.
- Select Airtable | Push Data to Airtable.
- Airtable | Authentication: Select an existing authentication or create a new one.
- Airtable | Select Base: Choose the Airtable base where you want to push data.
- Airtable | Select Table: Choose the table within that base to receive the new record.
- Airtable | Push Data: Map Alchemer survey fields to the corresponding Airtable column fields.
- Airtable | Get data back: Select metadata fields (e.g., message, status code). These can be used to help debug your action setup.
- Save the action.
Status codes
- 200: Record was successfully created in Airtable
- 400: The external integration returned an error
Airtable | Update Airtable Record
You will need:
- Airtable API credentials
- The Airtable base and table containing the record you want to update
- A survey field containing a unique identifier for the Airtable record (e.g., record ID)
Configure the action
- Open your survey in Survey Builder.
- Select Add New: Action.
- In the Add Action modal, scroll to the Your Integrations section.
- Select Airtable.
- Select Airtable | Update Airtable Record.
- Airtable | Authentication: Select an existing authentication or create a new one.
- Airtable | Select Base: Choose the Airtable base that contains the record you want to update.
- Airtable | Select Table: Choose the table within that base.
- Airtable | Find Record: Select the Alchemer field containing the unique record identifier (e.g., Airtable record ID) used to locate the record.
- Airtable | Update Record: Map Alchemer survey fields to the Airtable column fields you want to update.
- Airtable | Get data back: Select metadata fields (e.g., message, status code). These can be used to help debug your action setup.
- Save the action.
Status codes
- 200: Record was successfully updated
- 400: The external integration returned an error
Testing and Troubleshooting
Testing and Validation
How to test
- Submit a survey response with data that triggers the integration action.
- Confirm the expected record creation or update occurred in Airtable.
- Use returned metadata message to validate successful behavior.
How to verify results
- Inspect the affected Airtable table directly in Airtable.
- Ensure all pushed or updated values match the survey response data.
Monitoring Integration Activity
Where to find logs
- Go to Results → Individual Responses.
- Select the response you want to inspect.
- Open the Action Log tab.
What logs display
- Success or failure status
- Timestamp
- Input and output values
- Returned status codes from Airtable
Troubleshooting
Authentication issues
- Incorrect or expired API token
- Missing permissions on the Airtable base or table
Lookup failures
- Invalid or missing record ID
- No matching record found in the specified table
Mapping errors
- Field type mismatch (e.g., sending text to a number field)
- Incorrect field name casing or formatting
API errors
- Rate limit exceeded on the Airtable API
- Endpoint or permission restrictions on the base
FAQs
What permissions do I need?
Integration Manager in Alchemer and API access to the relevant Airtable base.
When does the integration run?
In real time when a survey response is submitted.
Can I use multiple Airtable actions in one survey?
Yes. Actions can run independently or in sequence.
Why isn’t my data updating?
Check the Action Log for lookup issues, mapping mismatches, or API errors.
What if I need additional functionality?
Contact Alchemer Support for enhancement requests.
