Short answer: A Google Sheets CRM is a shared spreadsheet with one row per lead and fixed columns for source, owner, stage, next step and next-step date. With dropdowns and colour rules, it suits a small team. It starts to break when leads arrive faster than anyone can type them in, or when follow-ups depend on someone remembering to open the file.
Plenty of small teams run their sales from a Google Sheets CRM, and there’s nothing wrong with that. It’s free, everyone already knows how to use it, and you can set it up before lunch. This guide gives you a template you can build in about half an hour, the settings that keep it tidy, and an honest list of where it stops being enough. If you already feel the sheet slipping, our guide to switching from a spreadsheet to a CRM covers the move itself.
What is a Google Sheets CRM?
It’s a spreadsheet that does the core job of a CRM: it lists every potential customer, shows who is handling them, and records what happens next.
A real CRM adds automation, permissions and history on top of that. A sheet gives you the list and leaves the discipline to you. For a team of two or three with a steady trickle of leads, that trade is often fine. The sheet is only as good as the habits around it, so most of this guide is about building habits into the structure.
The free Google Sheets CRM template: columns that matter
Keep it to one tab called Leads with one row per lead. Resist adding twenty columns on day one. Every extra column is one more thing people skip. These are the ones worth having:
| Column | What goes in it | Why it matters |
|---|---|---|
| Date added | The day the lead arrived | Shows how long a lead has been waiting |
| Name | Person’s name | Who you’re talking to |
| Company | Business name, if any | Groups people from the same buyer |
| Phone / Email | How to reach them | Saves digging through inboxes |
| Source | Dropdown: website form, Facebook form, referral, call, other | Tells you which channels bring real leads |
| Owner | Dropdown of team members | One name per lead, never “everyone” |
| Stage | Dropdown: New, Contacted, Qualified, Proposal, Won, Lost | Where the lead stands right now |
| Next step | A short action, like “Send quote” | Turns a name into a task |
| Next step date | A real date | The column that prevents forgotten leads |
| Notes | Latest useful detail | Context for whoever picks it up |
| Lost reason | Dropdown, filled only when Lost | Shows patterns over time |
If you take only one idea from this table, take the last two working columns: Next step and Next step date. A lead with no dated next step is a lead nobody is going to call.
How to set up the sheet in about 30 minutes
Build it in this order. Each step takes a few minutes and makes the sheet harder to mess up.
- Create the header row and freeze it. Type the column names in row 1, then freeze that row so the headings stay visible as the list grows.
- Add dropdowns for Source, Owner, Stage and Lost reason. Use data validation so people pick from a list instead of typing “Facebok” or “Ali K.” Google’s help page on creating an in-cell dropdown list walks through it. Set invalid entries to be rejected, not just warned.
- Format the date columns as dates. Data validation can require a valid date in Next step date, which matters later when you sort and filter.
- Add colour rules. With conditional formatting, turn a row red when Next step date is before today and the stage isn’t Won or Lost, and amber when it’s today. This is the closest a sheet gets to a reminder.
- Create a filter view per person. A filter view lets each owner see only their own open leads without changing what everyone else sees. Google covers this under sort and filter your data.
- Protect the header row and dropdown lists. Protected ranges stop someone from deleting a column or editing the list of stages by accident.
- Share it with edit access only for the people who work leads. Everyone else gets view access, or nothing. Google’s guide to sharing files from Drive explains the options.
Optional extras: a second tab called Summary that counts leads by stage and source with COUNTIF, and a hidden Lists tab that holds the dropdown values so they’re easy to update in one place.
Google help pages last checked 23 October 2026.
Daily habits that keep a spreadsheet CRM honest
The structure helps, but the routine is what makes a Google Sheets CRM work. Three habits cover most of it:
- Enter leads the same day. A lead that sits in an inbox overnight has already cooled. Our piece on how fast to reply to new leads explains why the first hours count.
- Sort by Next step date every morning. Each owner opens their filter view, sorts by date, and works the red rows first.
- Never leave a row without a next step. After every call or message, update the stage, write the next action and set the date. If there’s genuinely nothing next, mark it Won or Lost.
A weekly ten-minute review helps too. Scan for leads with no owner, stages that haven’t moved in weeks, and Lost rows with no reason. Those three checks catch most of the drift.
Where a Google Sheets CRM starts to break
A sheet works until the volume or the team outgrows the habits. These are the usual signs, and when you see two or three of them together it’s time to look at a proper tool.
Leads have to be typed in by hand
Every lead from a Facebook lead form or a website form needs someone to copy it into the sheet. You can wire up connectors, but each one is another thing to maintain. Until someone copies the lead in, nobody in the sheet knows it exists.
Reminders depend on someone opening the file
Colour rules only work when someone is looking. A sheet doesn’t assign a task to a person or put it on a board they check anyway. If the owner is busy for two days, their red rows just stay red.
Everyone can see and edit everything
Sharing works on the whole file. You can protect ranges, but you can’t easily give a junior rep only their own leads while a manager sees all of them. One accidental sort on a single column can scramble rows for everyone.
History disappears into overwrites
When someone changes the stage from Proposal to Lost, the old value is gone unless you dig through version history. You lose the story of how a deal moved, which is the part you need when you look back.
Follow-ups live somewhere else
The sheet says “Send quote on Thursday,” but the actual work happens in email, chat and someone’s notebook. The lead and the task drift apart, and that gap is where deals get lost. We go deeper on that in our guide to a CRM with task management.
Google Sheets CRM vs a dedicated CRM
| Need | Google Sheets CRM | Dedicated CRM |
|---|---|---|
| Cost to start | Free with a Google account | Varies; some offer free plans or modules |
| Setup time | Under an hour | An afternoon for a small team |
| Lead capture from forms | Manual copy or add-on connectors | Usually built in |
| Follow-up reminders | Colour rules you have to look at | Tasks assigned to a person |
| Who sees what | File-level sharing, protected ranges | Roles and per-user access |
| Change history | Version history for the whole file | Activity per lead |
| Flexibility | Anything you can build in a grid | What the tool supports, plus integrations |
The honest summary: a sheet wins on cost and flexibility, and a CRM wins on capture, reminders and access control. If your team is small and your lead flow is slow, stay on the sheet and run it well. If leads arrive from several channels and more than a couple of people chase them, the manual work starts costing you deals.
Moving from the sheet without losing anything
If you do switch, the template above makes it easier. Clean columns with dropdown values map neatly onto CRM fields. Before you export, remove duplicates, fill in missing owners and sources where you know them, and archive leads that went cold long ago. Import the active rows, then keep the old sheet read-only for reference. If you were also weighing other no-code tools, our Notion CRM alternative post covers a similar decision.
Where EloSync fits
I build EloSync, so here’s how it lines up with the gaps above. EloSync is a modular CRM, and its Leads, Tasks and ToDos modules are free. Leads arrive from Meta Lead Ads (Facebook lead forms), through a webhook from your website forms, or by manual entry, so nobody has to copy rows across. Follow-ups become tasks on a Kanban board, ToDos hold each person’s own reminders, and roles decide who sees which leads. Marketplace add-ons extend it when you need more, and the REST API and webhooks connect it to the tools you already use. You can see how EloSync works and start with the free modules.
FAQ
Can I use Google Sheets as a CRM?
Yes. With one row per lead, dropdowns for source, owner and stage, and a dated next step on every row, a sheet handles the basics for a small team. It needs daily discipline, because nothing in it reminds people on its own.
Is there a free Google Sheets CRM template?
You can build one in about half an hour using the columns in this guide: date added, name, company, contact details, source, owner, stage, next step, next step date, notes and lost reason. Add dropdowns, colour rules and a filter view per person.
How many leads can a Google Sheets CRM handle?
The file itself can hold a lot of rows. The real limit is people: once leads come from several channels and more than a few people work them, manual entry and missed follow-ups become the problem long before the sheet runs out of space.
What’s the biggest weakness of a spreadsheet CRM?
Follow-ups rely on someone opening the file. There are no assigned tasks, and access control works on the whole file rather than per lead. Leads that arrive by form also need copying in by hand.
When should I move from Google Sheets to a CRM?
Move when leads regularly sit unentered, red overdue rows pile up, or you need different people to see different leads. If two or three of those happen most weeks, a CRM will save more time than it costs to set up.
