Data table

Use the Data Table node to permanently save data across workflow executions in a table format. It provides functionality to perform various data operations on stored data. See Data tables.

Node parameters

Resource

Select the resource on which you want to operate.

  • Rows

Operations

Select the operation you want to run on the resource:

  • Delete: Delete one or more rows.

    • Dry Run: Simulate a deletion before finalizing it. If you switch on this option, n8n returns the rows that will be deleted by the operation. Default state is off.

  • Get: Get one or more rows from your table based on defined filters.

    • Limit: The number of rows you want to return, specified as a number. Default value is 50.

    • Return all: Switch on to return all data. Default value is off.

  • 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.

    • Optimize Bulk: Optimize the speed of insertions when working with many rows. If you switch on this option, n8n won’t return the data that was inserted. Default state is off.

  • 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.