Back to Vault
Lead Response and Automation•November 16, 2026•7 min read

Free Sales Pipeline Template for Google Sheets (Copy-Paste Setup)

Free Sales Pipeline Template for Google Sheets (Copy-Paste Setup) — YouMaximize blog cover

Most small businesses don’t lose deals because the price was wrong. They lose them because nobody followed up on a Tuesday when they said they would. A simple pipeline sheet fixes that.

Here’s the short version: a sales pipeline template for Google Sheets needs one row per lead, about 12 columns, 6 stages in a dropdown, and a “next step date” column you check every morning. You can build it free in about 15 minutes with the copy-paste header row, stage list and formulas below. No add-ons, no paid template.

At a glance

  • Time: about 15 minutes
  • Cost: free (any Google account)
  • Difficulty: easy, no formulas needed to start
  • You’ll get: one sheet that shows every open lead, what happens next, and what’s overdue

What should a sales pipeline template in Google Sheets include?

A good pipeline sheet answers three questions at a glance: who is this lead, what stage are they at, and what is the next thing you’ll do and when. Everything else is optional. Most free templates online are built for sales teams with forecasts and win probabilities. A small business needs less, but it needs the follow-up date.

These are the 12 columns we’d use, whether you run a dental clinic, a law firm, a plumbing company, a small agency or an estate agency.

Column What goes in it Why it matters
Date added The day the enquiry arrived Shows how long leads sit before you act
Name The person’s name Obvious, but use full names to avoid duplicates
Company Their business (leave blank for consumers) Useful for agencies and B2B services
Phone / email Best way to reach them So nobody has to dig through inboxes
Source Google, referral, Instagram, website form, WhatsApp Tells you which channels actually bring paying clients
What they want One line: “implant consult”, “kitchen rewire”, “3-bed valuation” Lets you reply without re-reading the thread
Value Your best estimate of the job or deal value Shows what’s at stake in each stage
Stage A dropdown (see below) The heart of the pipeline
Next step “Call to book survey”, “Send revised quote” Stops leads stalling with no owner
Next step date When you’ll do it The column that makes you money
Last contact Date you last spoke to them Spots leads that have gone quiet
Notes Anything else worth remembering Budget, timing, objections, who else decides

How to build the pipeline sheet in 15 minutes

Open a new Google Sheet, paste the header row, add a stage dropdown and turn it into a table. That’s the whole build. Here are the steps.

Step 1: Paste the header row

Copy this into cell A1. If it lands in one cell, select column A and use Data > Split text to columns to spread it across the row.

Header row · Paste into A1

Date added,Name,Company,Phone / email,Source,What they want,Value,Stage,Next step,Next step date,Last contact,Notes

Step 2: Add the stage dropdown

Select column H (Stage), then go to Insert > Dropdown and add each stage as an option. Google’s help page shows the same path, plus Data > Data validation as an alternative (Google Docs Editors Help). By default, Sheets rejects anything that isn’t on the list, which keeps your stages tidy.

Use these six stages. Fewer is better: if you can’t explain the difference between two stages in one sentence, merge them.

Stage list · One per dropdown option

New enquiry
Contacted
Qualified
Quote sent
Won
Lost

Stage Means Example (home-services company)
New enquiry Arrived, not yet answered Form filled in for a boiler service
Contacted You’ve replied, waiting on them Sent a WhatsApp asking for the address
Qualified Real need, right area, budget fits Booked a site visit
Quote sent Price in their hands Quote emailed after the visit
Won Booked or signed Deposit paid
Lost Said no, or went silent after your last follow-up Chose a cheaper firm

Step 3: Convert it to a table

Select your data and go to Format > Convert to table. Google Sheets tables let you set a type for each column (date, number, dropdown, checkbox and more) and flag cells that don’t match. You can also create a group by view from the Views menu to see leads grouped by stage, with totals for each group (Google Docs Editors Help). That group-by view is the closest thing to a CRM board you’ll get in a spreadsheet, and it’s free.

Shortcut: Set “Date added”, “Next step date” and “Last contact” as date columns. You get a date picker, and sorting by next step date suddenly becomes your to-do list.

Step 4: Highlight overdue follow-ups

Go to Format > Conditional formatting, choose “Custom formula is” and paste this, with a red fill. Any lead whose next step date has passed turns red.

Conditional formatting · Overdue rows

=AND($J2<>””,$J2<TODAY(),$H2<>”Won”,$H2<>”Lost”)

Optional: four formulas for a mini dashboard

You don’t need these to start. Once you have 20 or more leads in the sheet, add a second tab called “Summary” and paste these in. They assume the column order from the header row above and a first tab named “Pipeline”.

Formula · Value of open deals

=SUMIFS(Pipeline!G:G,Pipeline!H:H,”<>Won”,Pipeline!H:H,”<>Lost”,Pipeline!H:H,”<>”)

Formula · Leads in one stage

=COUNTIF(Pipeline!H:H,”Quote sent”)

Formula · Overdue follow-ups

=COUNTIFS(Pipeline!J:J,”<“&TODAY(),Pipeline!H:H,”<>Won”,Pipeline!H:H,”<>Lost”)

Formula · Win rate

=IFERROR(COUNTIF(Pipeline!H:H,”Won”)/(COUNTIF(Pipeline!H:H,”Won”)+COUNTIF(Pipeline!H:H,”Lost”)),0)

Format the win rate cell as a percentage. If overdue follow-ups is above zero, that’s your first job of the day.

How to use the sheet every day (the 10-minute routine)

A pipeline sheet only works if you open it daily. The routine below takes about ten minutes and is the same whether you’re a solo solicitor or a five-person agency.

  1. Add every new enquiry as a row, the same day
  2. Sort by next step date
  3. Do everything dated today or earlier
  4. Update stage, last contact and the next step date
  5. Never leave a row without a next step date

That last rule matters most. A lead with no next step date is a lead you’ve quietly decided to forget. If you’ve done all you can, move it to “Lost” and note why.

For what to actually say at each step, our automated lead follow-up guide has message templates, and how to follow up on a quote covers the “Quote sent” stage, where most small businesses go quiet.

What most guides leave out

Most sales pipeline templates you’ll find are built by CRM companies or template sellers, and they’re designed around forecasts, win probabilities and sales reps. Useful for a sales team. Overkill for a clinic or a local contractor. Here’s what they tend to miss:

  • The next step date. Many templates track an “expected close date” but no follow-up date. Close dates are guesses. Follow-up dates are actions.
  • Lead source. Without it you can’t tell whether Google, referrals or Instagram bring in paying clients, so you keep spending on all three.
  • Time to first reply. The gap between “Date added” and your first contact is often where deals are won or lost. Our speed to lead guide explains why the first reply matters so much.
  • A “Lost” stage with a reason. Writing “too expensive” or “went quiet” ten times in a row tells you something no dashboard will.

Watch out: A sheet is only as good as the habit behind it. If enquiries arrive on WhatsApp, Instagram, email and phone and you have to copy each one in by hand, some will slip. That’s the point to automate the capture, or move to a CRM.

When should you move from Google Sheets to a CRM?

Stay on a sheet while one or two people handle leads and you can keep it updated in ten minutes a day. Move to a CRM when two people start contacting the same lead, when you’re handling enough enquiries that rows get missed, or when you want automatic reminders and messages rather than checking a sheet. Even CRM vendor Close, which has an obvious interest, suggests upgrading once you outgrow one or two salespeople or start losing deal information (Close).

Our pick: Start with the sheet. It costs nothing, and the habit it builds (every lead has a stage and a next step) carries straight over to any CRM you use later.

FAQ

Is there a free sales pipeline template for Google Sheets?

Yes. You can build one free in about 15 minutes using the header row, stage list and formulas in this guide. Several sites also offer downloadable templates, but most are built for sales teams and include columns a small business won’t use.

How many stages should a sales pipeline have?

For most small businesses, five to seven. We use six: new enquiry, contacted, qualified, quote sent, won and lost. If two stages always move together, merge them.

Can Google Sheets work as a CRM?

For a small business with one or two people handling leads, yes. With dropdown stages, date columns and a group-by view, it covers the basics. It won’t send reminders or log emails automatically, which is when a proper CRM earns its cost.

How do I see my pipeline by stage in Google Sheets?

Convert your data to a table with Format > Convert to table, then create a group by view from the Views menu and group by the Stage column. You can add totals, such as the sum of deal value for each stage.

What’s the most important column in a pipeline sheet?

The next step date. Sort by it every morning and do everything that’s due. A lead without one is usually a lead that’s about to go cold.

Sources: Google Sheets dropdown steps from Google Docs Editors Help: Create an in-cell dropdown list; table, column type and group-by view features from Google Docs Editors Help: Use tables in Google Sheets; CRM upgrade advice from Close. Menu names checked November 2026 and may change. Last updated: November 2026.

Leads slipping between the sheet and the inbox? We’ll look at how your enquiries arrive and how fast they get answered, and show you where the gaps are.

Book a free 15-minute lead-response review →