Skip to content
Workflow · Clean and combine · Opening soon

Compare two Google Sheets and list what changed

Export both sheets as files, one for this week and one for last week. Match the rows by SKU, then compare the product, price, and stock status fields.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    This week's price list tab
    CSV export · 40 rows
  2. File
    Last week's price list tab
    CSV export · 40 rows
  3. Step
    Prepare this week's SKUs
    Step 2
  4. Step
    Prepare last week's SKUs
    Step 1
  5. Join
    Bring in last week's products
    38 of 40 paired
  6. Step
    List price list changes
    Step 4
  7. Result
    Price List Changes
    9 rows
  8. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 9 rows.

What you get back

The result of that run, the rows to look at first.

Price List ChangesSample data9 rows
SKUProductChangeThis week's PriceLast week's PriceThis week's Stock StatusLast week's Stock Status
A1042Ember Desk FanAdded18.80·Low·
A1041Kestrel Shipping ScaleAdded23.45·In stock·
A1004Cedar ClipboardChanged6.906.40In stockIn stock
A1009Lighthouse Label RollChanged5.605.60OutLow
A1018Meadow KeyboardChanged19.1018.60LowLow
A1030Ridge HeadsetChanged32.2531LowLow
A1022Saffron Power StripChanged16.7516.75OutIn stock
A1033Nova Presentation BoardRemoved·21.40·Low
A1007Pine File FolderRemoved·2.90·In stock
9 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Price List Changes workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export both sheets as files, one for this week and one for last week. Match the rows by SKU, then compare the product, price, and stock status fields. The result is a list of products that were added, removed, or changed.
Which export should you use from Google Sheets?
Use an exported file from each sheet copy, one for the current week and one for the previous week. The workflow reads those files and compares the rows inside them.
What happens to rows that do not match by SKU?
Rows with a SKU that appears in only one file are still handled. They show up as added or removed, instead of being matched to a different product.
How do you change the comparison rules?
Edit the rules in words, for example, change which column is used to match rows or which fields are checked for changes. Then run the workflow again with the same exported files or new ones.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.