A step-by-step guide to building a client management spreadsheet that tracks onboarding, check-ins, progress, and renewals — all inside Google Sheets.
Most online fitness coaches start the same way: a Google Drive folder per client, a few shared docs, and a prayer that nothing falls through the cracks. It works at five clients. At fifteen, you're drowning. At thirty, you're making mistakes that cost you renewals.
The fix isn't buying expensive software. It's building a proper client management system inside the tool you already know — Google Sheets.
This guide walks you through the exact structure that keeps coaches organised at scale, without paying monthly fees or learning a new platform.
Why Google Sheets Beats Dedicated Coaching Apps for Client Management
Dedicated coaching platforms like Trainerize or TrueCoach charge £20–125 per month and lock your data behind their login. When you leave, your client history leaves with you — or rather, it doesn't. You lose everything.
Google Sheets gives you full ownership of your data, zero monthly fees, and a tool your clients already know how to use. Need to share a progress dashboard? Send a link. Need to pull a report? It's a pivot table away. Want to automate check-in reminders? Google Apps Script handles that in minutes.
The coaches who scale past 30, 40, 50 clients aren't the ones with the fanciest app — they're the ones with the best systems. And a well-built spreadsheet is a system you control completely.
The Five Tabs Every Coaching Spreadsheet Needs
A functional client management sheet isn't one massive grid. It's five focused tabs that talk to each other.
1. Client Roster
Your single source of truth. Every active client lives here with:
- Name, email, start date, package type
- Current phase (onboarding, active, renewal due, paused)
- Renewal date with conditional formatting that turns amber at 14 days out and red at 7
- Notes column for context you'd otherwise forget
This tab answers one question: who needs attention today?
2. Onboarding Tracker
New clients need a consistent experience. This tab tracks every step:
- Intake form received
- Goals documented
- Initial measurements logged
- Training programme sent
- Nutrition targets set
- Welcome message delivered
Use checkboxes. When all six are ticked, a formula marks the client as "Active" on the roster. No client slips through half-onboarded again.
3. Weekly Check-In Log
This is where coaching actually happens. Structure each row as:
| Client | Week | Weight | Adherence (1-10) | Sleep (1-10) | Stress (1-10) | Coach Notes | Action Items |
Conditional formatting highlights any adherence score below 6 in red. That's your early warning system for clients who are struggling before they tell you — or worse, before they ghost.
If you want to take this further, 10 automations can save you hours every week on check-in processing alone.
4. Progress Dashboard
Clients want to see they're making progress. This tab pulls data from the check-in log and visualises it:
- Weight trend (sparkline chart)
- Adherence average over the last 4 weeks
- Personal records for key lifts
- Measurements (waist, hips, chest) tracked monthly
Share this tab (read-only) with the client. It replaces the "am I making progress?" question with hard data. That's how you keep clients for 12 months instead of 12 weeks.
5. Revenue and Renewals
Your coaching business is a business. Track it like one:
- Monthly recurring revenue by client
- Renewal dates sorted chronologically
- Churn tracking — who left and why
- Lifetime value per client
This tab tells you whether your business is growing or slowly bleeding. Most coaches don't track this until it's too late. If you want a deeper dive into the metrics that matter, read growth coaching systems and the numbers you should watch weekly.
Setting It Up: The 60-Minute Sprint
You don't need a weekend to build this. Here's a realistic timeline:
Minutes 1–15: Client Roster. List every active client. Add columns for status, package, start date, and renewal date. Apply conditional formatting to renewal dates.
Minutes 15–30: Onboarding Tracker. Create your checklist columns. Add checkboxes. Write a simple COUNTIF formula to flag incomplete onboards on the roster tab.
Minutes 30–45: Check-In Log. Build the table structure. Add data validation dropdowns for adherence and sleep scores (1–10). Apply conditional formatting for low scores.
Minutes 45–60: Dashboard + Revenue. Create sparkline charts pulling from the check-in log. Add a revenue summary with SUMIF by client status.
That's it. Sixty minutes and you have a system that scales to 50+ clients without hiring help.
Common Mistakes to Avoid
Putting everything in one tab. It becomes unreadable by week three. Separate concerns, link with formulas.
Not using data validation. Free-text fields lead to inconsistent data. Use dropdowns for status fields, package types, and scores.
Forgetting mobile. Your clients will check shared tabs on their phones. Keep column widths reasonable and avoid horizontal scrolling.
Skipping automations. Manual reminders don't scale. Even basic automated client sheets save 3–5 hours per week once you pass 20 clients.
Frequently Asked Questions
Can I use Google Sheets on mobile to manage clients?
Yes. The Google Sheets mobile app is free on iOS and Android. Clients can view shared tabs, and you can review check-ins on the go. Keep columns narrow and avoid complex formatting that breaks on small screens.
How many clients can one spreadsheet handle?
A single Google Sheet comfortably handles 50–75 clients before performance starts to slow. Beyond that, split into separate spreadsheets per client and use a master roster to link them. Most coaches find one sheet per client with a central dashboard is the cleanest approach at scale.
Is Google Sheets secure enough for client data?
Google Sheets uses the same enterprise-grade security as Gmail and Google Drive. You control sharing permissions per tab or per sheet. Share specific tabs as read-only for clients and keep coaching notes private. It's more secure than most coaching apps, where you have zero control over how your data is stored.
When to Level Up
A DIY spreadsheet works. But building and maintaining the formulas, automations, and dashboards yourself takes time you could spend coaching.
GSheetsPro gives you this entire system — pre-built, tested, and ready to use — for a one-time £199. No subscriptions, no lock-in, no starting from scratch. Just duplicate, brand, and start onboarding.
If you're spending more than an hour a week on admin, the system has already paid for itself.
