How to track prospects without a CRM
Three lists and one weekly review are enough — until the follow-ups outnumber what you can hold in your head.
Updated 7 August 2026
The short answer
Track prospects without a CRM by keeping three lists — Researching, Contacted, Follow up — in a doc or spreadsheet, and reviewing all three on a fixed day each week. The system fails at the same point every time: not the lists, the follow-up dates. Nothing reminds you a date has arrived, so leads go quiet the moment volume outpaces what you can hold in your head.
The three-list version
Most solo consultants and freelancers don't need pipeline stages, forecasting, or a shared team view — they need to know who they've talked to and what happens next. Three lists cover it:
- Researching — a company you're looking into, no contact yet
- Contacted — you've reached out and are waiting to hear back
- Follow up — there's a specific next action, ideally with a date next to it
Where it breaks
A spreadsheet has no memory. It doesn't know today's date and it won't tell you a follow-up is overdue — you have to scan every row, every time, and remember to. That works at five prospects. At twenty, the scan takes longer than the follow-up would have, so it stops happening, and "Follow up" quietly becomes a list of leads you've lost.
The fix isn't more columns. It's something that turns a date into an alert instead of a fact sitting in a cell.
Where AI research fits
If you're already researching prospects in ChatGPT or Claude before reaching out, that research is the raw material for the tracker — the problem is it usually lands as a wall of prose you have to manually pull apart into a company row, a contact, and a next step. A structured prompt output (fixed headings, not free text) turns that copy-paste into something a system can actually read.
When to stop doing it by hand
The three-list system is genuinely enough for a slow trickle of prospects reviewed once a week. It stops being enough at the point where you're spending more time scanning for what's overdue than acting on it — for most solo founders that's somewhere past 15-20 open prospects at once. That's not a reason to adopt an enterprise CRM built for sales teams; it's a reason to want the same three lists with dates that actually surface themselves.
Frequently asked questions
- Is a spreadsheet enough to track prospects?
- Yes, up to a point — usually somewhere around 15-20 open prospects for one person. Past that, the time spent manually scanning for overdue follow-ups exceeds the time the follow-ups themselves take, and things start slipping.
- What's the minimum viable CRM alternative?
- Three lists — Researching, Contacted, Follow up — with a specific date on anything in Follow up, reviewed on the same fixed day every week. No pipeline stages, no forecasting.
- How do I turn ChatGPT or Claude research into a tracker entry without retyping it?
- Use a fixed-format research prompt instead of asking free-form — a structured prompt output can be parsed into a company row and a contact automatically instead of copied by hand. See the free prospect research prompt linked below.
- Do I need a full CRM as a solo founder?
- Usually not an enterprise one. Solo service founders — consultants, freelancers, agencies of one — rarely need pipeline stages or team forecasting; they need the three-list system above with reminders that actually fire, which is a much smaller tool than most CRMs are built to be.