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

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.

Related resources

Data tables explains how to create and manage data tables.