Copy new rows to a second spreadsheet
Checks a source sheet hourly and appends any rows it has not copied yet into a second sheet. One-way only - nothing is overwritten.
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 SheetsGet column valuesReads the key column of both tabs to work out which source rows are not yet in the destination.
If
copiedKeysis empty- 2Google SheetsGet row valuesFetches each uncopied row in full from the source tab, and its header row when the destination is still empty.
If
headerValuesis not empty- 3Google SheetsAppend rowAppends each new row whole to the destination tab, after the header row if that tab was empty.
- 3
- 2
For each
sourceKeyIf
rowKeyis not empty andcopiedKeysdoes not includerowKey- 4Google SheetsGet row values
If
rowValuesis not empty- 5Google SheetsAppend row
- 5
- 4
How it works
What happens on each run, in plain English.
Every hour, the key column of a source tab is compared with the key column of a destination tab in another spreadsheet, and every row whose key does not yet appear in the destination is appended there. One team keeps the list, another gets its own copy, and nobody pastes anything.
The copy is one way and append only. Nothing already in the destination is ever written over, and edits or deletions made in the source are not mirrored. A row counts as copied once its key appears in the destination, so running it twice copies nothing the second time. Rows with an empty key cell are left alone and counted in the run summary, a row that fails to copy is reported and tried again next run, and a large first copy is spread over several runs.
Both tabs need the same layout, with a column that identifies each row uniquely, such as an order number or an email address, in the same position in each. If the destination tab is empty, the source's header row is copied across first.
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 rows to a second spreadsheet" to your workspace, connect its apps, and make it yours.
Free plan, no credit card