# Airtable

Airtable (opens new window) is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet. The fields in an Airtable table are similar to cells in a spreadsheet, but have types such as 'checkbox', 'phone number', and 'drop-down list', and can reference file attachments like images.

🔑 Credentials

You can find authentication information for this node here.

# Basic 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

# Example Usage

This workflow allows you to insert and list data from a table in Airtable. You can also find the workflow (opens new window) on n8n.io. This example usage workflow would use the following nodes.

The final workflow should look like the following image.

A workflow with the Airtable node

# 1. Start node

The start node exists by default when you create a new workflow.

# 2. Set node

  1. Click on the Add Value button and select 'Number' from the dropdown list.
  2. Enter id in the Name field.
  3. Click on the Add Value button and select 'String' from the dropdown list.
  4. Enter name in the Name field.
  5. Enter the value for the name in the Value field.
  6. Click on Execute Node to run the node.

Using the Set node to set data to be inserted by the Airtable node

# 3. Airtable node (Append)

  1. First of all, you'll have to enter credentials for the Airtable node. You can find out how to do that here.
  2. Select the 'Append' option from the Operation dropdown list.
  3. Enter the Base ID in the Base ID field. For obtaining the Base ID, head over to their API page (opens new window) and select the correct base. You’ll find the Base ID there.
  4. Enter the name of the table in the Table field.
  5. Click on Execute Node to run the workflow.

Using the Airtable node to insert data into an Airtable table

# 4. Airtable1 node (List)

  1. Select the credentials that you entered in the previous node.
  2. Select the 'List' option from the Operation dropdown list.
  3. Enter the base ID used in the previous node in the Base ID field.
  4. Enter the name of the table used in the previous node in the Table field.
  5. Click on Execute Node to run the workflow.

Using the Airtable node to read data from an Airtable table

# Further Reading