Checks a database table every hour and appends any records it has not copied yet to a Google Sheet.
Uses
Google Sheets
Supabase
Copy new database records to a spreadsheet
Run every hour.Run every hour.
Set tableName to blank.Set tableName to blank.Set spreadsheetUrl to blank.Set spreadsheetUrl to blank.Set sheetName to Sheet1.Set sheetName to Sheet1.Google SheetsRead column 'A' of sheetName in spreadsheetUrl. Save it as sheetColumn.Read column 'A' of sheetName in spreadsheetUrl. Save it as sheetColumn.Set copiedKeys to sheetColumn.values.Set copiedKeys to sheetColumn.values.
If copiedKeys is emptyIf copiedKeys is emptyYes
Google SheetsAdd a row to sheetName in spreadsheetUrl.Add a row to sheetName in spreadsheetUrl.
Add Record ID to the end of copiedKeys and save it as copiedKeys.Add Record ID to the end of copiedKeys and save it as copiedKeys.No
No steps
SupabaseList rows from tableName. Save it as lookup.List rows from tableName. Save it as lookup.Set records to lookup.rows.Set records to lookup.rows.Set addedCount to 0.Set addedCount to 0.
For each record in records:For each record in records:Set idValue to record.id.Set idValue to record.id.If idValue is emptyIf idValue is emptyYes
Show in the output: Skipped a record with no 'id' column - nothing to identify it by..Show in the output: Skipped a record with no 'id' column - nothing to identify it by..Skip to the next item.Skip to the next item.No
No steps
Set recordKey to idValue.Set recordKey to idValue.If recordKey is emptyIf recordKey is emptyYes
Show in the output: Skipped a record whose 'id' is empty..Show in the output: Skipped a record whose 'id' is empty..Skip to the next item.Skip to the next item.No
No steps
If copiedKeys contains recordKeyIf copiedKeys contains recordKeyYes
Skip to the next item.Skip to the next item.No
No steps
Set createdAt to blank.Set createdAt to blank.If record.created_at isn't emptyIf record.created_at isn't emptyYes
Change createdAt to record.created_at.Change createdAt to record.created_at.No
No steps
Set recordName to blank.Set recordName to blank.If record.name isn't emptyIf record.name isn't emptyYes
Change recordName to record.name.Change recordName to record.name.No
No steps
Set recordEmail to blank.Set recordEmail to blank.If record.email isn't emptyIf record.email isn't emptyYes
Change recordEmail to record.email.Change recordEmail to record.email.No
No steps
If a step below fails, save the error as appendErrorIf a step below fails, save the error as appendErrorTry
Google SheetsAdd a row to sheetName in spreadsheetUrl.Add a row to sheetName in spreadsheetUrl.Add recordKey to the end of copiedKeys and save it as copiedKeys.Add recordKey to the end of copiedKeys and save it as copiedKeys.Add 1 to addedCount.Add 1 to addedCount.On error
Show in the output: Could not copy record recordKey: appendError as text.Show in the output: Could not copy record recordKey: appendError as text.Show in the output: Copied addedCount as text new record(s) into the spreadsheet.Show in the output: Copied addedCount as text new record(s) into the spreadsheet.