Skip to content

Airtable#

Use the Airtable node to automate work in Airtable, and integrate Airtable with other applications. n8n has built-in support for a wide range of Airtable features, including creating, reading, listing, updating and deleting tables.

On this page, you'll find a list of operations the Airtable node supports and links to more resources.

Credentials

Refer to Airtable credentials for guidance on setting up authentication.

Operations#

  • Append the data to a table
  • Delete data from a table
  • List data from a table
  • Read data from a table
  • Update data in a table

Templates and examples#

OpenAI-powered tweet generator

by Gareth Roll

View template details
Build a self-hosted URL shortener with a dashboard

by mohamed ali

View template details
Create HubSpot contacts from LinkedIn post interactions

by Pauline

View template details
Browse Airtable integration templates, or search all templates

n8n provides a trigger node for Airtable. You can find the trigger node docs here.

Refer to Airtable's documentation for more information about the service.

What to do if your operation isn't supported#

If this node doesn't support the operation you want to do, you can use the HTTP Request node to call the service's API.

You can use the credential you created for this service in the HTTP Request node:

  1. In the HTTP Request node, select Authentication > Predefined Credential Type.
  2. Select the service you want to connect to.
  3. Select your credential.

Refer to Custom API operations for more information.

Node reference#

Get the Record ID#

To fetch data for a particular record, you need the Record ID. There are two ways to get the Record ID.

Create a Record ID column in Airtable#

To create a Record ID column in your table, refer to this article. You can then use this Record ID in your Airtable node.

Use the List operation#

To get the Record ID of your record, you can use the List operation of the Airtable node. This operation will return the Record ID along with the fields. You can then use this Record ID in your Airtable node.

Filter records when using the List operation#

To filter records from your Airtable base, use the Filter By Formula option. For example, if you want to return all the users that belong to the organization n8n, follow the steps mentioned below: 1. Select 'List' from the Operation dropdown list. 2. Enter the base ID and the table name in the Base ID and Table field, respectively. 3. Click on Add Option and select 'Filter By Formula' from the dropdown list. 4. Enter the following formula in the Filter By Formula field: {Organization}='n8n'.

Similarly, if you want to return all the users that don't belong to the organization n8n, use the following formula: NOT({Organization}='n8n').

Refer to the Airtable documentation to learn more about the formulas.