The Only Google Sheets Sales Pipeline Template You Need
It's Monday morning. Your VP asks for a pipeline number. You open the spreadsheet, stare at 47 rows of stale data, and realize half the contacts don't even work at those companies anymore. The forecast you send is fiction - and everyone in the room knows it.
Here's a free, copyable Google Sheets sales pipeline template - no email gate, no "talk to sales" wall. Every CRM vendor publishes a "free template" designed to make spreadsheets look bad so you'll buy their product. This one's designed to actually work.
What's in the Template
- 14 columns covering the fields you'll actually use
- 5 pipeline stages with default win probabilities
- 6 copy-paste formulas for pipeline value, revenue won, deals won, win rate, average deal size, and weighted forecast
- A dashboard tab with 4 KPI tiles and a combo chart
Copy the template here. Total setup time: about 20 minutes if you customize stages and dropdowns. Less if you use the defaults.
The 14 Columns Your Pipeline Needs
Every column earns its spot. If it doesn't drive a formula or a decision, it's clutter.
| Column | What It Tracks | Why It Matters |
|---|---|---|
| Deal ID | Unique identifier | Prevents duplicates |
| Date Created | When deal entered pipeline | Measures velocity |
| Contact Name | Primary buyer contact | Ownership clarity |
| Verified work email | Outreach + follow-up | |
| Company | Account name | Reporting by account |
| Deal Source | Inbound, outbound, referral | Channel attribution |
| Deal Value | Expected revenue ($) | Forecasting input |
| Win Probability (%) | Likelihood to close | Weighted forecast |
| Sales Rep | Deal owner | Rep performance |
| Stage | Current pipeline stage | Pipeline distribution |
| Status | Open / Won / Lost | Win rate calculation |
| Expected Close Date | Target close date | Forecast timing |
| Priority | High / Medium / Low | Focus allocation |
| Notes | Free-text context | Deal history at a glance |
A quick note on the Email column: verify addresses before they enter your pipeline. A bounced email means a dead deal you're still forecasting. Prospeo's free tier handles 75 verifications per month - enough for any spreadsheet-stage team to keep data clean.
Five Pipeline Stages
Stages should reflect what the buyer did, not what your rep did. "Sent proposal" is a seller action. "Requested pricing" is a buyer action. Build around the buyer and your forecasts get sharper.
| Stage | Buyer Action Trigger | Default Probability |
|---|---|---|
| Lead Qualified | Confirmed fit + interest | 20% |
| Discovery Complete | Shared pain, timeline, budget | 40% |
| Proposal Sent | Requested or accepted proposal | 60% |
| Negotiation | Discussing terms or pricing | 80% |
| Closed-Won | Signed or verbally committed | 100% |
Five stages is the sweet spot. Pipedrive recommends defining stages around buyer actions and keeping the count to five or fewer to reduce confusion and improve adoption. For complex B2B deals with 6-10 stakeholders, you might split Discovery into "Discovery" and "Stakeholder Mapping," but keep your stage criteria crystal clear.
And remember: stage accuracy depends on whether the contact is still reachable. A deal sitting in "Negotiation" with a bounced email isn't a deal. It's a ghost.
Six Formulas That Power the Spreadsheet
These reference the column schema above. Column letters assume the exact order in the table. Every division formula is wrapped in IFERROR so your dashboard doesn't break on day one.
Total pipeline value (open deals):
=[SUMIF](https://support.google.com/docs/answer/3093583?hl=en)('Sales Log'!K:K,"Open",'Sales Log'!G:G)
Total revenue won:
=SUMIF('Sales Log'!K:K,"Closed-Won",'Sales Log'!G:G)
Deals won:
=COUNTIF('Sales Log'!K:K,"Closed-Won")
Win rate:
=IFERROR(COUNTIF('Sales Log'!K:K,"Closed-Won")/(COUNTIF('Sales Log'!K:K,"Closed-Won")+COUNTIF('Sales Log'!K:K,"Closed-Lost")),0)
Average deal size:
=IFERROR(AVERAGEIF('Sales Log'!K:K,"Closed-Won",'Sales Log'!G:G),0)
Weighted forecast (the one most templates skip):
=SUMPRODUCT(('Sales Log'!K2:K500="Open")*('Sales Log'!G2:G500)*('Sales Log'!H2:H500/100))
That last formula multiplies each open deal's value by its win probability and sums the result. The weighted forecast is what separates a real pipeline tracker from a glorified contact list - it's the single most useful number in your spreadsheet, and we've seen teams completely change their quarterly planning once they start using it.
Your weighted forecast formula is useless if half your pipeline contacts have bounced emails. Prospeo verifies emails at 98% accuracy with a 7-day data refresh - so every row in your Google Sheet reflects a real, reachable buyer. The free tier covers 75 verifications per month, enough to keep a spreadsheet pipeline clean.
Stop forecasting on ghost deals. Verify every contact in your pipeline.
Dropdowns and Conditional Formatting
Dropdowns prevent the typos that silently break every formula above. If one rep types "Closed Won" and another types "closed-won," your COUNTIF returns garbage. We've debugged this exact issue more times than we'd like to admit.
Set them up: Data > Data validation > Dropdown (from a range). Apply to the Stage, Status, Deal Source, Priority, and Sales Rep columns. Store your dropdown options in a separate Settings tab so you can update them in one place.
For deal aging, add conditional formatting on the Date Created column: green for 0-7 days old, yellow for 8-14 days, red for 15+ days. Go to Format > Conditional formatting and use custom formulas like =TODAY()-B2>14. Stale deals are the silent killer of pipeline accuracy - they inflate your forecast and hide the fact that nothing's actually moving.
For follow-up reminders, add a "Next Follow-Up" column and apply conditional formatting that turns red when the date passes today.
Building a Dashboard Tab
Create a new tab called "Dashboard." Pull in four KPI cells from your formulas: total pipeline value, win rate, average deal size, and weighted forecast.
Below those, insert a chart: Insert > Chart > Combo chart. Use pipeline stages as your X-axis and deal count or value as your Y-axis. The combo chart lets you overlay a bar (deal count per stage) with a line (cumulative value), which makes bottlenecks obvious at a glance. This is where spreadsheets actually shine - fast scenario planning without waiting for a BI team to build you a Looker dashboard.
Keeping Contact Data Fresh
Here's the thing: a pipeline full of dead contacts produces garbage forecasts. Your formulas can be perfect and your stages pristine, but if emails bounce and contacts changed jobs last quarter, your weighted forecast is fiction. The consensus on r/googlesheets and r/CRM is consistent - beautiful templates, useless data.
This is where email verification earns its keep. Upload a CSV of your pipeline contacts to Prospeo and get verification results in minutes - 98% email accuracy, with data that refreshes every 7 days so results reflect current records, not stale ones. The free tier covers 75 emails per month. The workflow is simple: verify before you add, re-verify quarterly, delete anything that bounces.
Building your pipeline in Google Sheets means you own the data hygiene. Upload your pipeline CSV to Prospeo and get verified emails, updated job titles, and company data back - 92% match rate, 50+ data points per contact, at roughly $0.01 per email. No CRM contract required.
Enrich your entire spreadsheet pipeline in minutes, not hours.
Two Automations Worth Adding
You don't need to rebuild your stack. Two Zapier recipes handle the worst manual grunt work:
- Lead capture to new Sheets row. Connect your form tool or lead ad platform to automatically create a pipeline row when a new lead comes in.
- Stage update to Slack notification. When a rep changes a deal's stage, fire a message to your team channel. Keeps managers in the loop without "hey, any updates?" messages clogging your DMs.
Zapier's free tier works for single-step automations. Multi-step Zaps need a paid plan - expect around $20-$30/mo depending on billing cycle.
When to Ditch the Spreadsheet
Let's be honest: most teams hit the spreadsheet wall later than CRM vendors want you to think. We've seen teams run 500+ deal pipelines in Sheets without breaking a sweat. But the wall is real. Watch for these thresholds:
- A few thousand rows with complex formulas - Sheets starts lagging noticeably
- More than 10 users editing the same sheet - version conflicts and overwrites become a daily headache
- More than 30 minutes a day maintaining the spreadsheet - your hidden cost now exceeds a CRM subscription
- 94% of business spreadsheets contain critical errors (Ray Panko's research has been tracking this for decades) - the more complex yours gets, the more likely you're in that majority
Skip the CRM pitch if you're under 5 reps and 200 active deals. A well-built sales pipeline spreadsheet with clean data and real formulas beats a half-implemented CRM every time. When you do outgrow it, CRM options start cheap: HubSpot has a free tier, Pipedrive starts around $14/seat/month, and the broader market runs $30-$100/user/month.
FAQ
Can Google Sheets handle a real sales pipeline?
Yes - for teams under 10 reps tracking fewer than a few thousand active deals. Beyond that, performance and collaboration degrade fast. Start with a spreadsheet pipeline, and upgrade to a CRM when daily maintenance eats more than 30 minutes.
What makes a good free pipeline template?
Data validation dropdowns, a weighted forecasting formula, and a dashboard tab. Avoid templates that require an email signup - they're usually stripped-down upsell vehicles for the vendor's CRM. The template above includes all three out of the box.
How do I keep contact data accurate in my pipeline?
Verify emails before adding them. Bad data turns your forecast into fiction and your outreach into bounced messages. Prospeo's free tier covers 75 verifications per month with 98% accuracy - enough for most spreadsheet-stage teams. Re-verify quarterly, and remove any contact that bounces.