What we built and why it worked

The team had 50+ tabs and slow scripts, making inventory checks and production updates hard to trust before launch.

Built a single operating system in Google Sheets with FIFO batch tracking, sheet search and pinning, role-based alerts, and founder-level reporting.

"We needed launch-ready operations, not another dashboard. The build now combines inventory, dispatch, invoicing, and CRM signals in one flow our team can actually use every day."

Supplier IDs in WIP BOM were getting edited accidentally and script runs felt blocked during load.

Locked critical fields, added non-blocking loading animations, and tightened stock deduction logic by vendor and material IDs.

"The system now prevents common data-entry failures and gives the team better feedback while scripts run, which reduced confusion during operations."

Leaders needed one place to track inventory, marketing spend, revenue, dispatch, and customer/payment status.

Connected customer master, dispatch registers, invoicing values, and summary reporting with role-based distribution.

"Instead of switching platforms, we connected the sheets we already had and turned them into a decision system for operations and growth."