Every price sheet, stitched into one time series.
Built for a small coffee roaster that gets a new green bean price sheet from its supplier every couple of weeks, each one a standalone spreadsheet snapshot with no memory of the last one. This tool turns that pile of snapshots into one running history, so a price move shows up the moment the next sheet lands.
The problem
A new price file lands every biweekly delivery cycle: same layout, same columns, but a fresh standalone workbook with no link back to the last one. Watching one bean's cost drift over a quarter meant opening a dozen files by hand and eyeballing a single row in each.
The fix: one self refreshing history
A folder watching data pipeline scans every price sheet dropped into one folder, reads the run date off each one, stamps it onto every item row, and stacks all of it into a single dated table. Dropping in a new sheet and clicking refresh is the entire maintenance workflow, no copy paste, no reformatting.
All five items, one view
Same four price runs as the rows above, plotted together so a buyer can see which beans are moving fastest relative to the others, not just each one alone.
How it works
Folder watch ingestion
Points at one shared folder and picks up every matching price sheet automatically, no code changes when a new one shows up.
Auto date stamping
Reads the run date off each sheet and stamps it onto every item row, turning standalone snapshots into a true time series.
One item, every date
A dedicated view slices the combined history by item, so a single bean's cost across every run is visible at a glance.
Self cleaning
Blank layout rows, duplicate downloads, and the tracker file itself are filtered out automatically, so the history stays clean.
A real tool, built in a day
This shipped as a working workbook, not a mockup: a folder driven data pipeline plus three ready made views (by item, by date, by price), built on top of a spreadsheet the owner already knew how to use.
View other projects →Related systems
Customer Success Command Center · a command center that replaced five spreadsheets with one screen and credited $30,321 in retained revenue.
Market Intelligence Pipeline · an automated four stage pipeline that turns raw public data into a ranked opportunity list.
AI Visibility Audit · a structured audit run on this very site to make it findable, trusted, and quotable by AI answer engines.
Video to Documentation Pipeline · turns one monthly walkthrough recording into four polished, branded release documents automatically.