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
The integration steps this workflow runs, in the order it first runs them.
- 1Google SheetsRead column
- 2Google SheetsAppend row
- 3SupabaseList rows
How it works
Everything the template sets up, and what to fill in before the first run.
Gives people who cannot open the database a live copy of a table in a spreadsheet they already know how to use. Every hour the workflow reads your table and appends any record it has not copied before as a new row. Nothing in the sheet is ever overwritten or deleted, and nothing in the database is changed - it is only read.
The sheet itself is the record of what has already been copied: column A holds each record's id, and a record whose id is already in column A is skipped. That means a second run adds nothing new, re-running after a failure is safe, and you can delete a row from the sheet to have it copied again. Leave column A to the workflow.
Each row is written as Record ID, Created at, Name, Email - read from the record's 'id', 'created_at', 'name' and 'email' columns. Those column names are fixed rather than settings, so if your table names things differently, open the 'Copy record' step in the builder and point each one at the column you want. A record missing one of them is still copied, with that cell left blank; a record with no id is skipped, since there would be no way to tell later whether it had already been copied.
Fill in the table name in the 'tableName' step and your spreadsheet link in the 'spreadsheetUrl' step. If the sheet is empty the workflow writes a header row first. It reads the whole table on each run, so it suits tables up to a few thousand rows.
You May Also Be Interested In
Save matching emails to a spreadsheetSaves each new Gmail message that matches your search as a row in your spreadsheet, and never saves the same message twice.
Read pages from pictures of them into rowsTakes a full-page picture of each page you list, reads the details you asked for off the picture, and adds a row per page to your sheet.
Track a property market over timeSearches one property site each week, records the listings that are new to you, and logs how the record has changed.
Summarise and index new documents in a Box folderChecks a Box folder hourly and gives each new PDF its own summary document and one row in your index 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. No credit card required.
Free plan available · No credit card required