AirtablePlus

Append, update, and upsert data from Airtable

Actions3

Overview

The AirtablePlus node for n8n allows you to append (add) new records to an Airtable table. This is useful when you want to automate the process of inserting data into Airtable from other sources or workflows, such as collecting form submissions, syncing data from another database, or logging events.

Practical examples:

Automatically add new leads from a web form to your Airtable CRM.
Log error reports or feedback entries directly into an Airtable base.
Sync new product information from an e-commerce platform into Airtable for inventory management.

Properties

Name	Meaning
Base ID	The ID of the Airtable base to access.
Table ID	The ID of the table within the base where records will be appended.
Fields	The fields and their values to set in the new record(s). You can specify multiple field name/value pairs.
Options	Additional options for the operation: - Bulk Size: Number of records to process at once (1–10, default 10). - Typecast: Whether Airtable should attempt to map string values for linked records & select options.

Output

The output is a JSON array containing the details of the newly created records. Each item in the array represents a record and typically includes:

id: The unique Airtable record ID.
fields: An object with the field names and their corresponding values as stored in Airtable.
createdTime: The timestamp when the record was created.

If an error occurs and "Continue On Fail" is enabled, the output may include objects with an error property describing the issue.

Example output:

[
  {
    "id": "recXXXXXXXXXXXXXX",
    "fields": {
      "Name": "John Doe",
      "Email": "john@example.com"
    },
    "createdTime": "2024-06-01T12:34:56.000Z"
  }
]

Dependencies

Airtable API Key: You must provide valid Airtable API credentials via the airtableApi credential in n8n.
Airtable Base and Table: Ensure the specified Base ID and Table ID exist and that your API key has access.

Troubleshooting

Common issues:

Invalid Base ID or Table ID: If these are incorrect, the node will fail with an error indicating the resource could not be found.
Field Mismatch: If you specify a field name that does not exist in the Airtable table, Airtable may reject the request or ignore the field.
API Rate Limits: Airtable enforces rate limits; sending too many requests in a short time may result in errors.
Bulk Size Exceeded: The maximum allowed bulk size is 10. Setting a higher value will cause validation errors.

Error messages:

"The operation \"...\" is not known!" – This means an unsupported operation was selected.
Errors with an error property in the output indicate issues with individual records (e.g., missing required fields, invalid field values).