How to Build a Sales Pipeline That Actually Works (With Stage Examples)

Ask a small business owner how many deals they have in progress and you often get a pause, then a guess. Leads sit in WhatsApp, email and memory, and nobody is quite sure which ones are close to buying and which have gone cold.

A sales pipeline fixes that. It is a simple, visual way to see every potential sale and the next action each one needs. This guide shows you how to design one that fits the way you actually sell, how to keep it full, and where simple automation can move leads from one stage to the next.

How this guide was made: the stage examples and the sample deals below are made up to illustrate the ideas. They are not client data. Statements about HubSpot, Zoho CRM, HighLevel and Google Sheets come from those companies' own documentation, linked at the end.

What is a sales pipeline?

A sales pipeline is a series of stages that shows where every potential customer is in your buying process. In a CRM it usually looks like a board with columns. Each deal is a card, and you move it to the right as it progresses.

The CRM vendors describe it in much the same way. HubSpot describes a pipeline as a way to visualize a process through stages, where each stage shows where a record sits in that process. Zoho CRM describes it as a view of where prospects are in the buying cycle, how many deals are open and how long deals stay in each stage.

At a glance, you can answer questions that are otherwise hard to answer: How many people are waiting for a quote? Which deals have not moved for two weeks? How much revenue might close this month?

If you are not yet using a CRM, start with What is a CRM? A simple guide for small businesses.

Pipeline vs. sales funnel

People often use these words interchangeably, but there is a useful difference. A funnel describes how many people drop out at each step (for example, 100 visitors become 10 leads and 2 customers). A pipeline is your working list of real deals and the action each one needs. The funnel is for analysis; the pipeline is for daily work.

Why a small business needs one

• Nothing gets forgotten. Every deal has a stage and a dated next step, so a quote does not sit unanswered for a week.
• You can see what is stuck. A card that has not moved in two weeks stands out on a board; it hides in a chat history.
• You can plan. Counting deals by stage gives you a rough view of what might close, so you know whether you need more leads this month.

How to build a sales pipeline, step by step

1. Write down your last five sales. For each one, list what happened from first contact to payment: they messaged, you replied, you had a call, you sent a price, they asked questions, they paid. Also note one or two deals you lost and where they stopped.
2. Find the common steps. The steps that appear in most of your sales become your stages. Aim for four to seven.
3. Name each stage after a customer action. "Proposal sent" is fine, but "Proposal viewed" or "Asked for a call" shows real buyer interest.
4. Add an exit rule to each stage. Decide exactly what must happen for a deal to move forward. Clear rules stop deals from sitting in the wrong column.
5. Add an entry rule for new deals. No deal goes on the board without a named contact, a source, a next step and a date.
6. Include Won and Lost. Record why each deal was lost (price, timing, chose a competitor, no reply). After a few months those reasons show you what to improve. CRMs also expect this: HubSpot notes that both Won and Lost must be set up under deal probability so its sales reports handle deals correctly.
7. Choose a tool and set a review time. A spreadsheet is fine to start (see below). Then pick one slot a week to review the whole board.

Example pipelines you can adapt

These are illustrations, not case studies. Change the stage names to match your own sales steps.

A service business (agency, consultant, freelancer)

A local business taking bookings (salon, clinic, gym)

An online shop selling higher-value products

Do you sell very different things in very different ways? Give each its own pipeline. Zoho CRM supports separate pipelines for deals that follow different sales processes. A quick one-off product and a three-month project usually need separate boards.

A worked example with made-up deals

Here is how a pipeline looks as a simple table. The business and the deals are fictional, created only for this guide. The "chance to close" percentages are guesses that the owner sets and then adjusts as real results come in.

Add up the values and the open pipeline is $9,500. Multiply each value by its chance to close and add the results, and the weighted pipeline is $4,730. Weighted amounts are an estimate, not a promise. They are useful because they stop one large early-stage lead from making the pipeline look healthier than it is.

HubSpot works the same way: each deal stage has a probability that HubSpot uses to calculate a weighted amount in its board view.

How to fill the pipeline

A pipeline with great stages and no new leads still produces nothing. Fill it from more than one place, so you do not depend on a single source:

• People who already know you. Past customers, old enquiries and quotes that never got an answer are often the quickest leads to revive.
• Referrals. Ask happy customers directly, and say exactly what kind of customer you are looking for.
• Your website and profiles. A clear contact form or booking link on the pages people already visit. Make it obvious what happens after they send it.
• Direct outreach. A short, relevant message to a small list of people who match your best customers, with one clear question.

Whatever the source, apply the entry rule from step 5: a name, a source, a next step and a date. Record the source on every deal. After a few months you will see which channel produces real customers, not just enquiries.

Speed matters too. Reply to a new enquiry while it is still fresh and say when they will hear from you next. This is the first thing most small businesses automate (see below).

What to record on every deal

Keep it light so you actually fill it in:

• Contact details and the person's name
• Source: where the lead came from (Facebook, Google, referral, walk-in)
• Estimated value of the deal
• Next step and due date: the single most important field
• Notes from every conversation

A deal with no next step is a deal you are about to forget.

When Google Sheets is enough, and when to move to a CRM

A spreadsheet is a fine first pipeline if you are one person with a handful of deals. Use one row per deal, a "Stage" column and a "Next step date" column. Google Sheets can give the Stage column a drop-down list (Data, then Data validation), so every deal uses the same stage names.

Consider a CRM when:

• More than one person works on deals and needs to see the same board.
• You have more deals than you can review by eye in 20 minutes.
• You want reminders, email history or automatic follow-ups tied to each stage.

CRMs all use the same idea under different names. In HighLevel, a potential sale is an "opportunity" that sits in a pipeline and a stage; its status (open, won, lost or abandoned) is set separately from the stage. Our GoHighLevel guide for beginners covers the basics of that tool.

Where automation helps

Once your stages are clear, automation can do the repeating work: capturing the lead, preparing the first reply and reminding you when a deal goes quiet. It should not decide who is a good customer or what to charge.

A real example of the first steps

We built and ran the first part of this flow in n8n. In our lead follow-up tutorial, a test form submission is saved to a Google Sheet first, so the lead is not lost if a later step fails. The workflow then prepares a reply and creates a Gmail draft. No email was sent, and that workflow has no AI step. It does not move deals between stages; the stage change in this guide is still done by a person.

To learn how triggers and actions fit together, read What is AI automation?. To decide which of your own tasks to automate first, use our simple automation audit, and for more ideas see CRM automation workflows: 10 practical examples. If you are still choosing a tool, our n8n vs Zapier vs Make comparison covers pricing and a same-task test.

Metrics worth tracking

You do not need a dashboard. Four numbers, checked weekly or monthly, are enough:

• Deals in each stage. It shows where the pipeline is thin or crowded.
• Days in the current stage. Anything far above your normal is stuck.
• Win rate: deals won divided by deals won plus deals lost. For example, 4 won and 6 lost is 4 ÷ 10, or 40%. Use your own numbers.
• Average deal value and the reasons for lost deals.

The 20-minute weekly pipeline review

Pick the same time every week and work through this checklist:

1. Clean up: move deals that have progressed, and close deals that are clearly dead.
2. Check stuck deals: anything that has not moved in 14 days needs a follow-up or a decision.
3. Confirm next steps: every open deal should have a dated next action.
4. Look at the numbers: how many new leads arrived, and how many deals were won and lost?
5. Pick one improvement: for example, replying faster or sending proposals sooner.

Common pipeline mistakes

• Too many stages. If you need a manual to understand your pipeline, simplify it.
• Optimistic deals. Leaving dead deals open makes your forecast look better than reality.
• Stages based on your activity only. "Sent five messages" says nothing about whether the customer is interested.
• No owner. In a team, every deal needs one named person responsible for it.
• Copying a template unchanged. A template is a starting point. Rename the stages to match how your customers really buy.
• Automating a messy process. If the stages and exit rules are unclear, automation will only move the confusion faster.

Frequently asked questions

Need help setting this up?

If you would like help turning your sales steps into a working pipeline, and automating the first reply and the reminders, you can get in touch with Ai Spark. We start with how you sell today, not with a tool.

Sources

• HubSpot Knowledge Base: Set up and customize pipelines (checked 26 Oct 2026)
• Zoho CRM Help: Multiple Sales Pipeline (checked 26 Oct 2026)
• HighLevel Help: Step-by-Step Guide to Creating Opportunities (checked 26 Oct 2026)
• Google Docs Editors Help: Create an in-cell dropdown list (checked 26 Oct 2026)