ACTION_ID: airtable_add_data
NAME: Airtable: Add Data
CATEGORY: Integrations
CREDITS: 0

Append a record to a table in an Airtable base, mapping workflow columns
onto the table's fields.

PREREQUISITE: Airtable account connection — the user must create it in the Floqer UI
(Connections page); an agent cannot. Without it the action fails the row with
a connection / authentication error. Confirm it exists before configuring.

1. INPUTS

bases (airtableBasesDropdown, required)
  Bases. Select the Spreadsheet to add data to

select_table (inTableDropdown, required)
  Select table. Select the table you want to add the data to

add_data_to_columns (raw_array, required)
  Add Data To Columns. Select Columns from the object and add Values

2. OUTPUTS

(none — this action writes to the destination and returns no fields)

3. HOW TO CONFIGURE

Two cascading dropdowns — resolve the base first, then pass it as
context when resolving tables:

  POST .../options/bases          (body: {})
  POST .../options/select_table   (body: { "context": { "bases": "<base id>" } })

Configure Action body:

{
  "inputs": {
    "bases": "<base id from options>",
    "select_table": "<table id from options>",
    "add_data_to_columns": [
      { "name": "Email", "value": "{{person_work_email_waterfall_01ab.work_email}}" },
      { "name": "Company", "value": "{{input.company_name}}" }
    ]
  }
}

Field-by-field:
  - bases               The Airtable base to write into.
  - select_table        A table inside that base.
  - add_data_to_columns `[{name, value}]` where `name` is the Airtable
                        field name exactly as it appears in the table,
                        including spaces and capitalisation.

4. KEY NOTES

- `select_table` cannot be resolved without `bases` in the request
  `context` — calling it bare returns a 400 naming the missing key.
- Airtable field names are case- and space-sensitive (`First Name`, not
  `first_name`). A name that does not exist on the table is rejected by
  Airtable.
- Airtable typed fields (single-select, date, number) reject values that
  do not match their type. Coerce upstream with a `formula`.
- This action always appends. There is no upsert mode and no output, so
  it cannot be chained.

5. WHERE IT FITS IN A WORKFLOW

Pattern: enrichment chain -> filter (ICP match) -> airtable_add_data.
Terminal step, typically alongside a CRM write.

6. WHEN TO USE

Use airtable_add_data to log qualified rows into an Airtable base used
for reporting or manual review.

7. WHEN NOT TO USE

The destination is a spreadsheet
  -> action-detail/google_sheet_add_data.txt

Need create-or-update rather than append
  -> action-detail/google_sheet_upsert_row.txt

Last updated: 2026-08-03.