Database to spreadsheet sync
Keep the spreadsheet the business lives in current, automatically.
Half the company runs on a spreadsheet that someone refreshes by hand. Exports drift, columns get renamed, and the 'source of truth' is whoever updated it last.
Writing a one-off script works until the schema changes or the cron job dies silently at 2am.
One trigger, a few steps, and an Agent node making the call a static rule can’t — every step recorded so you can see exactly what happened.
- 1TRIGGERSchedule
Every 5 minutes
- 2TOOLpostgres.query
Select rows changed since the last run
- 3LOGICTransform
Map columns, format dates, derive fields
- 4TOOLsheets.upsert
Insert new rows, update changed ones by key
- 5AGENTWatch
Flag anomalies and notify on failure with the cause
The sheet is never more than minutes stale
Schema changes surface as alerts, not silent drift
Full run history — see exactly what synced and when