Client Onboarding Tracker in Google Sheets: A Free Template (and When to Outgrow It)

TLDR: You can build a genuinely useful client onboarding tracker in Google Sheets using three tabs (Clients, Tasks, and Documents), status dropdowns, conditional formatting, and one percent-complete formula per client. It works well for the internal side of onboarding. It falls short on client-facing document collection, automatic reminders, and clean per-client access. Most service businesses run this spreadsheet happily until about three to five new clients a month, then move to purpose-built onboarding software.

A Google Sheet is where a huge number of service businesses build their first real client onboarding tracker. It makes sense. You already live in spreadsheets, everyone on the team knows how to use one, and it costs nothing. For the internal half of the job, a client onboarding template in Google Sheets does the work well.

This guide gives you the actual structure to build that tracker, the specific dropdowns and formulas to copy, a starter checklist of what it should contain, and an honest map of where a spreadsheet stops being the right tool. No fluff, no “it depends.” You will know exactly what to build and exactly when to switch.

Why service businesses reach for a spreadsheet first

Before we build anything, it helps to name why Google Sheets is the default choice for tracking client onboarding. The appeal is real, and it also tells you where the cracks will show up later.

• It is free and already open. No new subscription, no new login, no procurement conversation.
• Everyone knows how to use it. No training. A new hire can read a well-built onboarding sheet in thirty seconds.
• It is endlessly flexible. Add a column, add a tab, change a status. You are not boxed into someone else’s idea of onboarding.
• It is easy to share. One link and your team is looking at the same live data.

Every one of those is true. The catch is that all four describe the internal experience. Client onboarding has a second half, the client-facing half, and a spreadsheet was never designed to compete there. Hold that thought. First, let’s build the part Sheets does well.

How to build a client onboarding tracker in Google Sheets

A good onboarding tracker is three tabs and a handful of dropdowns. That is the whole architecture. Here is how the pieces fit together.

Step 1: Build the Clients tab

Create a tab called Clients with one row per client. Useful columns: client name, main contact, email, engagement type (project or retainer), start date, onboarding status (Not started, In progress, Done), and a percent-complete cell you will fill in with a formula in Step 5. This is your command center. Every client’s status should be readable at a glance from this one tab.

Step 2: Build the Tasks tab

Create a Tasks tab. Each row is one task for one client. Columns: Client (the name, matching the Clients tab exactly), Task, Owner (you or a team member), Status, Due date, and a “Who” column marking whether the task is on you or the client. There are no true relations in Sheets, so the Client column is your join key. Keep the names identical to the Clients tab so lookups and counts work. To keep them clean, use data validation on the Client column pointing at the Clients tab range, so you pick from a dropdown instead of retyping.

Step 3: Add status dropdowns with data validation

Select the Status column on both the Tasks and Documents tabs, then use Data > Data validation to add a dropdown. For tasks, use Not started, In progress, Blocked, and Done. Dropdowns stop the “done” vs “complete” vs “finished” mess that quietly breaks every formula you build later. Consistent status values are the foundation of an onboarding tracker that actually adds up.

Step 4: Build the Documents tab

Create a Documents tab, one row per file you need: signed agreement, W-9, ID, brand assets, platform access, and so on. Columns: Client, File, Status (Requested, Received, Approved), and a “Received on” date. This is how you replace “did they send the logo yet?” with a view you can scan. It is also, as you will see below, the tab that exposes the biggest weakness of running onboarding in a spreadsheet.

Step 5: Add conditional formatting and a percent-complete formula

This is where a plain sheet becomes a tracker. Two moves:

Conditional formatting. Select the Status columns and use Format > Conditional formatting so Done turns green, Blocked or overdue turns red, and In progress turns amber. Now progress is a color, not a reading exercise. To flag overdue work automatically, add a custom formula rule such as =AND($E2<TODAY(), $D2<>"Done") on the Tasks tab so anything past its due date and not finished lights up red.

Percent complete. On the Clients tab, add a formula that counts finished tasks against total tasks for each client. Something like:

=IFERROR( COUNTIFS(Tasks!$A:$A, $A2, Tasks!$D:$D, "Done") / COUNTIF(Tasks!$A:$A, $A2), 0 )

That reads: of all tasks belonging to this client, what share are Done. Format the cell as a percentage and you have a live progress bar in numbers. If you want a deeper, tool-agnostic view of what to measure, the guide on client onboarding progress tracking goes further.

Step 6: Duplicate the sheet for each new client (or keep it one master)

You have two options. Keep one master file where all clients share the Tasks and Documents tabs (cleaner reporting, filtered views per client), or duplicate a template file for each new client (simpler, but your data fragments across many files). Most teams start with duplication and regret it around client ten, when there is no single place to see everyone. If you want a version of this process that is not tied to any one tool, see how to build a client onboarding workflow from scratch.

What your onboarding tracker should contain

Structure is empty until you fill it with the right steps. Use this as your starting checklist for the Tasks and Documents tabs. It maps to the phases most service businesses actually run.

If you want a tool-agnostic version you can adapt, the client onboarding checklist for service businesses covers each of these phases in more depth.

Where a spreadsheet stops being the right tool

Here is the part most template roundups skip. Google Sheets is excellent at the internal half of onboarding, tracking what needs to happen, and weak at the client-facing half, actually getting clients to do their part smoothly and safely. The gap is not a knock on Sheets. It is a genuinely different job.

Three specific breakdowns show up for almost everyone:

Document collection is fragile. A spreadsheet has no real intake for clients. You can drop a Drive link in a cell, but there is no upload validation, no required-file logic, and no clean per-item request. In practice, files end up scattered across email, Drive, and Slack, and you spend time reassembling a complete set. Sensitive files like tax IDs and financial records attached to or linked from a shared sheet is also a security posture you probably do not want. For that specific problem, see how to collect documents from clients securely.

Reminders are manual. A sheet can visually flag your overdue rows in red. It cannot politely and automatically remind a client that they still owe you three things. So the follow-up lands back on you, which is the exact chore the tracker was supposed to eliminate. If chasing is your main pain, stop chasing clients for documents covers how to automate it away.

Client access is messy. Share the sheet and a client can see every other client’s rows, or edit yours by accident, or forward the link to someone you never intended. You can protect ranges and build filtered views, but it is fiddly and it breaks the moment you add a column. Clients also see a spreadsheet, not a simple “here is what you need to do” experience, and many quietly stall the moment the tool feels like work.

Google Sheets vs purpose-built onboarding software

The pattern is clear. Sheets wins on flexibility and cost. Purpose-built tools win on everything that touches the client. Which side matters more depends entirely on volume.

When to graduate from a Google Sheets tracker

You do not need to abandon the spreadsheet the day you set it up. The right move is to run the free tracker until the manual work outweighs the flexibility. For most service businesses, that tipping point lands somewhere between three and five new clients a month. Watch for these signals:

• You are sending manual follow-up emails because clients ignore the shared sheet.
• Documents keep landing in the wrong place and you rebuild a complete file by hand.
• You duplicate or heavily tweak the same tabs for every new engagement.
• Clients tell you the sheet is confusing, or they simply stop responding.
• Onboarding quality now depends on you personally remembering to chase people.

When two or three of those are true every week, the flexibility the spreadsheet gave you is now costing you more time than a purpose-built tool would. That is the moment to graduate. If you want the numbers behind the decision, the client onboarding metrics and KPIs to track show you how to measure whether onboarding is actually slowing down.

Purpose-built tools like OnboardMap replace the client-facing half that a spreadsheet cannot cover. You describe what you need in one sentence, it builds the onboarding (checklist, intake forms, and document requests), and each client gets one magic link, no login. It then tracks every step, reads uploaded files, and sends the reminders automatically so the chasing stops being your job. You can keep Sheets as your internal scratchpad and let the onboarding tool own the client experience. If you are weighing that switch, the head-to-head on OnboardMap versus spreadsheets lays out the trade in full, and you can start free at app.onboardmap.com/signup.

The bottom line

Google Sheets is a genuinely good place to build your first client onboarding tracker, and the three-tab structure in this guide, with dropdowns, conditional formatting, and a percent-complete formula, will serve you well for free. Just build it with clear eyes. A spreadsheet owns the internal side of onboarding and struggles with the client-facing side, so plan to move to purpose-built software once the volume of manual chasing makes the trade no longer worth it. Build the tracker today, watch for the switch signals, and upgrade when they show up.

Frequently asked questions

Can you track client onboarding in Google Sheets? Yes. Google Sheets is a strong, free way to track client onboarding internally. Build three tabs (Clients, Tasks, and Documents), use status dropdowns and conditional formatting for at-a-glance progress, and add a simple percent-complete formula per client. It works well for tracking what needs to happen. It struggles the moment you need clients to upload sensitive files, get automatic reminders, or see only their own tasks.

How do I build a client onboarding template in Google Sheets? Create a Clients tab with one row per client, a Tasks tab that references each client by name with a Status dropdown, and a Documents tab that tracks each requested file as Requested, Received, or Approved. Add conditional formatting so statuses color themselves, then a COUNTIF-based percent-complete column so you can scan progress.

Is Google Sheets secure enough for collecting client documents? Google Sheets encrypts data in transit and at rest, which is fine for internal tracking. It is not built for client-facing document intake. A shared sheet can be forwarded or over-shared, there is no per-file access expiry or upload validation, and attaching sensitive files like tax IDs to a shared sheet is a weak security posture. For financial records or IDs, a tool with expiring, revocable links and an audit log is the safer choice.

When should I move from a Google Sheets tracker to onboarding software? Move when the manual work outweighs the flexibility, usually somewhere between three and five new clients a month. The clearest signals are chasing clients for documents by hand, copying the same tabs for every new client, and clients ignoring a spreadsheet they find confusing.