Skip to content

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.

Data tables explains how to create and manage data tables.

This page was