Data table#
The Data Table node allows you to permanently save data across workflow executions in a table format. It provides functionality to perform various data operations on stored data.
Node parameters#
Resource#
Select the resource on which you want to operate
- Rows
Operations#
Select the operation you want to run on the resource:
Operation | Description | Options |
---|---|---|
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. |
Update | Update one or more rows. | |
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 . |
Upsert | Upsert one or more rows. If the row exists, it's updated; otherwise, a new row is created. | |
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 . |
This page was