Small Business KPI Dashboard in Google Sheets: A Weekly Template for Solo Owners

Updated 2026-10-24 · AI Agent Starter Kit

Most KPI dashboard templates are built for companies with a sales team, a finance department and a data person. If you run a one-person business, you do not need 40 charts. You need a handful of numbers you can read in two minutes on Monday morning, and a clear signal about what to do next.

This guide walks through a weekly dashboard that fits on one screen in Google Sheets. It covers which numbers to track, how to lay out the sheet, a few starter formulas, and how to stop typing the numbers in by hand.

Why weekly beats daily or monthly

Daily numbers are noisy for a small business. One slow Tuesday tells you nothing. Monthly numbers are too slow: by the time you see a problem, four weeks of leads have already gone cold.

Weekly is the sweet spot. It is frequent enough to catch a leak in your pipeline while you can still fix it, and slow enough that the numbers mean something. It also matches how most solo owners already plan: Monday is when you decide what matters this week.

The 8 numbers worth tracking

Pick numbers you can actually act on. For most service businesses (consultants, coaches, contractors, agencies of one, freelancers), these eight cover it:

Notice that only two of these are money numbers. The rest are leading indicators: they move before revenue does. If new leads are steady but booked calls drop, the problem is your first reply, not your marketing.

The layout: one tab for data, one for the dashboard

Keep the structure boring so it never breaks.

Tab 1: Weekly. One row per week. Column A is the week start date (a Monday). Columns B through I are the eight metrics above. You only ever add a row; you never edit old ones.

Tab 2: Dashboard. This tab only reads from the Weekly tab. It shows:

1. This week's eight numbers in large cells across the top.
2. Each number's change versus last week, with a simple up or down arrow.
3. A 4-week average for each metric, so one odd week does not scare you.
4. An 8-week trend chart for new leads, booked calls and revenue.

That is the whole dashboard. If it does not fit on one laptop screen, cut something.

Starter formulas

Assuming the Weekly tab has headers in row 1 and data from row 2 down, with new weeks added at the bottom:

Latest value of a metric (for example, new leads in column B):

=INDEX(Weekly!B:B, COUNTA(Weekly!A:A))

Last week's value:

=INDEX(Weekly!B:B, COUNTA(Weekly!A:A)-1)

Change versus last week, as a percentage:

=IFERROR((B2-B3)/B3, "")

(where B2 holds this week and B3 holds last week on the Dashboard tab)

4-week average:

=AVERAGE(OFFSET(Weekly!B1, COUNTA(Weekly!A:A)-4, 0, 4, 1))

Simple status flag (green if better than the 4-week average, red if worse):

=IF(B2>=B4, "On track", "Watch")

For metrics where lower is better (first-reply time, overdue replies, stuck leads), flip the comparison. Use conditional formatting to color the cells instead of reading the words.

For the trend chart, select the date column and the three metrics for the last 8 rows, then Insert, Chart, Line chart.

Reading it in two minutes

A dashboard is only useful if it changes what you do. A simple Monday routine:

1. Look at overdue replies and stuck leads first. These are people waiting on you. Clear them before anything else.
2. Check first-reply time. If it crept up, block time on your calendar for lead replies, or automate the first draft. (Our lead response time calculator gives a rough estimate of what slow replies might cost you.)
3. Compare leads to booked calls. A drop in that ratio usually means your first reply or your offer needs work.
4. Then look at revenue. It is the lagging number. If the first three are healthy, revenue tends to follow.
5. Write your top 3 for the week at the bottom of the dashboard.

The real problem: filling it in

Every solo owner who has tried a KPI spreadsheet knows how this ends. Week one, you fill it in. Week three, you skip it. By week six it is a graveyard.

The fix is to stop typing numbers. Most of these metrics already exist in tools you use: your lead form, your Gmail, your calendar. An automation tool like n8n can count them for you every Monday morning and append the row to your Weekly tab.

Two rules keep this trustworthy:

• Let code count, not AI. Counting leads or measuring reply times is arithmetic. Do it with plain code so the numbers are exact. Use AI only for the parts that need words, like a short summary of what changed.
• Check the AI against the numbers. If an AI writes your weekly summary, have the workflow compare every number in that summary with the numbers it actually counted, and remove anything that does not match. AI models occasionally make up figures, and a dashboard you cannot trust is worse than none.

Want it done for you?

The Weekly CEO Report Kit is an n8n workflow that does exactly this: every Monday at 7 AM it counts your leads, reply times, overdue replies and stuck leads from Gmail, your lead sheet and (optionally) Google Calendar, then saves a one-page report as a Gmail draft to you and logs the row to a Weekly tab. Code does the counting, AI only writes the wording, and a number check strips anything it made up.

The Solo Ops Command Center bundle adds a ready-made dashboard (Excel and Google Sheets, with the formulas and an 8-week trend chart already built, plus Notion imports) on top of all three paid kits.

Prefer to build it yourself? Use the layout and formulas above. They work on their own.

More guides

• How to Set Up an AI Email Assistant That Never Sends Without You (n8n + Gmail)
• n8n Gmail Triage Workflow: Auto-Label Every Email With AI (Free Template Logic)
• Prompt Injection in Email: How to Keep Your AI Inbox Assistant From Getting Tricked
• Build an AI Morning Briefing: Calendar + Inbox + One Priority in a 7 AM Email
• Speed-to-Lead for Solo Businesses: Reply in 5 Minutes Without Sounding Like a Bot
• Weekly Business Report Automation: An Automated Weekly CEO Report for Solo Businesses
• n8n Templates for Small Business: 8 AI Agent Workflows Worth Setting Up First
• AI Agents for Small Business: A Beginner's Guide for Solo Owners
• Lead Follow-Up Email Templates: Day 2, Day 5 and Day 10 (Copy and Paste)
• n8n vs Zapier for Small Business: Which One Should a Solo Owner Pick?