Sync Google Sheets Contacts to SeaTable with Upsert Logic

This n8n workflow automates the synchronization of contact data from a Google Sheets document to a SeaTable table. It reads contacts from the sheet and, for each entry, queries SeaTable to check if a record with the matching email already exists. If found, it updates the existing record with the latest details (firstname, lastname, company); if not, it inserts a new record. This upsert logic ensures seamless data flow without manual intervention or duplicate entries.

Key benefits include centralized contact management, where Google Sheets serves as an accessible input source for teams, while SeaTable acts as a robust backend database for CRM-like operations. It saves significant time on data entry, reduces errors from manual syncing, and supports scalability for growing contact lists. Ideal for sales teams, marketers, or any business collecting leads via sheets.

Use cases: Maintain a deduplicated CRM database in SeaTable fed by spreadsheet leads; automate contact updates from event signups or form submissions routed to Sheets; integrate with other tools for full lead management pipelines. Requires Google Sheets and SeaTable credentials, with setup via a template sheet and predefined table columns (email, firstname, lastname, company). Tested on n8n 1.105.2.