Skip to content

Data table#

Use the Data Table node to create and manage internal data tables. Data tables allow you to store structured data directly inside n8n and use it across workflows.

You can use the Data Table node to:

  • Create, list, and manage data tables
  • Insert, update, delete, and upsert rows in data tables
  • Query and retrieve rows using matching conditions

Working with data tables

As well as using the Data Tables node in a workflow, you can view and manage data tables manually from the Data Tables tab in your project Overview.

For information about working with data tables in this tab, and guidance on when to use data tables and their limitations, see Data tables.

Resources#

The Data Table node supports the following resources:

  • Data Table: Create, list, update, and delete tables.
  • Row: Insert, retrieve, update, delete, and upsert rows within a table.

Operations#

See available operations below. For detailed information on parameters for different operation types, refer to the Table operations and Row operations pages.

  • Rows

    • Delete: Delete one or more rows.
    • Get: Get one or more rows from your table based on defined filters.
    • If Row Exists: Specify a set of conditions to match input items that exist in the data table.
    • If Row Does Not Exist: Specify a set of conditions to match input items that don't exist in the data table.
    • Insert: Insert rows into an existing table.
    • Update: Update one or more rows.
    • Upsert: Upsert one or more rows. If the row exists, it's updated; otherwise, a new row is created.

  • Tables

    • Create: Create a new data table.
    • Delete: Delete an existing data table.
    • List: List existing data tables.
    • Update: Update an existing data table.

Data tables explains how to create and manage data tables.

This page was