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
The integration steps this workflow runs, in the order it first runs them.
- 1Google SheetsGet column values
- 2Google SheetsGet row values
- 3Google SheetsAppend row
How it works
Everything the template sets up, and what to fill in before the first run.
One team owns the list and another needs their own copy of it. Every hour this workflow reads the key column of the source tab, compares it with the key column of the destination tab, and appends every row it has not seen before.
The copy is one-way and append-only. A workflow cannot change a single cell in Google Sheets - writing to a row replaces it from column A outwards, which would wipe out formulas and retype values - so this never writes over a row that is already there. Edits and deletions made in the source are not mirrored; only new rows arrive.
A row counts as already copied when the value in its key column already appears in the destination's key column, so running it twice in a row copies nothing the second time. Set 'keyColumnNumber' to the position of the column that identifies a row - 1 for column A, 2 for column B, and so on - and make sure that column holds something unique, such as an order number, an email address or an ID. Rows whose key cell is empty are left alone and counted in the summary at the end.
Rows are copied whole and in their existing order, so both tabs keep the same layout and the key sits in the same column in each. If the destination tab is completely empty, the source's header row is copied across first. Each run copies at most 'maxNewRowsPerRun' rows, so a large first sync is spread over several runs instead of one very long one and the next run carries on from where the last stopped.
Fill in the two links and the two tab names at the top, check that 'keyColumnNumber' points at your identifying column, and it is ready to run.
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 rows to a second spreadsheet" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required