To build a sales pipeline, define 5 to 7 stages that match how your buyers actually decide, write a clear exit criterion for each stage, put every open opportunity into one place (a spreadsheet or a CRM), and review it every week. The hard part is not building it. It is keeping it updated, and that is where AI now helps the most.
This guide shows how to build a sales pipeline from scratch in five steps, with a ready-to-copy stage template, a spreadsheet version, and a simple pipeline dashboard. Then it covers how an AI CRM keeps the pipeline honest by logging calls, moving stages and flagging stale deals. We make one of those tools, KissMySkills AI CRM. We say where it fits and where it does not; for a small number of deals, a spreadsheet is genuinely fine.
What a sales pipeline is (and isn't)
A sales pipeline is the list of every real opportunity you are working on, organised by stage, with a next step and an expected value. It answers three questions at a glance: what is in play, where is each deal stuck, and what should I do today?
What it is not:
- Not a contact list. A pipeline holds opportunities, not everyone you have ever met. A person can exist in your contacts without a deal.
- Not a sales funnel. A funnel describes how a group of leads narrows over time, often for marketing. A pipeline tracks individual deals and the actions on them.
- Not a forecast by itself. A forecast is built from the pipeline, but only if stages and values are accurate.
Step 1: define your stages and exit criteria
Most pipelines fail because stages describe what the seller did ("sent proposal") rather than what the buyer decided. Write stages around buyer commitments, and give each one a test that is either true or false.
Here is a starting template for a B2B or service business. Copy it, then rename stages to match your words.
| Stage | Exit criterion | Required fields | Typical conversion (example starting point) |
|---|---|---|---|
| 1. New lead | You have made contact and they replied | Name, company, source, date | Replace with your own; start by assuming about half move on |
| 2. Qualified | They have the need, a budget range and a decision-maker you know | Need, budget range, decision-maker | Track yours from the first 20 deals |
| 3. Discovery / meeting held | You understand the problem and agreed next step | Meeting date, problem summary, next step | Track yours |
| 4. Proposal sent | They received a priced proposal and a review date is set | Value, proposal date, review date | Track yours |
| 5. Negotiation | They confirmed intent; only terms remain | Objections, expected close date | Track yours |
| 6. Won / Lost | Signed, or a clear no with a reason | Close date, final value or lost reason | n/a |
A note on the conversion column: there is no universal "good" stage conversion rate. It depends on your price, market and lead sources. Use the first 20 to 30 deals to measure your own, then use those numbers for forecasting.
Rules that keep stages useful:
- 5 to 7 stages. Fewer hides problems; more means nobody updates them.
- Every deal has a next step with a date. A deal with no next step is not active, it is waiting to be marked lost.
- Always record a lost reason. Lost reasons are the cheapest market research you will ever get.
Step 2: decide where leads come from and how you track them
Before you build anything, list your lead sources: website form, referrals, email inquiries, events, outbound, marketplaces. For each, decide who creates the deal and when. This is the basis of how to track leads without losing them.
- Inbound (forms, email): create the lead the same day. If it arrives in an inbox, it should be in the pipeline before you reply.
- Referrals: log the referrer, because you will want to thank them and track which partners send good work.
- Outbound: keep prospects in a separate list until they reply; only replies become pipeline deals. Otherwise stage 1 fills with hundreds of cold names.
Add a "source" field to every deal. After three months, it tells you where your best customers come from.
Step 3: build it
In Excel or Google Sheets
Here is how to build a sales pipeline in Excel or Google Sheets in about 30 minutes:
- Create one row per deal with columns: Deal name, Company, Contact, Source, Stage, Value, Next step, Next step date, Last contact date, Owner, Notes, Lost reason.
- Make "Stage" a dropdown (Data validation) with your stage names, so spelling never varies.
- Add conditional formatting that turns "Next step date" red when it is in the past.
- Add a second tab with a pivot table: count and sum of value by stage. That is your first pipeline dashboard.
- Sort by "Next step date" every morning. The top rows are your to-do list.
How to track leads in Excel without chaos: one row per opportunity, never delete a row (mark it Won or Lost instead), and keep notes short with the date first, for example "10/07: sent revised quote".
Be honest about where a spreadsheet stops working. Under about 20 active deals with one person selling, it is fine, and we would not push you off it. Past that, reminders, history and sharing become painful.
In a CRM
Moving to a CRM is mostly the same steps: create the stages, add the required fields, import the spreadsheet. What you gain is automatic reminders, a full history per contact, email and calendar links, and a board view where you drag deals between stages. Any mainstream CRM does this. If you work with AI daily, an agent-first CRM lets you skip the setup screens: you describe your stages and your AI creates them. Our guide to managing a CRM from Claude shows how.
Step 4: the weekly pipeline review
How to manage a sales pipeline comes down to one habit: a 30-minute review every week, same time, same agenda.
- Clean up. Every deal has a current stage, a value and a next step with a future date. Fix what is not true.
- Stale deals. Anything with no contact in 14 days gets a decision: a specific next action, or mark it lost.
- Deals closing this month. For each, what has to happen and who does it?
- Top of pipeline. Are there enough new qualified deals to hit next quarter's target? If not, that is this week's priority.
- One lesson. Look at last week's wins and losses. Write one sentence about what to repeat or avoid.
Step 5: measure it with conversion by stage and a simple pipeline dashboard
A useful sales pipeline dashboard for a small business needs only five numbers:
- Open pipeline value by stage.
- Conversion rate by stage: of deals that entered a stage, what share moved to the next one.
- Win rate: won deals divided by won plus lost.
- Average deal size.
- Sales cycle length: average days from new lead to won.
With those, you can answer "how many new leads do we need?" Example: if your win rate from qualified is 25% and your average deal is $5,000, then $50,000 in new revenue needs about 40 qualified deals. Work backwards from there.
How AI keeps a pipeline honest
Every guide on how to build a sales pipeline skips the boring part: keeping it updated. Pipelines rot because logging a call takes two minutes and nobody has two minutes after every call. Three weeks later the board shows deals that died long ago, and people stop trusting it.
This is the job AI is genuinely good at in 2026. Here is how to use AI in a CRM in practice:
- Logging. After a call, you tell your AI assistant what happened in a sentence. It writes the note, updates the stage and sets the next step date.
- Capture. Paste an inquiry email into the chat. The AI creates the contact and the deal with the right source and stage.
- Follow-ups. Ask "who should I follow up with today?" and get a list based on next step dates and last contact.
- Stale-deal alerts. Ask "which deals have had no contact in two weeks?" and decide on each one in the chat.
- Weekly review prep. Ask for a summary of what moved, what stalled and what is closing this month before your review.
KissMySkills AI CRM is built for this. Your own Claude or ChatGPT connects through the KissMySkills MCP connector and does the logging, stage changes and follow-up lists from your words. You can ask it to create your stages from the template above in one prompt. It is free for up to 300 deals and 1 user at crm.kissmyskills.com, and the All-Access subscription ($15 a month or $129 a year) adds unlimited deals and the other KissMySkills tools.
Where it is not the right tool: if you run high-volume outbound with automated multi-step email sequences, dedicated sales engagement tools such as Outreach or Apollo are much stronger for sequencing. Our CRM keeps the pipeline; it does not send email campaigns. For AI agents across the whole sales process, see the best AI agents for sales teams and our guide to AI agents for sales outreach.
Common mistakes
- Too many stages. Ten stages look thorough and nobody updates them. Merge until you have 5 to 7.
- Seller-based stages. "Sent proposal" says what you did, not what the buyer agreed to. Use buyer commitments.
- No next step. Every open deal needs a dated action. No action means not active.
- Never closing out lost deals. A pipeline full of zombies inflates every number. Mark them lost and record why.
- Optimistic values. Use the quoted price, not the dream price.
- Skipping the weekly review. The review is the pipeline. Without it, you only have a list.
- Buying a big CRM too early. Start with a spreadsheet or a simple CRM and add tools when a real problem appears.
FAQ
How long does it take to build a sales pipeline?
Setting up the structure takes an afternoon: stages, exit criteria, fields and importing your current deals. Filling it with enough qualified opportunities to be predictable usually takes one to three sales cycles, depending on how long your deals take to close.
How to manage your sales pipeline?
Keep every deal at an accurate stage with a value and a dated next step, review the whole pipeline once a week, close out stale deals quickly, and track conversion by stage so you know where deals get stuck. AI assistants can handle most of the logging and reminders.
How to track leads in Excel?
Use one row per opportunity with columns for name, company, source, stage, value, next step, next step date and notes. Make stage a dropdown, highlight overdue next steps in red, never delete rows, and add a pivot table for value by stage.
How to use AI in a CRM?
Use AI to do the updates people skip: logging calls and notes from a sentence, creating deals from emails, setting next steps, listing who to follow up with today and flagging deals with no recent contact. With an agent-first CRM, your own Claude or ChatGPT does these through a connector.
Build your pipeline in one prompt
Ask Claude to build your pipeline stages in the AI CRM. It is free to try at crm.kissmyskills.com, and All-Access unlocks unlimited deals and all 7 KissMySkills tools for $15 a month.
