SEATABLE n8n INTEGRATION: AUTOMATE SEATABLE WITH N8N

The Upload an Asset action allows you to programmatically upload files, images, or documents to a specific cell in your SeaTable table. This is essential for workflows that involve document processing, image handling, or file attachments from other sources.

Key parameters: Credential (required), Resource set to "Asset" (required), Operation set to "Upload" (required), Table Name (required), Column Name (required), Row ID (required), and Property Name (optional, defaults to "data").

Use cases: Automatically attach invoice PDFs generated by another tool, upload screenshots from monitoring systems, or store downloaded images from web scraping workflows.

The Public URL action retrieves a publicly accessible URL for an asset stored in SeaTable. This is invaluable when you need to share files externally or embed them in emails, documents, or other platforms that require direct links.

Key parameters: Credential (required), Resource set to "Asset" (required), Operation set to "Public URL" (required), and Asset Path (required text field for the exact asset location).

Use cases: Generate shareable links for report attachments, create download URLs for customer-facing communications, or embed SeaTable assets in external dashboards.

The Remove Link action disconnects previously linked rows between two tables. In relational database terms, it deletes the association between records without deleting the records themselves.

Key parameters: Credential (required), Resource set to "Link" (required), Operation set to "Remove" (required), Table Name (Source) (required), Link Column (required), Row ID From the Source Table (required), and Row ID From the Target Table (required).

Use cases: Unassign team members from projects when they move to new roles, remove product-category associations during catalog restructuring, or clean up test data relationships.

The List Link action retrieves all linked records from a specific link column and row. This is perfect for understanding relationships between records or pulling related data into your workflow.

Key parameters: Credential (required), Resource set to "Link" (required), Operation set to "List" (required), Table Name (required), Link Column (required), and Row ID (required).

Use cases: Fetch all tasks linked to a project, retrieve all products in a specific category, or list all team members assigned to a client account.

The Add Link action creates a relationship between two rows using a link column. This enables you to build and maintain relational data structures programmatically.

Key parameters: Credential (required), Resource set to "Link" (required), Operation set to "Add" (required), Table Name (Source) (required), Link Column (required), Row ID From the Source Table (required), and Row ID From the Target (required).

Use cases: Automatically link new invoices to their corresponding clients, connect task rows to project rows when tasks are created, or associate products with orders in an e-commerce workflow.

The Collaborator action allows you to manage collaborators on a SeaTable base, enabling you to add or interact with users programmatically based on their name or email address.

Key parameters: Credential (required), Resource set to "Base" (required), Operation set to "Collaborator" (required), and Name or email of the collaborator (required text field).

Use cases: Automatically add new team members to relevant bases when they join, manage access based on project assignments, or integrate with HR systems for onboarding workflows.

The Metadata action retrieves structural information about your SeaTable base, including tables, columns, and their configurations. This is useful for dynamic workflows that need to adapt to your data structure.

Key parameters: Credential (required), Resource set to "Base" (required), and Operation set to "Metadata" (required).

Use cases: Build dynamic forms based on current table structure, validate data before insertion, or create documentation of your database schema automatically.

The Snapshot action creates a point-in-time backup of your SeaTable base. This is crucial for data protection, compliance, or maintaining historical records of your database state.

Key parameters: Credential (required), Resource set to "Base" (required), and Operation set to "Snapshot" (required).

Use cases: Schedule daily backups before critical operations, create snapshots before running bulk update workflows, or maintain compliance records with periodic archiving.

The Update Row action modifies existing data in a specific row of your SeaTable table. This is one of the most commonly used actions for keeping your data current and synchronized.

Key parameters: Credential (required), Resource set to "Row" (required), Operation set to "Update" (required), Table Name (required), Row ID (required), Data to Send (required dropdown), and Columns to Send (optional dynamic section).

Use cases: Update CRM contact information from form submissions, change task statuses based on external triggers, or sync inventory quantities from your warehouse system.

The Unlock Row action removes the lock from a previously locked row, making it editable again. This is essential for approval workflows where rows are locked during review and need to be unlocked after completion.

Key parameters: Credential (required), Resource set to "Row" (required), Operation set to "Unlock" (required), Table Name (required), and Row ID (required).

Use cases: Automatically unlock records after approval, release rows for editing after a review period expires, or unlock entries when assigned users complete their tasks.

The Search Row action finds rows in your SeaTable table that match a specific search term in a designated column. This enables lookup operations essential for data enrichment and validation workflows.

Key parameters: Credential (required), Resource set to "Row" (required), Operation set to "Search" (required), Table Name (required), Column Name or ID (required), Search Term (required), and Options (optional).

Use cases: Find existing contacts before creating duplicates, look up product details by SKU, or verify if a record already exists before insertion.

The Lock Row action prevents modifications to a specific row, protecting it from edits during review processes or after final approval. Locked rows remain visible but cannot be changed until unlocked.

Key parameters: Credential (required), Resource set to "Row" (required), Operation set to "Lock" (required), Table Name (required), and Row ID (required).

Use cases: Lock approved budget entries to prevent accidental changes, protect completed contracts from modification, or freeze historical records for audit compliance.

The Get Many action retrieves multiple rows from a SeaTable table, with optional filtering through views. This bulk retrieval is perfect for batch processing, reporting, or synchronization workflows.

Key parameters: Credential (required), Resource set to "Row" (required), Operation set to "Get Many" (required), Table Name (required), View Name (optional), and Options (optional for limits, filters, and sorting).

Use cases: Export all contacts for email campaigns, retrieve pending tasks for daily digest notifications, or pull inventory data for stock level reports.

The Get Row action retrieves a single, specific row from your SeaTable table using its unique row ID. This targeted retrieval is ideal when you know exactly which record you need.

Key parameters: Credential (required), Resource set to "Row" (required), Operation set to "Get" (required), Table Name (required), Row ID (required), and Options (optional).

Use cases: Fetch complete details for a record referenced in a trigger, retrieve parent record data when processing child records, or get current values before performing updates.

The Delete Row action permanently removes a specific row from your SeaTable table. Use this with caution, as deleted data cannot be recovered through the API.

Key parameters: Credential (required), Resource set to "Row" (required), Operation set to "Delete" (required), Table Name (required), and Row ID (required).

Use cases: Remove processed entries from queue tables, clean up test data, or delete records that have been archived elsewhere.

The Create Row action adds a new row to your SeaTable table with the data you specify. This fundamental action is the starting point for many data collection and synchronization workflows.

Key parameters: Credential (required), Resource set to "Row" (required), Operation set to "Create" (required), Table Name (required), Data to Send (required), Apply Column Default Values (optional toggle), Columns to Send (optional dynamic section), and Save to "Big Data" Backend (optional toggle).

Use cases: Create new leads from form submissions, log events from external systems, add inventory items from supplier feeds, or generate records from parsed emails using Gmail integration.