Issue · 2026-07-12 · Email subscribers
Weekly ops dashboard — click-by-click Google Sheets, Zapier, and Gmail guide
Monday morning. You open Gmail and try to remember which quotes are still open, which jobs need parts, and who you promised to call back.
That mental inventory is the ops tax. One live Google Sheet ends it — every open quote and active job in one view — plus a Monday digest of rows past their next-action date (skipped when the list is clear).
The outcome: Monday typically starts with a list, not an inbox hunt (in our tests). Evenings get quieter because the week already told you what matters.
Who this is for
- Solo owners and small service teams whose pipeline still lives in email threads
- Anyone running Playbooks #2 (quote follow-up) and #5 (invoice chase) without a single “what’s open?” view
- Teams not ready for a full CRM but tired of forgetting open work
Not for you if… a CRM already shows open quotes and jobs you trust every morning. Wire this playbook when the truth still hides in Sent folders and half-updated notes.
What's gated
Problem, outcome, and FAQs are public here. Full Sheet columns, capture Zaps, digest copy, soft-fail skip rules, and troubleshooting are in Playbook #9 via free email subscribe.
Pairs well with: Quote follow-up and Invoice chase. Next: Slack team alerts once visibility is trustworthy.
Frequently asked questions
Is this just “make a spreadsheet”?
The Sheet is the system of record. The playbook’s value is capture paths (so rows appear when quotes/jobs happen) plus a Monday digest with a soft-fail skip when nothing is due — so overdue next actions surface without you remembering to open the file.
Do I need a CRM?
No. Google Sheets + Gmail + Zapier is enough for 1–10 person service businesses. Graduate to a CRM when multiple people need permissions and reporting.
Won't a Monday email become noise?
Only if you leave blank due dates or never close rows. Skip send when zero items match — or fix blank dues first.
How does this relate to quote follow-up automation?
Playbook
How long does setup take?
About 35 minutes for a first-time builder (tracker, one capture path, Monday digest, and an end-to-end test). Experienced Zapier users often finish closer to 20–25 minutes.
How do I get the full setup guide?
Subscribe free — Playbook
Get the weekly ops dashboard playbook free
Sheet columns, capture paths, and Monday digest Zap — Playbook