How to build a freelance sales pipeline in Notion (and never lose a lead again)

Think about the last three potential clients you spoke with who didn’t end up hiring you. Did you follow up after sending the proposal? Did you write to them a week later to see if they had questions?

If the answer is “not always” or “I forgot,” that’s not a motivation problem. It’s a system problem.

Why freelancers lose leads

When you’re in the middle of several active projects, managing potential clients takes a back seat. You send the proposal and wait. If they don’t respond in a few days, the lead disappears from your radar.

But sales statistics are clear: most proposals don’t close on first contact. The difference between a freelancer who closes well and one who doesn’t is often in the follow-up.

What a pipeline is and why you need one

A sales pipeline is simply a visualization of where each potential client stands in your commercial process. From first contact to hiring.

Typical stages for a freelancer:

1. Lead — someone has shown interest
2. Initial contact — you’ve had a first conversation
3. Proposal sent — you’ve sent a quote or proposal
4. Negotiation — they’re evaluating, there are questions or price negotiation
5. Closed won — hired
6. Closed lost — didn’t work out (and why)

With this in Kanban format in Notion, you see at a glance how many leads you have in each phase and which ones have been stuck without movement the longest.

The automatic follow-up tracking that changes things

Add a “Last contact” field to your prospects database. Every time you interact with a lead, update that date.

Then create a formula “Days without contact” = today - last contact.

Sort your view by that column. The leads that have gone longest without contact rise to the top. That becomes your follow-up list for the day.

You don’t need to remember who you need to write to. Notion tells you.

What to note when you lose a client

The “Closed lost” column is one of the most valuable if you use it well. Add a note about why it didn’t close: price too high, bad timing, they chose someone else, the project was cancelled.

Over time, that data tells you useful things. If 80% of your lost proposals are about price, you may need to adjust how you present your value. If it’s about timing, you may need to generate leads further in advance.

If you want to set this up without starting from scratch

Freelance CRM Pro includes the prospects database with Kanban pipeline, follow-up fields, and filters to see which leads need attention — all connected to your active clients.

→ Get Freelance CRM Pro on Gumroad

---

How many proposals did you send last month? How many did you close? Did you follow up with the ones who didn’t respond?