One spreadsheet, seven salespeople: the ROI Metal Buildings dashboard

How a metal-building manufacturer gave seven reps a private window into their own deals — without changing the spreadsheet that runs the business.

ROI Metal Buildings runs its entire sales operation out of one spreadsheet. Fifty-plus columns. One person can actually read it.

Their seven salespeople were flying blind on their own deals. Project status, delivery dates, commission — all of it lived in a master sheet only the ops manager could navigate. A rep who wanted to know "when's my building shipping, and when do I get paid?" had to go ask. Every time.

The obvious fix was a trap

Their first instinct was the one everybody reaches for: add buttons to the spreadsheet. Click a button, push an update.

But buttons were a trap. You can't hide one rep's numbers from another inside a shared spreadsheet — sheet protection isn't access control; anyone with the file can switch it off and read everyone's commissions. And a button can't safely write across separate files without bolting on paid tooling and hoping it doesn't break when two people edit at once.

So we built the thing the buttons were a workaround for

A private dashboard, one login per salesperson, that reads their existing master sheet automatically. Three things make it work:

• It reads the source of truth. The ops manager keeps working in the exact spreadsheet she already maintains. Nobody enters data twice. Nothing changes for the person who runs the sheet.
• Each rep sees only their own book. Log in with your work email; see your projects, your delivery dates, your commissions — and nobody else's. Enforced by login, not by hoping people don't scroll.
• Estimated dates lock in once; actuals update live. The sheet changes, the dashboard reflects it within 15 minutes. No buttons to maintain, no second sheet to keep in sync.

The lesson scales

The information your team needs is almost always already sitting in a spreadsheet someone maintains. The problem isn't the data — it's that there's no window each person can safely look through. You rarely need a new system. You need a read-layer and real access control on the one you already trust.

That's most of what "AI automation" actually is for a small business: not ripping out what works, but putting a clean, private, always-current window onto it.

Building products? Storage? Contracting? If your crew is asking "where's my job at" and the answer lives in a tab they can't open — that's the gap.