Real client

Print shop: jobs per month and tasks done right on one owner dashboard

Screen Printing Northwest does screen printing, embroidery and heat press in Everett, Washington. The production manager enters the day's jobs, each operator sees their own list and closes it, and the owner sees the numbers on one dashboard.

Looker Studio owner view with jobs completed, tasks done right, production efficiency, jobs per month and units per hour by operator.

Client: Screen Printing Northwest
Trade: Screen printing shop
Repeat work: Client since Feb 2022. Came back in 2022, 2024, 2025 and 2026.
Built by: Founder-led in 2022, then a PM and Sheets developers
Tools: Google Sheets
Apps Script
Looker Studio
n8n
Slack
Mailchimp

Before and after

The shop ran on separate Excel files, and the production manager chased each job for status.

Before and after
	Before	After
Jobs	Each job lived in a separate Excel file	One linked system
Status	The production manager chased each job	Operators close their own jobs, the report builds itself
Owner view	No one view of the floor	Jobs per month and efficiency by operator

What we built

The day's tasks in one place. The production manager enters them once.
Operator views. Operators see their own printing and embroidery jobs, fill in the job settings and close them.
A report nobody types. The production manager's report fills in by itself.
Owner dashboard. Jobs per month, tasks done right and production efficiency.
Earlier work. New orders posted to Slack with what the floor needs, and Mailchimp automations.

How it works

The production manager enters the day's jobsGoogle Sheets
Each operator sees their own jobs, logs the settings they ran and closes the jobGoogle Sheets, Apps Script
The report builds itselfApps Script
The owner sees jobs per month and efficiency by operatorLooker Studio