Most B2B businesses start tracking clients in a spreadsheet, and that is not a mistake. A Google Sheets CRM is free, everyone already knows how to use it, and it can be set up in an hour. The trouble starts a few weeks later, when the sheet is out of date and a quote you sent three weeks ago has quietly gone cold.
This guide shows how to set up a Google Sheets CRM template that holds up: the columns to use, how to stop stages from drifting, how to make overdue follow-ups impossible to miss, and the one thing a spreadsheet will never do on its own.
The columns your Google Sheets CRM needs
Keep it to one row per deal and these columns. Anything more and nobody keeps it current.
- Client and contact. The company, the person and how to reach them.
- Source. Where the inquiry came from: referral (and from whom), WhatsApp, LinkedIn, website, an ad. Fill it the day the inquiry arrives, because nobody remembers later.
- What they asked for. One line, in their words.
- Stage. A dropdown, never free text (see below).
- Value. Your best estimate of the deal in money.
- Last contact. The date you last spoke.
- Next follow-up. The date you will contact them next. Every open deal must have one.
- Lost reason. Filled only when a deal is lost, from a short dropdown.
Stop stages from drifting
The fastest way to ruin a spreadsheet CRM is letting people type the stage. Within a month you have "quote sent", "Quote Sent", "sent quote" and "waiting". Use Data, then Data validation, to make the Stage column a dropdown with a fixed list, for example: New inquiry, In talks, Quote sent, Won, Lost.
Then write down what has to be true for a deal to enter each stage. "Quote sent" should mean the buyer has a priced quote in hand, not that you plan to send one. Our sales pipeline stages template has exit rules you can copy.
Make overdue follow-ups impossible to miss
A spreadsheet CRM fails quietly. Nothing turns red when a follow-up date passes. You can fix part of that with two simple additions.
A default next follow-up date. In the Next follow-up column, use a formula that sets it three days after the last contact when nobody has filled it:
=IF(F2="","",F2+3)
A colour for overdue deals. Select the data rows, open Format, then Conditional formatting, choose "Custom formula is" and use:
=AND($G2<>"",$G2<=TODAY(),$D2<>"Won",$D2<>"Lost")
Here D is Stage, F is Last contact and G is Next follow-up. Every open deal whose follow-up date has arrived now turns a colour. Sort or filter by that column each morning and you have a rough "who to call today" list.
Want the follow-ups to happen without you?
The Plumemark Client System is a ready-made Google Sheets CRM that sends follow-ups for you and emails you a daily list of who to talk to.
See the Google Sheets CRM →The one thing a spreadsheet will never do
A colour only works if someone opens the sheet. On a busy week nobody does, and that is exactly the week a buyer who asked for your prices goes to someone who replied first. A sheet can show you who is overdue. It cannot send the follow-up, notice that the client replied and stop chasing, or tell you in the morning who matters today.
That is the real gap between a Google Sheets CRM template and CRM software, and it is why most teams think they need a paid CRM. Often they don't. What they need is the remembering done for them. Google Sheets can do that when it is connected to Gmail with a small script that sends the follow-up, checks for replies and sends a morning summary. Building that yourself takes some trial and error with Apps Script; the alternative is a template where it is already built and tested.
Google Sheets CRM vs CRM software
- A plain Google Sheets template works for one or two people with a few dozen open deals, if someone checks it every day.
- A Google Sheets CRM with automatic follow-ups works for a hands-on team selling to other businesses who want follow-up to stop depending on memory, without a monthly bill.
- CRM software earns its cost when several people sell at once, leads arrive from many channels, or you need reporting the sheet can't give. Compare the options in best CRM for B2B service businesses.
Across 50+ CRMs audited, built and cleaned up since 2022, the pattern is the same: the tool rarely fails first. The follow-up does. Whatever you choose, give every open deal a next date and something that makes sure it happens.
For the column-by-column version for sales teams, see the sales tracking template for B2B teams, and for what to say when you follow up, how to follow up on a quotation.