← All posts

Build a Sales Pipeline That Runs Itself (No CRM Needed)

7/17/2026 · by Mykel Franklin

The Problem With "I'll Remember"

Most solo founders don't lose deals because their offer is weak. They lose deals because a lead went quiet for nine days and nobody followed up. Or a hot prospect asked a question on a Tuesday and got an answer the following Monday, by which point they'd hired someone else.

The usual fix people reach for is "get a CRM." But a real CRM, set up properly, takes hours you don't have, and half the fields will sit empty forever. You don't need Salesforce. You need a system that shows you, at a glance, exactly what's stuck and what's about to close.

Here's how to build that with a tool you probably already have open: project management software.

The Poor Man's CRM Setup

Create a board with five columns. Not eight, not twelve — five. Every extra stage is a place for deals to hide.

Each card is one deal. Card title format: Client Name — $Value — Date Entered Stage. That last piece matters more than anything else on the card, because it's what turns this from a to-do list into a forecasting tool.

Add two custom fields if your project management software supports them: Deal Value and Days in Stage. Most tools calculate the second one automatically from when the card was moved.

The Math That Makes This Useful: Weighted Pipeline Value

Here's where this stops being a glorified sticky-note wall and starts telling you something.

Assign a win probability to each stage, based on your own historical close rate (guess for the first month, refine after that):

Now multiply each deal's value by its stage probability, and sum them. Say your board looks like this:

Deal Value Stage Probability Weighted Value
Acme Co. $4,000 Proposal Sent 50% $2,000
Beltran LLC $1,500 Qualified 25% $375
Cho Design $6,000 Verbal Yes 80% $4,800
Delgado Fitness $2,200 New Lead 10% $220

Total raw pipeline: $13,700. Total weighted pipeline: $7,395.

That second number is your real forecast. It's the difference between telling yourself "I've got $13,700 in the pipe, I'm fine" and knowing you actually need three more Qualified-stage conversations this month to hit your revenue target. Weighted pipeline value is what banks and investors ask VP's of Sales for. There's no reason a solo founder shouldn't use the same math on a Tuesday morning with coffee.

Update it weekly. Takes four minutes once the board exists.

Automating Stage Transitions So Deals Stop Rotting

The board fixes visibility. Automation fixes the follow-up problem. Most project management software has rule-builders now — "when card enters column X, do Y" — and you can chain three or four of these without touching a developer.

Rule 1: When a card sits in New Lead for more than 2 days with no activity, auto-assign it back to you with a due-today task labeled "Qualify or disqualify."

Rule 2: When a card moves to Proposal Sent, trigger a task 3 days out: "Send check-in email." Better yet, connect this stage to your email marketing platform so a two-email nudge sequence fires automatically — day 3 and day 7 — without you drafting anything from scratch each time.

Rule 3: When a card sits in Proposal Sent for more than 10 days, flag it red. Anything red gets a phone call, not another email. Silence after two emails usually means the email isn't the problem.

Rule 4: When a card moves to Closed Won, trigger a checklist card in a separate "Active Clients" board, and if your invoicing software integrates with your project management tool, kick off the first invoice automatically instead of remembering to do it three days later.

None of this requires custom code. It requires ten minutes of setup, once, inside automation settings you already have access to.

A Worked Example: 90 Days In

Say you close 25% of Qualified deals historically, and your average deal is $3,000. In a given month you generate 20 new leads. Based on your own funnel data, roughly 60% get Qualified, 70% of those get a Proposal Sent, and 40% of proposals convert to Closed Won.

20 leads → 12 Qualified → 8.4 Proposals Sent → 3.4 Closed Won.

That's roughly $10,200 in monthly revenue from that cohort, three months out (since deals don't close the day they enter the pipe). If you need $15,000 a month and you're tracking $10,200, you now know precisely what to fix: either generate more top-of-funnel leads, or improve your Qualified-to-Proposal conversion rate, which is usually the cheapest lever — it's a sales-call skill problem, not a marketing spend problem.

This is the entire point of tracking stages numerically instead of vibes. "I feel like business is slow" becomes "my Qualified-to-Proposal rate dropped from 70% to 45% last month, and I know why: I stopped sending a written recap after discovery calls."

When to Graduate to a Real CRM

This system holds up comfortably to about 30–40 active deals at once. Past that, the board gets noisy and you'll want proper CRM software with pipeline reporting built in. But most solo founders never get there — and even if you do, you'll have a year of clean stage data to migrate over, instead of starting from a spreadsheet with half the fields blank.

The goal isn't sophistication. It's knowing, every Monday morning, exactly which three deals need a phone call today — and roughly how much money is actually coming in next month, not how much you hope is.

Related

The 3-Email Follow-Up System That Replaces a Sales Assistant5 AI Automations That Save Solo Founders 10+ Hours a WeekThe Follow-Up System That Wins Clients While You Sleep