Your Business in Two Tabs
Every business runs at least two value streams: money coming in from customers, and value going out to customers. If you can't answer "what do I owe customers and what do customers owe me?" in under 30 seconds, you don't have a project management problem — you have a value stream problem. Here's how to fix it in an afternoon.
Before & After
Imagine you run a sign shop. It's Tuesday morning. A customer calls asking about a quote you sent two weeks ago. You check email — nothing. You check the quote folder on your desktop — there it is, but did they ever respond? You dig through your inbox for 10 minutes. Meanwhile, another customer is waiting for a status update on their order, and your supplier invoice is somewhere in the stack of papers on your desk.
You've spent 45 minutes and haven't started any actual work yet.
Same Tuesday morning. You open Claude Desktop and ask: "What's outstanding right now?" In 5 seconds, Claude reads your sheet and tells you: 3 unpaid invoices totaling $4,200 (one is 22 days overdue), 2 quotes waiting for response, and 1 job that's supposed to ship Friday but doesn't have a delivery address confirmed.
You know exactly what needs attention. Your first real task starts at 8:05, not 8:45.
What You Need
- Claude Desktop installed — follow the setup guide if you haven't yet
- A Google account — for Google Sheets (any free account works)
- 30 minutes — that's all it takes for the basic setup
Create Your Two-Tab Sheet
Open Google Sheets and create a new spreadsheet. Name it something you'll recognize — "[Your Business] Operations" works fine.
Rename the first tab Inbound (this tracks money coming in) and create a second tab called Outbound (this tracks value going out).
Inbound tab columns:
| Column | What it tracks | Example |
|---|---|---|
| ID | Unique identifier | INB-001 |
| Customer | Who's paying | Martinez Construction |
| Description | What they're buying | Channel letter sign, 6ft |
| Amount | How much | $2,400 |
| Status | Where it stands | Quoted / Accepted / Invoiced / Paid |
| Date Sent | When quote or invoice went out | 2026-04-01 |
| Follow-Up Date | When to check in next | 2026-04-08 |
Outbound tab columns:
| Column | What it tracks | Example |
|---|---|---|
| ID | Same ID as Inbound (links them) | INB-001 |
| Customer | Who you're delivering to | Martinez Construction |
| Job Description | What you're making/delivering | Channel letter sign, 6ft, red LED |
| Milestone | Current phase | Design / Fabrication / Install / Complete |
| Deadline | When it's due | 2026-04-20 |
| Status | On track? | On Track / At Risk / Late / Delivered |
| Notes | Anything Claude should know | Customer wants install on a Saturday |
Add Your Real Data
Don't start with fake examples. Open your email, your quote folder, your invoice stack — wherever your actual business lives right now — and enter 5–10 real items on each tab.
This should take about 15 minutes. It feels tedious, but it's the last time you'll have to do this manually — from now on, Claude helps you keep it current.
Connect Claude to Your Sheet
Claude Desktop can read and write Google Sheets directly using MCP (Model Context Protocol). Here's how to set it up:
-
Open Claude Desktop in any folder on your computer
-
Tell Claude: "I want to connect you to my Google Sheet so you can read and write it. Help me set up the Google Sheets MCP server."
-
Claude will walk you through the setup — it involves authorizing access to your Google account and adding a configuration to Claude's settings. Follow its instructions.
-
Once connected, test it: "Read my Operations sheet and tell me what's on the Inbound tab."
Ask Your First Questions
Once Claude can read your sheet, try these. Copy them exactly or say them in your own words — Claude understands plain English.
That last one is the moment it clicks. You just updated two tabs with one sentence.
What You've Built
In about 30 minutes, you now have:
- A single source of truth for every dollar coming in and every job going out
- An AI assistant that can answer plain-English questions about your business in seconds
- A foundation that every other workflow builds on — follow-ups, invoicing, status updates, and more
This is the substrate. Every other guide on this site assumes you have these two tabs set up. Once Claude knows your value streams, it can do real work for you — not just answer questions, but draft emails, flag problems, and keep you on top of things you'd otherwise forget.
What's Next?
Follow-Up Sequences
Never let a lead go cold again. Claude drafts the nudge; you approve.
Read the GuideInvoice Follow-Up
Stop losing money to silence. Claude drafts the nudge so you get paid.
Read the GuideWant this set up on your machine with your real data?
Book a Starter Session (90 min)Or do it yourself — everything on this page is free.
Skill: Your Business in Two Tabs
What this is for: Walk a small business owner through creating a two-tab Google Sheet that tracks their two value streams — money coming in (Inbound) and value going out (Outbound) — then connect it to Claude so they can ask plain-English questions about their business.
When to use this: When a user asks their AI assistant to help set up this workflow. The user should explicitly authorize use of this skill by referencing this page URL.