Can you run a CRM in Google Sheets?
Yes, for small teams a spreadsheet CRM tracks leads, deal stage, owner, next action, and notes in one shared file. Tabs separate Pipeline, Contacts, and Activity log. It works when volume is modest and everyone agrees the sheet is the system of record.
When to use it
Use a Sheets CRM for early-stage sales, solo founders, or a department pilot before buying dedicated software. Pair dropdown stages, conditional formatting, and filters for a usable pipeline view.
When to skip it
Skip Sheets as CRM when you need email sync, call logging, permissions per field, or thousands of contacts with automation rules. Graduate to a real CRM or add Apps Script carefully.
How it works
-
1
Define one Contacts tab with unique Email or Company ID and standard columns (name, owner, source).
-
2
{"Add a Pipeline tab with deal rows": "amount, stage dropdown, close date, and probability if you forecast."}
-
3
Log calls and emails on an Activity tab with date, type, and link back to contact ID.
-
4
Use data validation for stages, conditional formatting for overdue follow-ups, and filter views per rep.
-
5
Build a simple dashboard tab with COUNTIF and SUMIF by stage for weekly reviews.
-
6
Set protect rules on formula columns and train the team to never sort one column alone.
Examples in Google Sheets
Founder pipeline
Twenty active deals in stages Lead, Qualified, Proposal, Won, Lost. Filter views per founder with color cues for stale rows.
Inbound lead queue
Form submits append to Leads tab; QUERY shows unassigned rows sorted by created date for round-robin assignment.
Partner referral tracker
Partner column plus commission fields and a monthly SUMIF payout tab exported to PDF for finance.
Better Sheets resources
Common mistakes
-
Duplicate contacts because there is no unique key or dedupe step after imports.
-
Letting reps edit stage names in dropdowns differently, breaking dashboard COUNTIF ranges.
-
Storing entire email threads in one cell instead of summarizing next action on Activity tab.
-
No backup or version history discipline before bulk imports from events.
-
Sharing edit access with contractors without protect ranges on commission formulas.
Frequently asked questions
- Sheets CRM vs Salesforce?
- Sheets is flexible and cheap. Salesforce adds automation, email integration, and enterprise permissions.
- Link forms to CRM sheet?
- Google Forms responses land in a tab you transform into Contacts with ARRAYFORMULA or manual review.
- Track email in Sheets?
- Native email sync is limited. Log outcomes manually or use Gmail add-ons and Apps Script with care.
- Pipeline chart from sheet?
- COUNT rows by stage in a summary table, then chart stages as bar or funnel.
- Assign leads automatically?
- Small teams rotate with QUERY plus manual owner pick. Script can assign by round-robin at scale.
- Mobile CRM in Sheets?
- Google Sheets mobile app works for quick updates. Heavy data entry is still easier on desktop.
- Import CSV contacts?
- Import to Staging, normalize emails, dedupe, then append only new keys to Contacts.
- When to outgrow Sheets?
- When reps fight over edits, data quality slips, or managers need reliable activity timelines without manual logging.
Related Tutorials
Watch how CRM in Google Sheets works
Make a Quick Pipeline (For Sales and More)
Related terms
trackers
A tracker is a living list you update over time: tasks, leads, inventory, habits, or bugs. Good trackers use one row per item, clear statuses, and columns that sort and filter without cleanup scripts. They often feed a dashboard tab when the team outgrows scanning raw rows.
Read guide →dropdowns / data validation
Data validation restricts what people can type in a cell. A dropdown is the friendly face of that feature: pick from a list instead of free text. It keeps statuses, categories, and owners consistent so filters, pivot tables, and scripts do not break on typos.
Read guide →dashboards
A dashboard is a single view that answers "how are we doing?" without hunting across tabs. In Google Sheets, it is usually a summary tab with big numbers, charts, and conditional formatting fed by QUERY, pivot tables, or IMPORTRANGE from raw data you keep elsewhere.
Read guide →Google Sheets workflows
A workflow is the path work takes through your sheet: intake, review, approval, done. Good workflows use consistent columns, statuses everyone understands, and just enough automation to move tasks forward without hiding steps from the team.
Read guide →Done reading about CRM in Google Sheets?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.