A West Michigan custom sign manufacturer runs its whole shop from one Google Sheet: a row per job on the master board, and a tab per job where every department checks off every sign.
Everything on that board was kept up by hand. Install dates lived on 15+ crew calendars and had to be copied over. Field reports from install crews came in through a Google Form, and the foreman read each one and typed the notes and status onto the board. Field photos arrived as links that often didn't open. To know whether a job was ready to install, someone opened its tab. Finished jobs were cleared off by hand, two or three a day, while the sheet grew toward Google's size limit.
The board now keeps itself up to date. When an install date changes on a crew's calendar, the new date shows up on the board within 30 minutes and the board re-sorts itself. When a department checks off a sign on a job's tab, the job's row on the master board updates within seconds, and once every department and special order is done, the job marks itself Ready for Install. When a crew sends in a field report, their notes and the job's status land on the job's row within the hour, and the photos arrive in the shop inbox as attachments anyone can open. When a job is finished and invoiced, it's backed up and taken off the board overnight. The system also watches itself. Anything it can't match, like a calendar entry with no job or a report with the wrong job number, goes to a person to check instead of changing the board. If field reports stop coming in, or someone moves a column the system depends on, we get an alert. Before, the foreman was the link between every part of the shop and the board. He typed up what crews reported from the field and cleared finished jobs off by hand. Install dates had to be carried over from the calendars, and the front office had to open a job's tab to know where it stood. Now the board does that carrying. The front office reads one board instead of opening tabs, install dates and field reports show up on their own, and the foreman hasn't had to clear a finished job by hand since October 7, 2026. The sheet, which had been heading for Google's size limit, is getting smaller as finished jobs leave on their own. People still make every call that needs judgment: entering the job, checking off the work, booking the install, filing the field report and invoicing. What's gone is the retyping between those steps.
- Time to results
- 4–8 weeks
- Company size
- 51-250 people
- Project cost
- Under $25K
- Runs on
- Multi-model
- How One E-Commerce Co Cut Processing Cost 84%Fractional AI · Retail & E-Commerce
- How One Eyewear Brand Lifted Checkout 10% to 15%DevDash Labs · Retail & E-Commerce
- How a Fiber ISP Slashed Dispatch From $11K to $2 a MonthBlueLabel · Telecommunications
- How One Restoration Firm Clawed Back $500 a ProposalCiridae · Construction & Engineering