AirtablePlus

Append, update, and upsert data from Airtable

Actions3

Overview

The AirtablePlus node for n8n enables you to upsert (update or insert) records in an Airtable table. The "Upsert" operation checks if a record matching a specified search formula exists; if it does, the record is updated, otherwise, a new record is created. This is particularly useful for workflows where you want to avoid duplicate entries and ensure data consistency—such as synchronizing contacts, updating inventory, or maintaining unique user profiles.

Practical examples:

Automatically update customer information if they exist, or add them if they're new.
Sync product stock levels from another system, ensuring no duplicates.
Maintain a single source of truth for leads by merging incoming data.

Properties

Name	Meaning
Base ID	The ID of the Airtable base to access.
Table ID	The ID of the table within the base to access.
Search Formula	Airtable formula used to find existing records to upsert. If a record matches this formula, it will be updated; otherwise, a new one is created.
Fields	List of fields to send to Airtable. Each field includes: - Field Name - Field Value
Options	Additional options: - Typecast: Whether Airtable should attempt mapping string values for linked records & select options (true/false)

Output

The output is a JSON array containing the resulting Airtable records after the upsert operation. Each item typically includes:

id: The Airtable record ID.
fields: An object with the field names and their values as stored in Airtable.
createdTime: Timestamp when the record was created (for new records).

If an error occurs and "Continue On Fail" is enabled, the output may include objects like:

{ "error": "Error message here" }

Dependencies

External Service: Requires access to the Airtable API.
Credentials: You must configure the airtableApi credential in n8n with your Airtable API key.
Environment: No special environment variables are required beyond standard n8n/Airtable setup.

Troubleshooting

Common Issues:

Invalid Base/Table ID: Ensure that both IDs are correct and that your API key has access.
Search Formula Errors: If the formula is invalid, Airtable will return an error. Double-check syntax using Airtable's formula documentation.
Field Mismatches: If you specify a field name that doesn't exist in the table, Airtable will ignore it or throw an error depending on configuration.
API Limits: Airtable enforces rate limits; excessive requests may result in errors.

Error Messages:

"The operation \"...\" is not known!"
- Cause: An unsupported operation was selected.
- Solution: Use only supported operations ("append", "update", "upsert").
Error objects in output (when "Continue On Fail" is enabled):
- Review the error property for details and adjust input accordingly.