Friday afternoon. Someone fills in your contact form, asks about pricing, and seems ready to move. You copy their details into your spreadsheet, tell yourself you will follow up Monday, and close the tab. Tuesday arrives. The lead has gone cold. You scroll the sheet trying to remember where you left off, and you find three other enquiries underneath it that also never got a third message. This is not a discipline problem. This is a google sheets crm problem, and it starts with how the sheet was built.
A spreadsheet can do a credible job as a contact management system when it is set up deliberately. Most are not. They grow column by column, person by person, until the data is too inconsistent to filter and too long to scan. This guide covers how to build a Sheets CRM that holds together, and then gives you the five failure signs that mean it is time to stop patching it and move on.
What should a Google Sheets CRM actually contain?
A working Google Sheets CRM needs eight columns at minimum: full name, company or trading name, lead source, preferred contact method, current pipeline stage, date of last contact, date of next follow-up, and a notes field. That is the whole core. Everything else is optional until you have a reason to add it.
The columns most people skip are the ones that matter most for sales follow-up. "Date of last contact" and "date of next follow-up" are not the same thing, and treating them as the same thing is how leads disappear. Last contact tells you what happened. Next follow-up tells you what to do and when. Without both, your sheet is a record of the past with no instruction about the future.
Keep the notes column human and specific: "Called Tuesday, went to voicemail, will try again Friday morning" is useful; "left message" is not.
Lead qualification notes belong here too. Not a score, just the key facts: budget mentioned, timeline given, competitor named. When you come back to a contact three weeks later, those notes are the difference between a warm continuation and an awkward restart.
Building the sheet: column order and tab structure
Put the action columns, stage and next follow-up date, near the left where they are visible without scrolling. Contacts that need action today should be easy to find. A useful structure is: Name, Stage, Next Follow-Up, Last Contact, Source, Notes, and then any secondary fields to the right. Sort by "Next Follow-Up" ascending as your default view, and the top of the sheet always tells you what to do first.
Use two tabs. The first is your active pipeline, everyone who is still in play. The second is an archive for closed deals, lost leads and contacts you have decided not to pursue. Moving a row to the archive instead of deleting it keeps your history intact without cluttering your working view.
How do you use data validation to stop the sheet from breaking?
Data validation dropdowns on the Stage and Source columns are non-negotiable. Without them, the same pipeline stage gets entered as "Proposal sent", "proposal sent", "Prop Sent", and "Sent Proposal" by different people, or by the same person on different days. None of those four values group correctly when you filter or count.
To add a dropdown in Google Sheets: click the column header to select the whole column, go to Data, then Data validation, choose "List of items", and type your values separated by commas. For pipeline stages, a clean set might be: New, Contacted, Proposal Sent, Negotiating, Won, Lost. For lead source: Website, Referral, Facebook, LinkedIn, Cold Outreach, Other.
Once validation is in, set it to reject invalid data rather than just show a warning, otherwise people type past the warning and the inconsistency returns.
Do the same for the "Preferred contact method" column: Email, Phone, WhatsApp. Three options, no freeform text. Simple columns with controlled values are the foundation of lead tracking that you can actually filter and report on.
Conditional formatting for overdue follow-ups
Go to Format, then Conditional formatting. Apply it to the "Next Follow-Up" column. Set the rule: if the cell value is less than or equal to today's date, fill the cell red. This gives you a visual triage at a glance. Red cells need action today or are already overdue. Everything else can wait.
This is the closest a Sheets CRM gets to follow-up reminders, and it is worth noting how limited it is. It does nothing unless you open the sheet. It does not send you a notification at 9am. It does not email you a summary of what needs doing. It turns a cell red and waits for you to notice. That is a meaningful distinction, and we will come back to it.
How do you build a view that shows only your hot leads?
Filter views in Google Sheets let you save named filters without changing what other users see. Click Data, then Filter views, then Create new filter view. Set the Stage column to show only "Proposal Sent" and "Negotiating", sort by "Next Follow-Up" ascending, and save the view as "Hot Leads". Now you have a one-click view that shows only the leads close to a decision, sorted by urgency.
Create a second filter view for leads in the "New" stage sorted by the date they were entered. This is your lead response time view. Research from XANT (formerly InsideSales) found that the odds of reaching a lead drop significantly after the first hour, though it is worth noting that figure comes from a study of inside sales teams making phone calls, not all businesses equally. The principle still holds: newer enquiries need faster responses, and a sorted view makes that visible.
A filter view costs nothing and takes three minutes to set up; most Sheets CRMs never have one, which means every session starts with manually scanning the whole sheet.
A third view worth creating: "Follow-Up This Week". Filter the "Next Follow-Up" column to dates between today and seven days from now, so you can plan the week's sales follow-up in a single view on Monday morning.
What are the five signs your Google Sheets CRM has stopped working?
The signs tend to arrive quietly. No single moment where the sheet obviously breaks. Just a slow drift where the data becomes less reliable, the follow-ups become less consistent, and the feeling of being on top of your leads fades.
Sign one: leads are going cold and you find out by accident. You call someone and they tell you they went with someone else three weeks ago. You pull up their row and the last contact date is six weeks back. Nothing in the sheet told you to follow up. The conditional formatting turned a cell red, but you were not looking at the sheet that day.
Sign two: your email follow-up history lives entirely in your inbox. The sheet has a row, but the actual conversation, the questions they asked, the objections they raised, the proposal you sent, none of that is in the record. To understand a lead, you have to search your email separately. Contact management that requires two places to check is contact management that will eventually fail.
Sign three: you cannot tell a colleague what stage each lead is in without opening the sheet and narrating it to them. A sales pipeline should answer the question "where are we with everyone?" in seconds. If that question requires explanation, the pipeline is not really visible.
Sign four: lead qualification is happening in your head, not in the sheet. You know that one lead has a tight budget but a fast timeline, and another has money but is three months away from deciding. That information is not written down. When you are ill, or simply tired, that context disappears and the follow-up conversation starts from scratch.
Sign five: you have more than one person updating the sheet. Two people editing the same CRM row at different times, on different devices, without any version control is how a contact record quietly becomes fiction. One person updates the stage. Another adds a note that contradicts it. Neither knows. The next follow-up is based on whoever wrote last.
When does a small business actually need a dedicated CRM for small business?
Moving to a dedicated CRM for small business is worth doing when any one of the five signs above is a regular experience, not just an occasional bad week. The threshold is lower than most people expect. It is not about team size or revenue. It is about whether your lead nurturing process is reliable enough that you can trust it without checking it daily.
A purpose-built tool handles the things Sheets cannot: automatic follow-up reminders that reach you regardless of whether you open the app, an email log attached to each contact record, lead capture directly from a form into a pipeline stage, and audit trails when more than one person is involved. Pipedrive, for example, is a well-designed pipeline tool, but it assumes you already think in deal stages and want to track metrics. HighLevel has automation depth that most solo operators never use and a setup cost to match. The right fit depends on how simple or complex your follow-up process actually is.
The honest moment to move is not when the sheet becomes technically impossible to use. It is when the cost of maintaining the sheet, the time spent updating it, the leads lost to missing reminders, the decisions made on incomplete information, adds up to more than the cost of something better.
A sheet will never tell you that moment has arrived. That is its final limitation.
Frequently Asked Questions
Can Google Sheets work as a CRM for a small business?
Yes, for a team of one or two tracking fewer than around 200 active leads, Google Sheets can function as a CRM. It handles contact management, pipeline stages and basic lead tracking without any cost. The problems start when you need automated follow-up reminders, an email log, or more than one person updating records reliably.
What columns should a Google Sheets CRM include?
At minimum: full name, company, source, contact method, current pipeline stage, last contact date, next follow-up date, and a notes column. Data validation dropdowns on the stage and source columns prevent the inconsistent entries that make filtering useless later.
How do I add follow-up reminders in Google Sheets?
Google Sheets has no native reminder system. The closest option is a conditional formatting rule that turns the next follow-up date cell red when the date is today or in the past. You can also pair Sheets with Google Calendar via a script, but this requires setup time and breaks when the sheet structure changes.
What is the biggest weakness of a Google Sheets CRM?
There is no automatic email log. Every call, reply or meeting has to be typed into a notes cell by hand. In practice, most people stop doing this within a few weeks, which means the contact record becomes unreliable and sales follow-up decisions get made from memory rather than data.
When should a small business move from Google Sheets to a real CRM?
Move when any of these are true: leads are going cold because reminders do not exist, you cannot see at a glance which pipeline stage each lead is in, two people are editing the sheet and overwriting each other, your email follow-up history lives only in your inbox, or lead qualification notes are scattered across cells, emails and sticky notes.
How many leads can Google Sheets handle before it becomes unmanageable?
Most solo operators find the sheet starts to feel unreliable somewhere between 150 and 300 active leads. The problem is not technical row limits but human ones: manually updating pipeline stages, next follow-up dates and notes for that many contacts becomes a job in itself, and it is the first thing skipped when the day gets busy.
Is Google Sheets a CRM or just a spreadsheet?
It is a spreadsheet that you can shape into a basic CRM by adding the right columns, dropdowns and views. It lacks the core features that define a CRM: automated follow-up reminders, a linked email log, lead capture from forms, and contact management that updates itself based on activity. You build those manually, or you do without them.
Start with the sheet, but know what it cannot do
Kodeleads is built for the moment after you have read a guide like this one and realised the sheet is never going to send you a reminder. If you are ready to stop maintaining the system and start using one, try Kodeleads free and have your leads, pipeline stages and follow-up reminders in place before the next enquiry arrives.