AI System for CRM Prospecting
Stop tracking prospects in a spreadsheet. Use AI to remember every conversation, tell you who to follow up with, and draft the message in your voice.
By James Schramko · Updated June 2026
The Problem
Your prospects live in a spreadsheet. Every week you scan it and ask the same questions. Who have I not contacted? What did they last say? Is it time to follow up? What do I even write?
That is friction. And friction kills follow-up. Most deals close on the follow-up, not the first contact. So the spreadsheet is quietly costing you money.
The Better Way
Let AI read your email history and prospect notes. Then it does three things a spreadsheet cannot.
Remember the full history of every prospect conversation.
Tell you who is due for a follow-up this week.
Draft the next message in your own voice, ready to review and send.
Instead of "just checking in," you get "you mentioned you were testing this through winter. How did it land?" That is the difference between a reminder and a follow-up that knows the conversation.
You stop managing a spreadsheet. You start reviewing drafts.
What You Need
Four simple pieces.
A folder in your notes app called something like Prospects.
One short file per prospect. Name, email, status, last contact date, next check-in date. That is the whole record.
A label in your email so the prospect threads are easy to find.
A weekly routine that reads your notes and your email and does the work.
How It Runs
Once a week, the routine works through your prospect list.
It finds everyone whose next check-in date has arrived.
It reads the full email history with each one.
If they have written to you in the last few days, it leaves them alone. They are already active.
For everyone else, it writes a short follow-up. One or two sentences. A continuation of the real conversation, not a generic check-in.
It saves the draft in your email as a reply on the existing thread.
You open your drafts, read each one, and send the ones you like. After you send, the record updates. The last contact date becomes today and the next check-in moves out two weeks. Nothing moves until the message actually goes, so a draft you decide not to send never throws your dates off.
The Prospect Record
Keep it tiny. The whole point is low friction.
Name, email, company.
Status. Active means include them. Hold means pause them. Declined or closed means leave them alone.
Last contact date and next check-in date.
That is all the routine needs to decide who gets a follow-up and when.
Why The Drafts Are Good
A spreadsheet reminder tells you to follow up. It cannot write the message. AI can, because it has read the whole thread.
It knows what you said. It knows what they said. It knows how long it has been. It knows how you write.
So it picks up the actual thread. It references the specific thing they raised, the decision they were weighing, the timeline they gave you.
Short. Specific. Human. The kind of message you would have written yourself if you had the time and the memory.
Why This Beats A Traditional CRM
A CRM is another system to log into, maintain, and pay for. Most founders abandon theirs within months because keeping it current is a chore.
This approach uses tools you already have. Your email holds the history. Your notes hold the status. AI does the remembering and the writing. There is nothing extra to maintain because the work happens inside the tools you already live in.
Where It Fits
This works best when each prospect matters and the follow-up is by email.
High-value prospects you want to nurture personally. Variable deal cycles where timing differs from person to person. Lists you can read, not thousands of cold contacts.
It is not built for mass cold outreach or for a sales process that lives on the phone. It is built for considered, personal follow-up at a scale a human can review.
Getting Started
Make the Prospects folder. Add three prospects to start.
Label those threads in your email.
Set up the weekly routine to read your notes and your email and draft the follow-ups.
Run it for three weeks. The hygiene becomes automatic. The follow-ups stay in your voice. And the deals that used to slip through the gap because you forgot to follow up stop slipping.
If you want sharper words for the follow-ups themselves, see Essential Prospect Emails.