All projects · Automation & Data Pipelines
n8n Two-Database Sync with Compare Datasets (Airtable → Supabase)
An n8n workflow that makes a Supabase table mirror an Airtable table using the Compare Datasets node.
An n8n workflow that makes a Supabase table mirror an Airtable table using the Compare Datasets node. Records only in Airtable are inserted, rows only in Supabase are deleted, and a second run changes nothing. Ships as an importable 6-node workflow, the Supabase table SQL, and an interactive studio with an editable Primary grid, a live canvas, and Before/After snapshots of the Secondary table.
- Matches the reference canvas: Primary DB + Secondary DB → Compare Datasets → In A only creates rows, In B only deletes them
- Matching on all four business fields makes an edit a replace, which explains why the After table starts at id 2
- Handles Airtable node v2.2's nested fields: Input A matches on fields.Email while Supabase uses Email
- Skip Fields keeps unchanged pairs in Same instead of Different; the demo can toggle it off to show the difference
- Demonstrates three traps: empty Airtable fields causing endless re-creation, Supabase's 50-row default, and edits made directly in the mirror
- Sync logic tested on n8n's own Compare Datasets source (13/13 scenarios); the demo's engine is a verified port of it
- No personal data: fictional leads on example.com and 555-01xx numbers, and a workflow export with no credentials or IDs
Built with: n8n, Compare Datasets, Airtable, Supabase, PostgreSQL, Data Sync