Free Simple CRM in Google Sheets: 7 Easy Steps + Template

A simple CRM in Google Sheets gives you one organized place for every lead and customer — without paying for software you don’t need yet. If your client and lead information is currently scattered across WhatsApp chats, email threads, sticky notes, and memory, a single well-structured spreadsheet fixes that in about 15 minutes.This guide shows you exactly how to build a simple CRM in Google Sheets step by step: the seven columns that matter, how to add dropdowns and automatic color-coding, and a weekly routine that keeps it useful. There’s also a free downloadable template at the end so you can skip the setup entirely.

What a Simple CRM in Google Sheets Actually Is

A CRM (customer relationship management system) sounds like expensive software, but at its core it only needs to answer three questions for every contact:

• Who are they? — name and how to reach them
• Where are they? — what stage they’re at (new lead, in conversation, won, lost)
• What happens next? — the next follow-up date and any notes

A spreadsheet answers all three comfortably for most small businesses and solo operators. If you only need to track leads before they become customers, the lead tracking system guide covers a lighter version of the same idea — this article builds the fuller CRM on top of that foundation.

The 7 Columns Your Simple CRM Needs

You can add more columns later, but these seven cover everything a small business needs on day one:

Column	What it tracks	Example
Name	Person or company	Sarah Miller
Contact Info	Email or phone	[email protected]
Source	Where they came from	Referral
Status	Stage of the relationship	Contacted
Last Contacted	Date of last interaction	12 Aug 2026
Next Follow-up	When to reach out again	19 Aug 2026
Notes	Anything worth remembering	Waiting on quote approval

The Source column quietly becomes the most valuable one over time — after a few months, it shows exactly which channel brings in your best customers.

How to Build a Simple CRM in Google Sheets: 7 Steps

Step 1: Create the Sheet

Open Google Sheets (free with any Google account) and create a blank spreadsheet. Name it something boring and practical — “CRM 2026” works. Boring is good here; it means you’ll actually use it.

Step 2: Add the Seven Headers

In row 1, type the seven column names from the table above. Make the header row bold and give it a light background fill so it’s visually separate from the data. Freeze the row (View → Freeze → 1 row) so headers stay visible while you scroll.

Step 3: Add a Status Dropdown

Select the Status column, then go to Data → Data validation → Add rule → Dropdown, and add these five options:

• New — hasn’t been contacted yet
• Contacted — you’ve reached out, waiting on a reply
• Qualified — genuinely interested and a realistic fit
• Won — became a customer
• Lost — didn’t move forward

A dropdown matters more than it sounds: it keeps statuses consistent, which makes sorting and filtering reliable later. Typing “interested” one week and “qualified” the next breaks your own system.

Step 4: Set Up the Two Date Columns

Last Contacted and Next Follow-up are what turn your sheet from a contact list into a CRM. Update Last Contacted every time you interact with someone, and always set a Next Follow-up date for anything still marked New, Contacted, or Qualified.A simple rule: if a row is active, it must have a next follow-up date. A lead without a date is a lead you’ll forget.

Step 5: Auto-Color Overdue Follow-Ups

This is the step that makes the CRM feel like software. Select the Next Follow-up column, go to Format → Conditional formatting → Custom formula, and use:

AND($F2<TODAY(), $D2<>"Won", $D2<>"Lost")

(Adjust the letters if your columns sit in different positions.) Every overdue follow-up now highlights itself in red — you’ll never lose a lead to forgetfulness again.

Step 6: Create a Filter View for Daily Use

Instead of sorting the raw sheet (which can scramble your data), create a Filter view (Data → Create a filter view) sorted by Next Follow-up, ascending. Open this view each morning and work top to bottom — overdue items first, then what’s due today.

Step 7: Lock In a 15-Minute Weekly Review

A CRM only works if it reflects reality. Once a week:

1. Add every new contact you’ve collected anywhere else
2. Update statuses and Last Contacted dates
3. Set next follow-up dates for every active row
4. Mark anything Won or Lost

Fifteen minutes, once a week — that’s the entire maintenance cost of this system.

Free Simple CRM Template (Download)

You don’t have to build any of this from scratch. The free template below includes all seven columns, the five-status dropdown, and the automatic overdue highlighting — already set up and ready to use in Google Sheets or Excel.Download the Free CRM Template Make your own copy first (File → Make a copy in Google Sheets, or just download it), then start adding your contacts.

When a Spreadsheet CRM Stops Being Enough

A spreadsheet handles a surprising amount, but a few signals usually mean it’s time to look at dedicated software:

• More than one person needs to update the CRM at the same time
• You want automatic follow-up reminders by email instead of manual checks
• Lead volume has grown so large that manual updates feel unmanageable
• You need reporting a spreadsheet can’t easily produce

When that point comes, you don’t need to jump to expensive enterprise tools — several genuinely usable free CRM options for small businesses exist, and this spreadsheet history makes switching much easier because your data is already structured.

FAQs

Can Google Sheets really work as a CRM?

Yes — for solo operators and small teams with a manageable number of contacts, a simple CRM in Google Sheets covers contact management, status tracking, and follow-up reminders without any cost. Its limits appear with team collaboration and automation, not with basic tracking.

What’s the difference between a CRM and a lead tracker?

A lead tracker focuses on potential customers before they buy. A CRM covers the full relationship — including won customers, repeat business, and ongoing communication. A lead tracker is essentially the lighter version; this article builds the fuller system.

How many contacts can a spreadsheet CRM handle?

There’s no hard limit — Sheets handles thousands of rows comfortably. The practical limit is human: if updating rows manually stops feeling manageable, or multiple people need simultaneous access, that’s the signal to move to dedicated software.

Is the free template really free to use?

Yes. Download it, make your own copy, customize the columns and statuses however you like. No sign-up, no catch.

Conclusion

A simple CRM in Google Sheets isn’t a compromise — for most small businesses, it’s the right tool at the right stage. Seven columns, five statuses, one conditional formatting rule, and a 15-minute weekly review: that’s a complete customer management system for the price of nothing. Start with the free template above, keep it honest week after week, and upgrade only when your business genuinely outgrows it.

Related Guides

• How to Set Up a Lead Tracking System for a Small Business — the lighter leads-only version of this system.
• Best Free CRM for Small Business (2026 Guide) — when you’re ready to graduate from spreadsheets.