Compare two Google Sheets and list what changed
“compare this week's copy of our price list google sheet with last week's and list every product that was added, removed or had its price or stock status changed, matching rows by sku”
Compare this week's copy of our price list This week's price list tab with last week's Last week's price list tab and list every product that was added, removed or had its price or stock status changed, matching rows by SKU
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileThis week's price list tabCSV export · 40 rows
- FileLast week's price list tabCSV export · 40 rows
- StepPrepare this week's SKUsStep 2
- StepPrepare last week's SKUsStep 1
- JoinBring in last week's products38 of 40 paired
- StepList price list changesStep 4
- ResultPrice List Changes9 rows
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 9 rows.
- Download This week's price list tab sample (40 rows)Google Sheets: File > Download > Comma-separated values (.csv) from the current week's tab
- Download Last week's price list tab sample (40 rows)Google Sheets: File > Download > Comma-separated values (.csv) from the last week's tab
What you get back
The result of that run, the rows to look at first.
| SKU | Product | Change | This week's Price | Last week's Price | This week's Stock Status | Last week's Stock Status |
|---|---|---|---|---|---|---|
| A1042 | Ember Desk Fan | Added | 18.80 | · | Low | · |
| A1041 | Kestrel Shipping Scale | Added | 23.45 | · | In stock | · |
| A1004 | Cedar Clipboard | Changed | 6.90 | 6.40 | In stock | In stock |
| A1009 | Lighthouse Label Roll | Changed | 5.60 | 5.60 | Out | Low |
| A1018 | Meadow Keyboard | Changed | 19.10 | 18.60 | Low | Low |
| A1030 | Ridge Headset | Changed | 32.25 | 31 | Low | Low |
| A1022 | Saffron Power Strip | Changed | 16.75 | 16.75 | Out | In stock |
| A1033 | Nova Presentation Board | Removed | · | 21.40 | · | Low |
| A1007 | Pine File Folder | Removed | · | 2.90 | · | In stock |
How it works
How to use the Price List Changes workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Price List Changes: questions
How do you compare two Google Sheets and list what changed?
Which export should you use from Google Sheets?
What happens to rows that do not match by SKU?
How do you change the comparison rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Remove duplicates, tidy names and addresses, fill the blanks, and merge files into one.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Merge Excel or CSV filesOne tidy table with every file's rows, re-sent rows dropped, and a Period columnSee the workflow Template
- Remove duplicatesOne row of each, with a Copies column saying how many there wereSee the workflow Template
- Remove blank rowsRemove rows that are empty or only contain spaces from an Excel export, while keeping the rest of the sheet unchanged.See the workflow Built by the agent
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Multi-entity consolidationEvery entity's balances in one currency, by accountSee the workflow Template