Skip to main content

Create Record

Creates a new record in a specified Airtable table.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.

Inputs​

  • Key Id - The key identifier returned from the Connect node.
  • Base Id - The unique identifier of the Airtable base where the record will be created.
  • Table Name - The name of the table where the record will be created.
  • Record - An object containing the field values for the new record.

Output​

  • result - An object containing the details of the created record, including its ID and created time.

How It Works​

The Create Record node adds a new record to a specified Airtable table. When executed, the node:

  1. Validates the required inputs (Base Id, Table Name, and Record)
  2. Constructs the Airtable API endpoint URL
  3. Retrieves the API key using the provided Key Id
  4. Sends a POST request to the Airtable API with the record data
  5. Returns the created record details as the result

Requirements​

  • A valid Airtable account
  • An Airtable base with appropriate permissions
  • A connected Airtable session (using the Connect node)
  • Valid Base Id and Table Name
  • Properly formatted record data

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid Key Id
  • Empty or invalid Base Id
  • Empty or invalid Table Name
  • Empty or invalid Record data
  • Airtable API errors (e.g., invalid field names, insufficient permissions)
  • HTTP connection errors

Usage Notes​

  • The Record input should be an object with field names as keys and their values
  • Field names must exactly match those in your Airtable table
  • The result includes the created record's ID and other metadata from Airtable
  • All field types supported by Airtable can be included in the record data
  • The node will fail if the table doesn't exist or if you don't have permission to create records

Record Format​

The Record input should be structured as an object with field names as keys:

{
  "Field Name 1": "Value 1",
  "Field Name 2": "Value 2",
  "Number Field": 42,
  "Checkbox Field": true
}

Example​

To create a new contact record:

Inputs:

  • Key Id: (from Connect node)
  • Base Id: "appBase123"
  • Table Name: "Contacts"
  • Record: 
    {
      "Name": "John Doe",
      "Email": "john@example.com",
      "Phone": "+1234567890"
    }

Output: The result will contain the full record details including the new record's ID.