How to Track Sales Pipeline in Google Sheets
|
|
Time to read 6 min
Table of contents
Start With Sales Stages That Match Your Real Process Build Your Google Sheets Pipeline Table How to Track Sales Pipeline in Google Sheets With Useful Formulas Make Follow-Ups Impossible to Miss Use a Simple Dashboard for Weekly Decisions Set a Routine So the Sheet Stays Accurate Popular Google Sheets Toolkits Recent Posts
A lead who says, “Call me next week,” is not a sale yet. But without a clear place to record that next step, they can disappear between client work, invoices, and everything else you run yourself. Learning how to track sales pipeline in Google Sheets gives you one practical view of every opportunity - who is interested, what they need, what happens next, and how much potential revenue is still on the table.
For a lean business, visibility matters more than a complicated CRM with features you will never touch. Google Sheets is flexible, familiar, and affordable. The key is setting it up as a working sales system, not just a long list of names.
Start With Sales Stages That Match Your Real Process
Your pipeline stages should reflect the way your customers actually buy. Avoid copying a big-company sales process if you are a consultant, freelancer, local service provider, or small agency. A simple pipeline is easier to maintain, and a pipeline you update consistently is far more useful than a detailed one you abandon after two weeks.
A practical starting point is: New Lead, Contacted, Discovery Call Booked, Proposal Sent, Negotiation, Won, and Lost. If your business sells lower-cost services without proposals, you might replace Proposal Sent with Quote Sent or Checkout Link Sent. If you sell a longer-term service, you may need a Qualified stage before a discovery call.
The point is not to have the “perfect” stages. The point is to make each stage mean something specific. For example, a lead is only “Contacted” after you have sent a personal email, called, or messaged them. A deal is only “Proposal Sent” once the proposal has actually gone out. Clear definitions prevent wishful thinking from inflating your pipeline.
Build Your Google Sheets Pipeline Table
Create a tab called Sales Pipeline and freeze the top row so your headers stay visible. Each row should represent one sales opportunity, not just one contact. A repeat customer who is considering a new project should have a new opportunity row, even if their contact details already exist elsewhere.
Your essential columns are:
- Deal Name or Client Name
- Contact Name
- Service or Product
- Pipeline Stage
- Deal Value
- Probability
- Expected Close Date
- Last Contact Date
- Next Follow-Up Date
- Next Action
- Lead Source
- Notes
This setup answers the questions owners ask every week: What should I follow up on today? Which proposals are still open? How much revenue could close this month? Where are leads coming from?
Use a dropdown list for Pipeline Stage. Select the stage column, choose Data Validation in Google Sheets, and enter your stage names. This keeps entries consistent. You do not want one deal marked “Proposal,” another marked “proposal sent,” and another marked “Quote out.” Those small inconsistencies make reports unreliable.
Do the same for Lead Source if you regularly use a few channels, such as Referral, Website, Instagram, Networking, or Paid Ads. Over time, this will show you where your best customers come from - not just where your most leads come from.
How to Track Sales Pipeline in Google Sheets With Useful Formulas
A list of deals is helpful. A pipeline becomes valuable when it tells you what revenue is likely to arrive and where sales are getting stuck.
First, assign a probability to each active stage. You can use your own numbers, but a simple starting point is 10% for New Lead, 25% for Contacted, 50% for Discovery Call Booked, 70% for Proposal Sent, and 85% for Negotiation. Mark Won as 100% and Lost as 0%.
Add a Weighted Value column. If Deal Value is in column E and Probability is in column F, use this formula in the first deal row:
`=E2*F2`
Format the Probability column as a percentage and the Weighted Value column as currency. Your weighted value estimates the portion of each deal you can reasonably expect to win. It is not a guarantee, but it is more realistic than adding every open opportunity together and calling it future revenue.
Below or beside your table, create a small dashboard area. You can calculate total open pipeline value with:
`=SUMIF(D:D,"<>Won",E:E)-SUMIF(D:D,"Lost",E:E)`
Depending on how you organize your data, you may prefer a formula that only includes your active stages. You can also calculate total weighted pipeline by adding the Weighted Value column for deals that are not marked Won or Lost.
For closed revenue, use a SUMIF formula that totals Deal Value when the stage is Won. This gives you a quick view of actual sales without mixing them into your active forecast.
Keep formulas simple enough that you understand them. A spreadsheet should reduce admin work, not create another technical task to manage.
Make Follow-Ups Impossible to Miss
Most small businesses do not lose deals because the offer was terrible. They lose deals because nobody followed up after the first conversation, quote, or proposal.
Your Next Follow-Up Date and Next Action columns are the most important part of the sheet. Every active deal needs both. “Follow up” is too vague. Write the actual action: “Email revised scope,” “Call after board meeting,” “Send case study,” or “Ask if they have questions about proposal.”
Use conditional formatting to flag overdue follow-ups. Apply a rule to your data range using a custom formula such as:
`=AND($I2
"Won",$D2<>"Lost")`
Set the formatting to a noticeable fill color. Now any active opportunity with a follow-up date before today stands out immediately.
You can add a second rule for deals due today using `=$I2=TODAY()`. This gives you a focused daily call list without sorting through every row. Open the sheet at the start of your workday, handle the highlighted follow-ups, and update the next action before you move on.
Use a Simple Dashboard for Weekly Decisions
You do not need a complicated reporting system to manage a small sales pipeline. A few numbers and one chart can show whether your sales activity is moving in the right direction.
Create a second tab called Dashboard. Use a pivot table to group opportunities by Pipeline Stage and total their Deal Value. A bar chart can then show where revenue is sitting. If most of your pipeline is stuck in Contacted, you may need better qualification or a stronger first follow-up. If many deals reach Proposal Sent but few close, review your pricing, proposal clarity, or sales conversations.
Also track deals by expected close month. This helps you plan cash flow, staffing, and workload. It depends on how predictable your sales cycle is, of course. A project-based business with large custom jobs should treat forecasts carefully. A business with short, repeatable sales cycles can use them more confidently.
Do not confuse a full pipeline with a healthy one. Ten stale leads from six months ago are not momentum. Review deal age regularly, and move unresponsive opportunities to Lost or a separate Nurture tab. Keeping dead deals out of your active view makes your numbers honest.
Set a Routine So the Sheet Stays Accurate
Google Sheets only works as a sales pipeline tool when it reflects what happened this week. Build a small routine around it: add new leads as they arrive, update a deal after every meaningful interaction, and review the pipeline once a week.
During your weekly review, check overdue follow-ups first. Then look at deals expected to close in the next 30 days, proposals that have been out for more than a week, and your lead sources. This takes far less time than trying to reconstruct your sales activity at the end of the month.
As your business grows, you may want customer records, sales activity, tasks, and follow-ups in one connected workspace instead of separate tabs. That is where a structured Google Sheets system like Sheetify CRM can save setup time while keeping the no-subscription approach many small business owners prefer.
Your spreadsheet does not need to look impressive for it to make you money. It needs to tell you who to contact next - then make it easy to follow through.
