How to Use Google Sheets as a CRM (Free Template Setup)

CRM software can cost hundreds of dollars a month — which is a hard sell when you're a freelancer or small business owner who just needs to track leads, remember follow-ups, and know which deals are actually moving forward. Here's the good news: Google Sheets can do everything you need a basic CRM to do, and it's completely free. In this guide, you'll learn exactly how to build a functional Google Sheets CRM from scratch, with the right columns, formulas, and color-coding to actually make it useful.

Why Google Sheets Works as a CRM

Google Sheets gives you full flexibility to design your pipeline exactly the way your sales process works — no locked templates, no "upgrade to see this feature" walls. It's shareable, it's accessible from anywhere, and it connects to dozens of other tools through Zapier, Make, or even Google Apps Script if you ever want to automate things down the road. For a solo freelancer or small team, it's genuinely all you need.

Step-by-Step: Building Your Google Sheets CRM

1. Open a new Google Sheet and name it your CRM. Go to sheets.google.com and create a new blank spreadsheet. Name it something clear like "Client CRM 2026" — you'll be opening this regularly, so naming it well matters. Rename the first sheet tab "Pipeline" and create a second tab called "Archived Clients" for contacts you've closed out.

2. Set up your core columns. In row 1, create the following column headers: Contact Name, Company, Email, Phone, Lead Source, Deal Stage, Deal Value, Last Contacted, Next Follow-Up, Notes. Freeze row 1 so your headers stay visible as you scroll (View → Freeze → 1 row). These ten columns cover 90% of what a basic CRM needs to track.

3. Define your Deal Stages and add data validation. Click on the "Deal Stage" column header, then select all cells below it. Go to Data → Data validation and create a dropdown list with your stages: New Lead, Contacted, Proposal Sent, Negotiating, Won, Lost. This keeps your data consistent and makes filtering by stage clean and easy later.

4. Add conditional formatting to color-code by status. Select your Deal Stage column. Go to Format → Conditional formatting and assign colors to each stage — for example, green for "Won," red for "Lost," yellow for "Proposal Sent," and blue for "New Lead." This gives you an at-a-glance view of where every deal is sitting without reading a single cell.

5. Create a "Days Since Last Contact" formula. In a new column (say, column K), add the header "Days Since Contact" and enter this formula: =IF(H2="","",TODAY()-H2). This calculates how many days have passed since you last reached out to each contact. Format this column with a red highlight rule for values over 14 so overdue follow-ups jump out at you.

6. Set up a Follow-Up Reminder column with formula highlighting. Your "Next Follow-Up" column (column I) should contain dates. Add a conditional formatting rule to this column: highlight in orange if the date is today or earlier using the rule =$I2<=TODAY(). This creates a simple visual queue of who you need to contact right now — no separate reminder app needed.

7. Add a Revenue Summary section. Below your data or on a separate "Summary" tab, use =SUMIF formulas to track your pipeline by stage. For example: =SUMIF(F:F,"Won",G:G) gives you total revenue from won deals, and =SUMIF(F:F,"Proposal Sent",G:G) shows the value of deals currently in your pipeline. These numbers are genuinely motivating to look at — or informative when they're lower than expected.

8. Filter and sort regularly to keep it clean. Enable filters (Data → Create a filter) so you can quickly sort by follow-up date, deal stage, or deal value. A CRM is only useful if you maintain it — so block 15 minutes every Friday to update deal stages, log new contacts, and clear out leads that have gone cold.

Pro Tips for Your Google Sheets CRM

• Log every touchpoint in the Notes column. Include the date, what you discussed, and what the next step is. Future-you will be grateful when you're jumping back into a conversation two weeks later.
• Create a separate tab for won deals to track revenue by month. A =SUMPRODUCT formula combining your Won deals and their close dates gives you a rolling monthly revenue view without any extra apps.
• Share it with yourself via Google Drive and bookmark it. The biggest CRM failure is not opening it. Make it the easiest tab to click in your browser.

The Faster Way to Get Started

Building this from scratch is totally doable — but it takes a few hours to get right, especially the formulas and conditional formatting. The Freelancer Starter Pack includes a pre-built Google Sheets CRM with all the columns, formulas, and color-coding already set up, plus templates for invoicing, proposals, and client tracking. For $22, you get a complete freelance business system ready to use today.

---

Can Google Sheets be used as a CRM?

Absolutely. Google Sheets can function as a surprisingly powerful CRM for freelancers and small businesses — especially if you just need to track leads, manage follow-ups, and monitor deal progress. It's free, flexible, and shareable. The main limitation compared to dedicated CRM tools is that automation (like auto-sending follow-up emails) requires extra setup, but for basic pipeline management it works great.

What columns should a Google Sheets CRM have?

A solid Google Sheets CRM should include: Contact Name, Company, Email, Lead Source, Deal Stage (as a dropdown), Deal Value, Last Contacted (date), Next Follow-Up (date), and Notes. Optional additions include a "Days Since Contact" formula column and a conditional formatting rule that highlights overdue follow-ups. Start simple — you can always add more columns as your process evolves.

Is Google Sheets good enough for a small business CRM?

For most freelancers and small businesses with under 200 active contacts, Google Sheets is genuinely good enough. It handles filtering, sorting, formulas, and color-coding well, and it's accessible from any device. If you need features like automated email sequences, pipeline forecasting, or team-level permissions, you'll eventually outgrow it — but for getting started and staying organized, it beats overpaying for software you'll use at 10% of its capacity.