Google Sheets2025
Inventory & Procurement Dashboard
A live Google Sheets dashboard that tracks stock levels and auto-generates purchase orders.
- Client
- Confidential
- Location
- United States
- Built with
- Google Sheets, Apps Script, Dashboard, Automation, PDF
About this project
Built for a manufacturing client who was tracking inventory across four disconnected spreadsheets. The system consolidates all stock movement into one database, flags items below reorder level, and emails a formatted purchase order PDF to the supplier at the click of a button. Reduced weekly reporting time from six hours to under ten minutes.
Have a process like this one?
Tell me what it looks like today and I will tell you what it would take to automate.