Google Sheets to Excel every week, with checks
“turn the inventory google sheet our warehouse team updates into an excel file for finance every monday with stock value per item, and flag items with negative stock, items with no unit cost, and items whose stock count has not changed in thirty days”
Turn the Warehouse inventory Google Sheet into an excel file for finance every monday with stock value per item, and flag items with negative stock, items with no unit cost, and items whose stock count has not changed in thirty days, using Last Counted as the 30-day check.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileWarehouse inventory Google SheetCSV export · 40 rows
- StepAdd stock value and flagsStep 1
- ResultInventory stock flags40 rows
- ScheduleRuns every mondayProposed
On the sample files, every step runs and the result has 40 rows.
- Download Warehouse inventory Google Sheet sample (40 rows)Google Sheets: File > Download > Microsoft Excel (.xlsx)
What you get back
The result of that run, the rows to look at first.
| SKU | Item | Location | Stock value (USD) | Stock flag | Unit cost flag | Count age flag | On Hand | Unit Cost (USD) | Last Counted |
|---|---|---|---|---|---|---|---|---|---|
| PRT-1003 | Filter Cartridge | Annex | · | Stock is not negative | No unit cost | Counted within 30 days | 0 | · | 2026-11-10 |
| PRT-1013 | Bearing Sleeve | Annex | · | Stock is not negative | No unit cost | Counted within 30 days | 19 | · | 2026-11-04 |
| PRT-1025 | Relay Socket | Annex | · | Stock is not negative | No unit cost | Counted within 30 days | 14 | · | 2026-11-05 |
| PRT-1031 | Bushing Set | Annex | 226.80 | Stock is not negative | Unit cost present | Not counted in 30 days | 27 | 8.40 | 2026-10-09 |
| PRT-1032 | Thermal Pad | Main | 52 | Stock is not negative | Unit cost present | Not counted in 30 days | 10 | 5.20 | 2026-10-01 |
| PRT-1033 | Outlet Valve | Annex | -102 | Negative stock | Unit cost present | Counted within 30 days | -3 | 34 | 2026-11-17 |
| PRT-1037 | Rotor Blade | Annex | -128 | Negative stock | Unit cost present | Counted within 30 days | -1 | 128 | 2026-11-16 |
| PRT-1039 | Panel Clip | Annex | 118.95 | Stock is not negative | Unit cost present | Not counted in 30 days | 61 | 1.95 | 2026-10-12 |
| PRT-1001 | Bearing Kit | Main | 777 | Stock is not negative | Unit cost present | Counted within 30 days | 42 | 18.50 | 2026-11-14 |
| PRT-1002 | Hydraulic Hose 3m | Main | 432 | Stock is not negative | Unit cost present | Counted within 30 days | 18 | 24 | 2026-11-12 |
| PRT-1004 | Brake Pad Set | Main | 2,375 | Stock is not negative | Unit cost present | Counted within 30 days | 76 | 31.25 | 2026-11-08 |
| PRT-1005 | Seal Ring 50mm | Annex | 72 | Stock is not negative | Unit cost present | Counted within 30 days | 15 | 4.80 | 2026-11-06 |
How it works
How to use the Inventory stock flags 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.
Inventory stock flags: questions
How do you turn Google Sheets into Excel every week with checks?
Which export should you use from Google Sheets?
What happens to rows that do not match the checks?
How do you change the rules in words?
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