By Suzaan · Updated July 2026
A client emailed me twice asking about a project I'd quoted three weeks earlier. I hadn't replied to either message. Not because I didn't want the work — I'd genuinely forgotten the conversation existed, buried somewhere between Gmail, Instagram DMs, and a sticky note I'd since thrown away.
That client went with someone else. And when I actually looked at it, that wasn't a one-time slip — it was the fourth lead I'd lost that year to the same problem: not a lack of clients, but a lack of any system tracking who I'd talked to and what I still owed them.
Most freelancers don't lose clients from bad work. They lose them from silent follow-ups — a lead goes cold not because you said no, but because nobody said anything at all.
Why spreadsheets and your inbox don't work as a client tracker
I tried the obvious fixes first. A spreadsheet with client names and a "status" column. Gmail labels. A sticky note wall that looked productive and helped nothing. Each one failed for the same reason: none of them told me what to do today. A spreadsheet is a record of the past, not a prompt for action — you have to remember to open it and interpret it yourself.
A proper client tracker needs to do one specific job: tell you, without you having to think about it, who you're supposed to talk to this week.
What actually goes into the tracker
After going through a few overbuilt versions (one had nine status fields — never again), here's what survived:
- One client database, four fields only. Name, Status (Lead → Contacted → Proposal Sent → Won/Lost), Last Contact Date, Next Follow-Up Date. That's it. Every extra field is a reason to stop updating it.
- A "This Week" filtered view. Set the Next Follow-Up Date field to filter and show only clients due this week. This becomes the only view you actually open day to day — not the full database.
- A simple rule for follow-up timing. Proposal sent, no reply → follow up in 4 days. Ongoing project → check in weekly. Past client, no contact in 60 days → a light re-engagement note. Write the rule once, apply it every time you add someone.
- A notes field for context, not novels. One line: what they need, what you last said. Enough that a message six weeks later doesn't start with "sorry, remind me what we discussed?"
- A weekly 10-minute review. Every Monday, open the "This Week" view and send whatever follow-ups are due, before anything else on your list.
Using AI to draft the actual follow-up message
Knowing you need to follow up and actually writing the message are two different kinds of friction. The second one is where I used to stall the longest — re-reading old messages, trying to sound casual but not forgetful. This is the one place I let AI do the annoying part.
It's a small thing, but it removes the exact hesitation that used to turn a two-minute task into a three-week silence.
What to do with leads that go cold anyway
Not every lead is worth chasing forever. If someone hasn't replied after two follow-ups, I move them to a separate "Cold" status instead of deleting them. Once a quarter, I send that whole list one short re-engagement note — no pressure, just a door left open. It's a five-minute task that's brought back more than one client I'd otherwise have written off entirely.
| Status | What triggers it | What you do |
|---|---|---|
| Lead | First conversation, no proposal yet | Follow up within a week |
| Proposal Sent | Quote or pitch delivered | Follow up in 4 days if no reply |
| Won | Project confirmed | Weekly check-in during the project |
| Cold | Two follow-ups, no response | One re-engagement note per quarter |
If you can't remember the last thing you said to a client without scrolling through old messages, your tracker isn't doing its job yet — the notes field exists so you never have to scroll.
Frequently Asked Questions
How is this different from Notion's built-in CRM template?
Notion's default templates are usually built for teams — more fields, more views, more setup than a solo freelancer needs. This version is deliberately stripped down to four fields because the goal is a tracker you'll actually open daily, not one that looks impressive and gets abandoned in a week.
Do I need the paid Notion plan to build this?
No — the free Notion plan supports databases, filtered views, and everything described here. You won't hit a paywall for this specific setup.
What if I have too many clients for a manual weekly review?
At high volume, the same four-field structure still works — the "This Week" filter does the sorting for you, so the review stays at roughly 10 minutes whether you're tracking 8 clients or 40. What changes is how strictly you need to log the Next Follow-Up Date every single time.
Should I track past clients too, or only active leads?
Keep past clients in the same database with a "Past Client" status. Repeat work from someone who already trusts you is usually easier to win than a new lead — but only if you're the one who reaches out first.
Freelancer & Creator OS
This post covers the client-tracking layer. The full system connects it to a proposal template and invoice log, so nothing about running your freelance business lives in four different apps anymore.
Get the full system →