Overview
This node triggers workflows in n8n based on events occurring in SeaTable, a collaborative online spreadsheet and database platform. It listens for three types of events:
- New Row: Triggers when a new row is created in a specified table and view.
- New or Updated Row: Triggers when a row is either newly created or updated.
- New Signature: Triggers when a new digital signature appears in a specified signature column.
This node is useful for automating processes that depend on changes in SeaTable data, such as notifying teams about new entries, syncing data with other systems, or processing signed documents automatically.
Practical Examples
- Automatically send an email notification when a new row is added to a project tracking table.
- Update a CRM system whenever a row is modified in a customer database.
- Trigger a document approval workflow when a new digital signature is detected in a contract management table.
Properties
| Name | Meaning |
|---|---|
| Event | The type of event to trigger on: - New Row - New or Updated Row - New Signature |
| Table Name | The name of the SeaTable table to monitor. Can be selected from a list or set via expression. |
| View Name | (Shown for "New Row" and "New or Updated Row" events) The name of the SeaTable view to monitor. |
| Signature Column | (Shown for "New Signature" event) The digital-signature column to track for new signatures. |
| Simplify | Whether to return a simplified version of the response instead of raw data (boolean). |
| Return Column Names | (Shown for "New Row" and "New or Updated Row") Whether to return column names (true) or keys (false). |
| "Fetch Test Event" notice | Informational notice that test fetch returns up to three items from the last hour. |
Output
The node outputs an array of JSON objects representing rows or signatures detected based on the selected event:
- For New Row and New or Updated Row events, each item corresponds to a row object enriched with column metadata and related user information.
- For New Signature events, each item corresponds to a digital signature entry filtered by recent modification time.
If the "Simplify" option is enabled, the output data is transformed into a more straightforward format for easier consumption.
The output does not include binary data.
Dependencies
- Requires an API key credential for authenticating with the SeaTable API.
- Uses SeaTable's REST API endpoints to query tables, views, rows, and signature columns.
- Relies on n8n's polling mechanism to periodically check for new or updated data.
- Uses the
moment-timezonelibrary internally for date/time handling.
Troubleshooting
- No Data Returned: Ensure the correct table, view, or signature column is selected and that there are new or updated rows/signatures since the last poll.
- Authentication Errors: Verify that the API key credential is correctly configured and has sufficient permissions.
- Incorrect Column Names: If "Return Column Names" is false, column keys are returned instead of names; toggle this setting if you see unexpected field names.
- Rate Limits or API Errors: Check SeaTable API limits and ensure network connectivity.
- Test Event Returns No Items: The test fetch only returns up to three items from the last hour; if no recent data exists, no items will appear.