SeaTable n8n integrationAutomate SeaTable with n8n.

Adds a row to a table and returns it, the way a workflow turns an incoming event into a visible record.

• Table Name: the destination table, from the list or an expression.
• Data to Send: autoMapInputData when the incoming properties already match the column names, defineBelow to set each column by hand.
• Columns to Send: column and value pairs, with strict formats. Dates as YYYY-MM-DD or YYYY-MM-DD hh:mm, durations as a number of seconds, checkboxes as true, on or 1, multi-select as a comma-separated list.
• Apply Column Default Values: fills the new row with the column defaults, on the normal backend only.

Removes one row from a table for good. Nothing comes back except the confirmation, so anything the workflow still needs has to be read before this node runs.

• Table Name: the table the row belongs to.
• Row ID: the identifier of the row to delete, usually {{ $json.row_id }} carried over from a search or a list step.

Reads a single row and returns its content, the usual way to fetch the full record when the trigger or a previous node only handed over an identifier.

• Table Name: the table to read from.
• Row ID: the row to fetch, from the list or an expression.
• Simplify: returns a trimmed version of the response instead of the raw data.
• Return Column Names: true gives column names, false gives column keys. Pick one and keep it across the workflow, because the expressions downstream depend on it.

Pulls a batch of rows from a table or from one of its views, and emits one n8n item per row so the rest of the workflow loops naturally.

• Table Name: the source table.
• View Name: optional but often the real filter, since a view already carries the conditions the team defined in SeaTable.
• Simplify: trims the response when you only care about the values.
• Return Column Names: switches between column names and column keys in the output.

Locks a row so it stops accepting changes. The record stays readable in the base, but the values are frozen until something unlocks it again.

• Table Name: the table holding the row.
• Row ID: the row to freeze, typically the one the current workflow just finished processing.

Looks for a value inside one column and returns the rows that match, which is what a workflow needs when it knows an email or a reference but not a row identifier.

• Table Name: the table to search.
• Column Name or ID: the column being searched. Not every column type is supported here.
• Search Term: the value to look for, often {{ $json.email }}.
• Case Insensitive Search: ignores upper and lower case, which you almost always want on addresses.
• Activate Wildcard Search: true restricts results to perfect matches, false finds a row when the term is only part of the value.

Releases a row that was locked earlier, putting it back in a state where both people and workflows can write to it.

• Table Name: the table holding the row.
• Row ID: the row to release.

Writes new values into a row that already exists, leaving the columns you do not mention untouched. This is the operation that turns SeaTable into a living table rather than an append-only log.

• Row ID: which row gets rewritten, so a wrong expression here overwrites the wrong record.
• Data to Send: autoMapInputData maps incoming properties onto matching columns, defineBelow sets each column explicitly.
• Inputs to Ignore: a comma-separated list of properties to keep out of the write, handy when the incoming item carries technical fields.

Freezes a copy of the whole base at the moment the node runs. No parameter to fill: the credential already points at one base, and that base is the one captured.

Returns the complete structure of the base: its tables, their columns and the types behind them, rather than the data inside. It takes no parameter.

Resolves a person into the internal username SeaTable uses, which looks like 244b43hr6fy54bb4afa2c2cb7369d244@auth.local. Collaborator columns store that value, not an email, so a workflow that wants to assign someone has to translate first.

• Name or email of the collaborator: the email or the display name you already have in the workflow.

Connects two rows through a link column, the SeaTable way of expressing that this order belongs to that customer.

• Table Name (Source): the starting table, expressed as table_name:::table_id when you use an expression rather than the dropdown.
• Link Column: the column carrying the relation, in the form column_name:::link_id:::other_table_id.
• Row ID From the Source Table: the row you start from.
• Row ID From the Target: the row you link to.

Returns every row connected to one row through a given link column, so a workflow can walk a relation instead of guessing it.

• Table Name: the table the starting row lives in.
• Link Column: the relation to follow, written as column_name:::link_id:::other_table_id:::column_key in expression form, which carries one segment more than the add and remove operations.
• Row ID: the row whose links you want.

Breaks an existing relation between two rows. Both rows survive, only the link disappears from the column.

• Table Name (Source): the starting table, in the table_name:::table_id form when set by expression.
• Link Column: the link column to clean.
• Row ID From the Source Table: the row you start from.
• Row ID From the Target Table: the row to detach.

Turns the internal path of a file stored in SeaTable into a URL something else can open. Files in an image or file column are stored as paths, which is why a raw column value is rarely usable as is.

• Asset Path: the stored path, shaped like /images/2023-09/logo.png.

Pushes a binary file coming from a previous node into a file or image column of an existing row.

• Column Name: the file or image column receiving the asset.
• Row ID: the row the file is attached to.
• Property Name: the name of the binary property holding the data, data in most n8n nodes, and a mismatch here is the usual cause of an empty upload.
• Replace Existing File: true overwrites a file with the same name, false keeps both and adds a numeral in parentheses.
• Append to Column: true keeps the files already in the column, false clears them first.