Sync Google Sheets contacts to SeaTable with update/insert logic
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects SeaTable and Google Sheets. It also calls cloud.seatable.io over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- settings (Edit Fields (Set)): sets 1 field: googlesheetid
- contacts (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- SeaTable: search
- If: checks a condition and branches into true / false
- Create a row (SeaTable): uses SeaTable
- Update a row (SeaTable): update
- Edit Fields (Edit Fields (Set)): sets 3 fields: server, base_uuid, access_token
- HTTP Request: calls an HTTP API (POST)
- HTTP Request: calls cloud.seatable.io
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: cloud.seatable.io
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Rarely used nodes in this template: n8n-nodes-base.seaTable
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - No Operation, do nothing
n8n-nodes-base.noOp - If
n8n-nodes-base.if - SeaTable
n8n-nodes-base.seaTable - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set
From the author
Keep your Google Sheets contacts in sync with SeaTable Update or Insert records in SeaTable How it works - Use a Google Sheet as your central contact list. - For each contact in the sheet: - Check if the record already exists in SeaTable (based on email). -…