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.

Common uses for the Alchemer Airtable integration

• Automatically push workflow data into Airtable as new records
• Retrieve Airtable record data to personalize workflow steps and emails
• Update existing Airtable records based on workflow events
• Reduce manual data entry and record maintenance across systems
• Keep Airtable bases synchronized with operational data collected in Alchemer
• Trigger downstream Airtable automations from Alchemer workflow runs

What can the Alchemer Airtable integration do?

• Push data to Airtable
• Get record
• Update Airtable record

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 workflow

Airtable | Push Data to Airtable

You will need:

• Airtable API credentials
• The Airtable base and table you want to push data into
• Workflow fields containing the data you want to send to Airtable

Configure the action

1. Open your workflow in Workflow builder.
2. On the right side, drag and drop the Airtable connection where you want the action to trigger.
3. In the connection box, click the pencil icon in the top-right corner.
4. Select Airtable | Push Data to Airtable.
5. Airtable | Authentication: Select an existing authentication or create a new one.
6. Airtable | Select Base: Choose the Airtable base where you want to push data.
7. Airtable | Select Table: Choose the table within that base to receive the new record.
8. Airtable | Push Data: Map Alchemer workflow fields to the corresponding Airtable column fields.
9. Save the action.

Status codes

• 200: Record was successfully created in Airtable
• 400: The external integration returned an error

Airtable | Get Record

You will need:

• Airtable API credentials
• The Airtable base and table containing the record you want to retrieve
• A workflow field containing a unique identifier for the Airtable record

Configure the action

1. Open your workflow in Workflow builder.
2. On the right side, drag and drop the Airtable connection where you want the action to trigger.
3. In the connection box, click the pencil icon in the top-right corner.
4. Select Airtable | Get Record.
5. Airtable | Authentication: Select an existing authentication or create a new one.
6. Airtable | Select Base: Choose the Airtable base that contains the record you want to retrieve.
7. Airtable | Select Table: Choose the table within that base.
8. Airtable | Find Record: Select the Alchemer field containing the unique record identifier used to locate the record.
9. Airtable | Get data back: Select the Airtable fields you want returned. These values can be used to personalize workflow steps or drive logic.
10. Save the action.

Status codes

• 200: Record was successfully found
• 201: Query succeeded but no matching record was found
• 202: Multiple records were found (first returned is used)
• 400: Error returned by Airtable API

Airtable | Update Airtable Record

You will need:

• Airtable API credentials
• The Airtable base and table containing the record you want to update
• A workflow field containing a unique identifier for the Airtable record (e.g., record ID)

Configure the action

1. Open your workflow in Workflow builder.
2. On the right side, drag and drop the Airtable connection where you want the action to trigger.
3. In the connection box, click the pencil icon in the top-right corner.
4. Select Airtable | Update Airtable Record.
5. Airtable | Authentication: Select an existing authentication or create a new one.
6. Airtable | Select Base: Choose the Airtable base that contains the record you want to update.
7. Airtable | Select Table: Choose the table within that base.
8. Airtable | Find Record: Select the Alchemer field containing the unique record identifier used to locate the record to update.
9. Airtable | Update Record: Map Alchemer workflow fields to the Airtable column fields you want to update.
10. 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

• Trigger the workflow and monitor individual runs in the Monitor tab.
  • Click into individual workflow runs to see input/output metadata.
• Confirm the expected record creation, retrieval, or update occurred in Airtable.
• Use metadata values returned to verify success or help debug issues.

How to verify results

• Check the affected Airtable table directly in Airtable.
• Ensure all pushed, retrieved, or updated values match workflow expectations.

Monitoring Integration Activity

Where to find logs

• Go to Results → Monitor.
• Select the integration step you want to inspect.

What logs display

• Input/Output

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