Client (Anonymized)
From Email to Predictive Dashboard
The Situation
A family-owned materials company with €15 million in revenue serves industrial customers who operate storage silos requiring regular replenishment. Customer systems automatically send fill-level reports via email every six hours. Structured data, arriving reliably. But a person manually opened every email, extracted numbers, and entered them into Excel spreadsheets — multiple times a day.
The Problem
The decision at the end is binary: deliver more material or not. But the process to reach that decision was entirely manual. No historical trend data. No predictive capability. No visibility into when a silo would actually run low. The data existed. The decisions were straightforward. The bottleneck was the human copy-paste loop.
The Approach
Discovery meeting with the owner — full scope clear within 20 minutes
Process mapping in FigJam: email → manual extraction → Excel → decision
Dashboard prototype generated using v0 (AI design tool) for rapid iteration
Visual design and specification refined in Figma with the development team
Firebase stack selected: Firestore, Auth, Hosting for near-zero infrastructure cost
Technical specification with development estimate delivered to the team
The Magic Moment
Using v0 to generate the initial dashboard prototype collapsed what would normally be days of wireframing into hours. The owner could see and interact with a working concept in the first session. When the path from data to decision is this clear, the technology should be invisible.
The Outcome
A real-time monitoring dashboard that eliminates manual email-to-Excel data entry entirely. Automated email parsing feeds live silo levels into a visual dashboard with historical trends and predictive forecasting. Firebase architecture keeps infrastructure costs near zero.
Automated email parsing replacing daily manual data extraction
Real-time dashboard with silo fill levels and trend visualization
Predictive forecasting from historical data patterns
Firebase stack: near-zero infrastructure cost
What Transferred
Not every project needs to be complex. The enormous value here came from recognizing that the data already existed in a structured format — it just needed to be freed from email inboxes. v0 and Figma let us show, not tell. The working prototype in the first session built more trust than any proposal deck.