Google Sheets works as a CRM for a solo seller or a tiny team: store contacts in rows, track a pipeline with a status dropdown, and report with formulas like COUNTIF and FILTER. It is free and flexible, but it has no automation, no reminders, and no real multi-user control, so it breaks the moment you add a second person or a few thousand rows.
Google Sheets as a CRM how to build one and where it breaks
A spreadsheet can be a real CRM for one person and a handful of deals. Here is how to set one up, the formulas that make it useful, and the exact moment it stops paying off.
Key takeaways
- A Google Sheets CRM is contacts in rows + a status dropdown + a summary tab, nothing more
- The right formulas (COUNTIF, SUMIF, FILTER, conditional formatting) turn it from a list into a pipeline
- It fits one user with a few hundred contacts; it breaks on a second editor, automation, or scale
- Vonsel Free includes 20 verified leads when you start the free plan, plus the Mapped CRM, so you skip the empty sheet
Definition
What is a Google Sheets CRM?
A Google Sheets CRM is a spreadsheet set up to do the basic job of customer relationship management: one row per contact, columns for status and next action, and a few formulas that turn the list into a pipeline you can read at a glance. It runs inside Google Sheets, so it is free, lives in the cloud, and needs zero setup.
It is a legitimate starting point, not a hack. The trap is treating it as permanent. If you are weighing it against a dedicated tool, our CRM vs Excel guide covers the same trade-off, and the Sheets version inherits most of the same limits with the bonus of easy sharing.
Build it
How to build a CRM in Google Sheets, step by step
You can have a working pipeline in under an hour. Follow these six steps in order:
1
Create the contacts sheet
One row per contact. Columns: Company, Name, Email, Phone, Source, Status, Owner, Last contact, Next action, Next action date, Value, Notes. Freeze the header row so it stays visible as you scroll.
2
Turn Status into a pipeline dropdown
Select the Status column, open Data, then Data validation, and add a dropdown with your stages: New, Contacted, Qualified, Proposal, Won, Lost. Now every row sits in a clear pipeline stage instead of free text.
3
Flag follow-ups with conditional formatting
Apply a conditional formatting rule to the Next action date column with a custom formula like =$J2<=TODAY() so any row due today or overdue turns red. This is your reminder system, since Sheets has none built in.
4
Build a summary tab with formulas
On a second tab, count deals per stage with =COUNTIF(Contacts!F:F,"Qualified"), total open value with =SUMIF, and list overdue rows with =FILTER. That tab becomes your dashboard.
5
Share and protect it
Share with edit access, then protect the header row and the formula tab so a teammate cannot overwrite them by accident. Keep the Notes column wide, context next to each deal is what makes the sheet usable later.
6
Write down your migration trigger
Decide in advance when you will leave: a second active editor, more than ~500 contacts, or follow-ups slipping. A written trigger stops the spreadsheet from quietly becoming your system of record. For a ready-made version, see our CRM Excel template guide.
The toolbox
The formulas that make a Sheets CRM useful
Five functions do most of the work. Master these and your spreadsheet behaves like a lightweight pipeline:
| Formula | What it does | Example use |
|---|---|---|
| COUNTIF | Counts rows matching a stage | Deals in "Qualified" right now |
| SUMIF | Totals a value by criteria | Open pipeline value per owner |
| FILTER | Returns rows that meet a test | List of overdue follow-ups |
| XLOOKUP / VLOOKUP | Pulls a field from another tab | Match a deal to its company record |
| TODAY + format | Compares dates and highlights | Flag follow-ups due this week |
If you want the official reference for each one, Google publishes a full Google Sheets function list. The reason this matters: the market for spreadsheet CRMs is enormous because, per U.S. Census Bureau business statistics, over 99% of American employer firms are small businesses, many of whom run their first pipeline in a sheet exactly like this.
99%
of U.S. employer firms are small businesses, where spreadsheet CRMs are born
~30%
of a rep's week is actually spent selling, per Salesforce research, the rest is admin a sheet makes worse
20
verified leads on Vonsel Free, with the Mapped CRM, instead of an empty spreadsheet
Skip the empty sheet. Start with real leads.
Vonsel Free gives you 20 verified leads and the Mapped CRM, the first CRM with a GPS map, so your pipeline starts full instead of as a blank spreadsheet.
Start Free Trial
Start Free Trial
Pros and cons
Google Sheets as a CRM: the honest pros and cons
| Where Sheets wins | Where Sheets hurts |
|---|---|
| Free, instant, no setup or onboarding | No automation, reminders, or follow-up sequences |
| Fully customizable columns and formulas | No audit trail of who changed what, and when |
| Everyone already knows how to use it | Two people can overwrite the same cell silently |
| Easy to share with a link | Reporting is manual and breaks as the file grows |
| Great for validating a sales process | Slows down and corrupts past a few thousand rows |
The pattern is clear: Sheets wins on cost and flexibility, and loses on everything that scales with a team. Salesforce's State of Sales research finds reps spend roughly 70% of their week on non-selling work, and a manual spreadsheet adds to that number rather than cutting it.
A Google Sheets CRM is the cheapest CRM you will ever run and the most expensive habit you can keep. Judge it the same way: does it remove work from your week, or quietly add it?
Diagnosis
When a spreadsheet is enough, and when to migrate
| A Sheets CRM is fine if... | It is time to migrate when... |
|---|---|
| You are one person with a simple pipeline | A second person needs to edit the same data |
| You manage under ~500 active contacts | The file gets slow past a few thousand rows |
| Follow-ups fit in a single dated column | Deals slip because nothing reminds you |
| A summary tab answers your questions | You copy and paste between tabs to report |
| You are validating whether you need a CRM | The sheet has quietly become your system of record |
The adoption point matters most. Harvard Business Review's sales research has documented for years that CRM efforts fail when the tool creates busywork, and a shared spreadsheet with manual upkeep is one of the fastest routes to that. For very small teams choosing their first real tool, read simple CRM for small teams and our broader guide to CRM for SMBs.
Checklist
Checklist: is your Sheets CRM still working?
Is anyone besides you editing it?
One editor is fine. Two or more, and silent overwrites become inevitable. That is the clearest single signal to migrate.
Have you missed a follow-up this month?
Conditional formatting helps, but it only works if you open the file. Real reminders live in a CRM, not a cell color.
Is the file getting slow?
Lag past a few thousand rows is the spreadsheet telling you it is out of room. Performance only gets worse from there.
Are you rebuilding reports by hand?
If your weekly numbers need manual copy and paste, you are paying in time what a CRM would automate for a few euros.
Does it match how your team sells?
Field teams need maps and routes a sheet cannot give. See mapped CRM vs traditional CRM.
Where do the rows come from?
A sheet is empty without prospects. Tools that bundle data with the CRM, like a sales route planner with built-in business data, remove the manual entry entirely.
How Vonsel helps
From an empty sheet to a Mapped CRM with leads inside
A spreadsheet CRM starts as an empty grid you have to fill by hand. Vonsel flips that: the free plan includes 20 verified leads when you start the free plan, no credit card, pulled from a base of millions of businesses across 120+ countries, with email accuracy of 85-95%. Instead of cells and formulas, you get the Mapped CRM, the first CRM that shows every prospect on a GPS map, so field teams plan visits instead of scrolling rows. It is already how teams prospect at scale: according to internal Vonsel data (2026), restaurants and dentists are the most-prospected categories on the platform, with dentists ranked #1 among paying teams. When your sheet hits its limits, paid plans start at €17.99/month, with no formula maintenance and no overwrite chaos.
In summary:
- Google Sheets is a real CRM for one person: rows for contacts, a status dropdown, and COUNTIF, SUMIF and FILTER for reporting.
- It breaks on a second editor, missing reminders, manual reports, or a few thousand rows, so set a migration trigger early.
- Vonsel Free bundles 20 verified leads with the Mapped CRM, so you start with prospects, not a blank spreadsheet.
Outgrown your spreadsheet? Start with 20 verified leads when you start the free plan.
Vonsel Free includes verified business leads and the Mapped CRM with a GPS map, no formulas to maintain and no overwrite chaos. See plans or compare a CRM against a spreadsheet.
Start Free Trial
Frequently asked questions
Can you use Google Sheets as a CRM?
Yes. Google Sheets works as a basic CRM for a solo seller or a tiny team: you store contacts in rows, track a pipeline with a status dropdown, and use formulas like COUNTIF and FILTER for simple reporting. It is free and flexible, but it has no automation, no reminders and no real multi-user control.
How do I build a CRM in Google Sheets?
Create one row per contact with columns for company, name, email, phone, status, owner and next action. Turn the status column into a dropdown with Data validation, highlight overdue follow-ups with conditional formatting, and add a summary tab with COUNTIF and SUMIF to count deals and total pipeline value.
What formulas are useful for a Google Sheets CRM?
The most useful are COUNTIF to count deals per stage, SUMIF to total pipeline value by stage or owner, FILTER to list overdue follow-ups, VLOOKUP or XLOOKUP to pull contact details across tabs, and TODAY combined with conditional formatting to flag follow-ups that are due.
Is Google Sheets a good CRM for a small business?
It is good enough for one person validating a sales process with a few hundred contacts and no team. It stops being good the moment you add a second user, need automated follow-up reminders, or want to avoid two people overwriting the same cell. At that point a real CRM saves more time than it costs.
What are the disadvantages of using Google Sheets as a CRM?
The main disadvantages are no automation or reminders, no audit trail of who changed what, easy accidental edits, weak reporting compared with a CRM, and performance that degrades past a few thousand rows. There is also no built-in way to enrich contacts or dial and email from the record.
When should I move from Google Sheets to a real CRM?
Move when you hit a structural limit: a second person needs to edit the same data, follow-ups start slipping, you copy and paste between sheets to build reports, or the file gets slow past a few thousand rows. The hours lost to manual upkeep usually exceed an entry CRM plan of €15-30 per month.
Does Vonsel replace a Google Sheets CRM?
Yes. Vonsel includes the Mapped CRM, the first CRM that shows your pipeline on a GPS map, plus 20 verified leads when you start the free plan, no credit card required. Instead of an empty spreadsheet you start with real prospects already in the pipeline. Paid plans start at €17.99 per month.