Copy new database records to a spreadsheet
Checks a database table every hour and appends any records it has not copied yet to a Google Sheet.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsRead columnReads column A of the sheet to learn which record ids have already been copied across.
If
copiedKeysis empty- 2Google SheetsAppend rowWrites the heading row if the sheet is empty, then appends one row per new record: id, created time, name, email.
- 2
- 3SupabaseList rowsReads every row of the table you name so new records can be compared against the ids already in the sheet.
For each
record- 4Google SheetsAppend row
- 4
How it works
What happens on each run, in plain English.
Every hour, the workflow reads a table in your Supabase database and appends any record it has not copied before as a new row in a Google Sheet. People who cannot open the database get a live copy of the table in a spreadsheet, and the database itself is only ever read, never changed.
Each row holds the record's id, when it was created, its name and its email. The sheet is the memory: column A holds every copied id, and a record whose id is already there is skipped, so a second run adds nothing new, re-running after a failure is safe, and deleting a row from the sheet has that record copied again. Nothing already in the sheet is overwritten. A record with no id is skipped and reported, since it could never be told apart later, while a record missing a name or email is still copied with that cell left blank.
If the sheet is empty, a heading row is written first. The whole table is read on each run, so it suits tables up to a few thousand rows.
You may also be interested in
Never miss a filing or renewal deadlineChecks your deadline sheet each morning and emails you as each licence, permit, tax filing or renewal comes due, with a calendar event.Find matching rows in a spreadsheetEvery hour, finds the rows on a Google Sheets tab where a column holds a value you choose, or is empty, ready for the steps you add.
Extract purchase orders from GmailReads each new purchase order email, looks its items up in your product list, and logs every line with name and price.Low stock and expiry alerts for your pharmacyChecks your pharmacy inventory sheet every morning and emails the medicines running low or near expiry, marking each in the sheet.Start from a workflow that already works.
Add "Copy new database records to a spreadsheet" to your workspace, connect its apps, and make it yours.
Free plan, no credit card