Home Setup Do it yourself Results Blog About
Free Client Leak Check Apply for the setup
Back to Articles
Nov 15, 2026 Feyisayo Daisi System Setup

Google Sheets CRM Template: How to Set One Up That Actually Follows Up

Revenue Systems Architect | Founder, Plumemark

TL;DR
  • A Google Sheets CRM needs one row per deal: client, source, request, stage, value, last contact, next follow-up and lost reason.
  • Make Stage a dropdown and write down what must be true for each stage, or the data drifts within a month.
  • A formula and conditional formatting can flag overdue follow-ups, but only if someone opens the sheet.
  • The real gap is the remembering: connect Sheets to Gmail so follow-ups send themselves, or use a template where that is built in.
Google Sheets CRM template on a laptop

Most B2B businesses start tracking clients in a spreadsheet, and that is not a mistake. A Google Sheets CRM is free, everyone already knows how to use it, and it can be set up in an hour. The trouble starts a few weeks later, when the sheet is out of date and a quote you sent three weeks ago has quietly gone cold.

This guide shows how to set up a Google Sheets CRM template that holds up: the columns to use, how to stop stages from drifting, how to make overdue follow-ups impossible to miss, and the one thing a spreadsheet will never do on its own.

The columns your Google Sheets CRM needs

Keep it to one row per deal and these columns. Anything more and nobody keeps it current.

  1. Client and contact. The company, the person and how to reach them.
  2. Source. Where the inquiry came from: referral (and from whom), WhatsApp, LinkedIn, website, an ad. Fill it the day the inquiry arrives, because nobody remembers later.
  3. What they asked for. One line, in their words.
  4. Stage. A dropdown, never free text (see below).
  5. Value. Your best estimate of the deal in money.
  6. Last contact. The date you last spoke.
  7. Next follow-up. The date you will contact them next. Every open deal must have one.
  8. Lost reason. Filled only when a deal is lost, from a short dropdown.

Stop stages from drifting

The fastest way to ruin a spreadsheet CRM is letting people type the stage. Within a month you have "quote sent", "Quote Sent", "sent quote" and "waiting". Use Data, then Data validation, to make the Stage column a dropdown with a fixed list, for example: New inquiry, In talks, Quote sent, Won, Lost.

Then write down what has to be true for a deal to enter each stage. "Quote sent" should mean the buyer has a priced quote in hand, not that you plan to send one. Our sales pipeline stages template has exit rules you can copy.

Make overdue follow-ups impossible to miss

A spreadsheet CRM fails quietly. Nothing turns red when a follow-up date passes. You can fix part of that with two simple additions.

A default next follow-up date. In the Next follow-up column, use a formula that sets it three days after the last contact when nobody has filled it:

=IF(F2="","",F2+3)

A colour for overdue deals. Select the data rows, open Format, then Conditional formatting, choose "Custom formula is" and use:

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

Here D is Stage, F is Last contact and G is Next follow-up. Every open deal whose follow-up date has arrived now turns a colour. Sort or filter by that column each morning and you have a rough "who to call today" list.

Want the follow-ups to happen without you?

The Plumemark Client System is a ready-made Google Sheets CRM that sends follow-ups for you and emails you a daily list of who to talk to.

See the Google Sheets CRM →

The one thing a spreadsheet will never do

A colour only works if someone opens the sheet. On a busy week nobody does, and that is exactly the week a buyer who asked for your prices goes to someone who replied first. A sheet can show you who is overdue. It cannot send the follow-up, notice that the client replied and stop chasing, or tell you in the morning who matters today.

That is the real gap between a Google Sheets CRM template and CRM software, and it is why most teams think they need a paid CRM. Often they don't. What they need is the remembering done for them. Google Sheets can do that when it is connected to Gmail with a small script that sends the follow-up, checks for replies and sends a morning summary. Building that yourself takes some trial and error with Apps Script; the alternative is a template where it is already built and tested.

Google Sheets CRM vs CRM software

  • A plain Google Sheets template works for one or two people with a few dozen open deals, if someone checks it every day.
  • A Google Sheets CRM with automatic follow-ups works for a hands-on team selling to other businesses who want follow-up to stop depending on memory, without a monthly bill.
  • CRM software earns its cost when several people sell at once, leads arrive from many channels, or you need reporting the sheet can't give. Compare the options in best CRM for B2B service businesses.

Across 50+ CRMs audited, built and cleaned up since 2022, the pattern is the same: the tool rarely fails first. The follow-up does. Whatever you choose, give every open deal a next date and something that makes sure it happens.

For the column-by-column version for sales teams, see the sales tracking template for B2B teams, and for what to say when you follow up, how to follow up on a quotation.

Related reading


Stop losing money to follow-ups nobody sent.

The Plumemark Client System is a ready-made Google Sheets CRM with automatic follow-ups. Pay once.

See the Google Sheets CRM →

Frequently Asked Questions

Can Google Sheets be used as a CRM?

Yes. For a hands-on team with a few dozen open deals, a Google Sheet with one row per deal, a stage dropdown and a next follow-up date works as a CRM. What it lacks on its own is reminders, which you can add by connecting it to Gmail.

What columns should a Google Sheets CRM have?

Client and contact, source, what they asked for, stage, value, last contact date, next follow-up date and lost reason. Keep it to one row per deal.

How do I get follow-up reminders from Google Sheets?

Use conditional formatting to colour deals whose follow-up date has passed, then check the sheet daily. For reminders that arrive without opening the sheet, connect it to Gmail with a script, or use a template that already does it.

Is a Google Sheets CRM free?

The sheet is free with a Google account. Ready-made templates with automatic follow-ups cost a one-off fee, which is usually far less than a monthly CRM subscription.