Airtable integration

Airtable is a cloud database tool for organizing structured data across bases and tables. With this integration, you can pull records from an Airtable table into Clay, and create, look up, update, or upsert records in Airtable from a Clay table.

Creating a table with Airtable

1. In a workbook, click + Add at the bottom.
2. Search for Airtable and select it from the results.
3. In the modal, you will be asked to Select Airtable account.
   • If you haven’t connected an Airtable account yet, click + Add account and authorize Clay. You can also add and manage connections from the Settings > Connections page.

Make sure your linked Airtable account has the right level of access to the bases you want to connect with Clay.

Source Enrich your data from Airtable

Pull records from an Airtable table into Clay.

Inputs

Required:

• Base ID: The Airtable base you’d like to pull records from.
• Table ID: The table within that base you’d like to pull into Clay.

Optional:

• Grid View: Filter the records added to Clay by table view.
• Limit: Cap the number of records imported from Airtable. The maximum is 50,000.

Enriching data with Airtable

1. While in a Clay table, click Add enrichment and search for Airtable.
2. Under Integrations, select one of the Airtable actions.
3. In the modal, you will be asked to Select Airtable account.

Action Create Record

Create and push a new record to your Airtable.

Inputs

Required:

• Base ID: The Airtable base you’d like to create the record in.
• Table ID: The table within that base you’d like to create the record in.

Optional:

• Columns: The columns in your Airtable table you can map Clay values to.

Outputs

• Id: The ID of the newly created record.
• Created Time: The timestamp the record was created.
• Fields: The field values written to the new record.

Action Lookup Record

Check if a specific record exists in your Airtable.

Inputs

Required:

• Base ID: The Airtable base you’d like to look the record up in.
• Table ID: The table within that base you want to search.
• Lookup Field Name: (Required if Lookup Type is set to a value lookup) The field you want to look up in Airtable. Select Airtable Record ID to retrieve a record by its Airtable ID instead of by field value.
• Lookup Value or Formula: The value you want to match, or the formula you want to filter by.

Optional:

• Lookup Type: Whether to match on a single field’s value or to filter the table with an Airtable formula. Defaults to a value lookup if you leave it blank.

Outputs

• Found Matches: Whether the lookup matched any record.
• Num Records Found: How many records matched.
• Status: The result status of the lookup.
• Records: The matched records, each containing:
  • Id: The record’s Airtable ID.
  • Created Time: The timestamp the record was created.
  • Fields: The record’s field values.

Performing a formula-based lookup

A formula lookup filters the table using an Airtable formula rather than matching a single field, so you can combine several conditions in one lookup.

1. Select your Base ID, then your Table ID.
2. Set Lookup Type to Airtable Formula (Used for filtering larger tables).
   • Lookup Field Name disappears once you do this — the formula names the fields it filters on, so there’s nothing to select separately.
3. Enter your formula in Lookup Value or Formula. Clay passes it to Airtable exactly as written, so it must be valid Airtable formula syntax with field names wrapped in curly braces — for example {Status} = "Active", or AND({Status} = "Active", {Owner} = "Jane") to combine conditions.

For the full set of functions and operators available, see Airtable's formula field reference.

<div style="background-color: #FDFBF0; padding: 16px; border-radius: 8px; border: 1px solid #F4E8C1; font-family: Arial, sans-serif;">

<strong>Note:</strong> Formula lookups are filtered by Airtable before any records reach Clay, while value lookups retrieve the table’s records and match them within Clay. On large tables, a formula lookup is the more reliable choice.

</div>

Action Update Record

Update an existing record in your Airtable.

Inputs

Required:

• Base ID: The Airtable base you’d like to update the record in.
• Table ID: The table within that base you’d like to update the record in.
• Record ID: The ID of the record to update (e.g., reczdNLOVEWV).

Optional:

• Columns: The columns in your Airtable table you can map Clay values to.
• Remove Blank Values: When switched on, strips null and blank values out of what Clay sends, so existing Airtable values stay as they are instead of being overwritten with blanks.
• Typecast fields?: On by default. Lets Airtable coerce values into the field’s type, which helps when updating single select, multiple select, or linked record fields.

Outputs

• Id: The ID of the updated record.
• Created Time: The timestamp the record was created.
• Fields: The field values on the record after the update.

Action Upsert Record

Create or update an Airtable record based on matching values.

Inputs

Required:

• Base ID: The Airtable base you’d like to upsert the record in.
• Table ID: The table within that base you’d like to upsert the record in.
• Fields To Merge On: The fields to compare against when deciding whether to create or update a record. You can select up to three, and the comparison has to match either zero or one row for the upsert to work.

Optional:

• Columns: The columns in your Airtable table you can map Clay values to.

Outputs

• Records: The records created or updated, each containing:
  • Id: The record’s Airtable ID.
  • Created Time: The timestamp the record was created.
  • Fields: The record’s field values.
• Created Records: The IDs of the records that were created.
• Updated Records: The IDs of the records that were updated.
• Num Records Updated: How many records were updated.
• Num Records Created: How many records were created.

Run settings

• Auto-update: Useful when your Airtable base is the system of record, so rows added to Clay later are pushed or looked up without rerunning the column by hand.
• Only run if: The enrichment will only run if conditions are met. (Learn more about conditional formulas here!)

FAQs

Can a formula-based lookup return more than one record?

Yes — the action returns every record your formula matches, not just the first one. A broad formula can match far more rows than you expect, so check Num Records Found before you map the results into other columns.

Can I reference a Clay column inside the formula?

Yes. Lookup Value or Formula is a standard text input, so you can drop Clay column references into the formula the same way you would in any other action input — for example, filtering on a company name that an earlier column produced.

‍