Skip to content
Client project

Print shop runs the floor from one system

The shop ran on several separate Excel files.

Screen Printing Northwest

The shop runs on separate Excel files.

The problem
The shop runs on separate Excel files. Nobody has one view of the jobs.
What we built
One linked system. Google Sheets for the whole floor, linked together.
What changed
The floor runs from one linked system, and the owner sees jobs and accuracy on one dashboard.

The problem

The shop runs on separate Excel files. Nobody has one view of the jobs.

  • The shop ran on several separate Excel files.
  • The production manager chased each job for status.
  • Reports were built by hand, and the owner had no single view of jobs or accuracy.

What we built

  1. One linked system. Google Sheets for the whole floor, linked together.
  2. The day’s tasks. The production manager enters them in one place.
  3. Operator views. Operators see their own printing and embroidery jobs, fill the job settings and close them.
  4. A report that builds itself. The production manager no longer builds it by hand.
  5. An owner dashboard. Jobs per month, tasks done right and production efficiency.
  6. Earlier work. New orders posted to Slack with what the floor needs, and Mailchimp automations.

What changed

The floor runs from one linked system, and the owner sees jobs and accuracy on one dashboard.

The shop keeps coming back for new work, and the owner wrote a public recommendation.

“His ability to understand challenges and then create the perfect scalable solutions has made a huge impact on our business.”

Taylor Baehm, Owner, Screen Printing Northwest, on LinkedIn

Running the floor from loose spreadsheets?

Send the report you rebuild by hand. We will tell you what can build itself.

Tell us how it runs

Two more like this

  • ConstructionHas a video, 1 minute 4 seconds

    Contractor asks his CRM on WhatsApp

    My CRM has years of deals. I never have time to dig through it.

  • Home services

    HVAC owner gets his numbers by asking

    My numbers sit in the CRM and the invoices. A revenue picture means pulling it by hand.

Tools

  • Google Sheets
  • Apps Script
  • n8n
  • Slack
  • Mailchimp

More on Dashboards & Reporting

See all case studies