Picture this: you’re deep in a great conversation with a potential client. They say “let’s touch base in a few weeks,” you both move on with your day, and two months later you remember. By then they’ve already hired someone else. That’s exactly the moment that pushed a Redditor in r/ChatGPTPromptGenius, u/Safe-Music4100, to fix this for good.
“Not gonna lie, I’ve lost actual paying work before just because I forgot to follow up with someone who was interested,” this Redditor wrote, and honestly, that line hit close to home for a lot of people in the comments. Not because anyone lacks discipline. Life gets busy, things slip, and by the time you remember, the window’s closed. It’s an especially rough problem for freelancers, consultants, and anyone juggling client work solo, since there’s no sales team behind you catching what you drop. A missed follow-up rarely feels like a big deal in the moment. It’s just one more thing on a long list. The cost only shows up weeks later, quietly, as revenue that went to someone else.
Here’s the good news: the fix this Reddit user built costs nothing, takes about 15 minutes to set up, and doesn’t rely on you remembering anything ever again. By the end of this guide, you’ll have the exact same system running for your own leads, using tools you probably already have access to.
Why It Matters 📋
Losing a lead rarely comes down to bad work or a weak pitch. It comes down to timing.
Someone reaches out interested, everyone gets busy, and the moment quietly passes. Weeks later you stumble across the conversation and cringe, because you both know the window’s gone. The fix here isn’t “be more disciplined” or “set more reminders” on your phone that you’ll swipe away without reading. It’s removing memory from the equation entirely. Build a system once, and the system remembers so you don’t have to.
That’s really the whole idea: automation doesn’t replace the hustle you already put into landing a lead. It protects that hustle from evaporating over a scheduling gap. And unlike a paid CRM subscription, this version costs exactly zero dollars. No onboarding call, no seat limits, no monthly invoice showing up while you’re trying to keep overhead low. Just a sheet you already know how to use and one small automation running quietly in the background.
The Fix, Step by Step 🛠️
Here’s exactly what this Reddit user built, in order.
- Log every lead in a Google Sheet. One row per person, with a “follow-up date” column. No CRM, no new software, just a spreadsheet you probably already have open. Keep the columns simple: name, contact info, what they’re interested in, and the date you agreed to check back in.
- Set up a free Zapier automation that checks the sheet daily. The automation scans the follow-up date column each day, looking for a match with today’s date. This runs on Zapier’s free tier since it’s just one simple trigger, so there’s no cost to keep it running indefinitely.
- Get pinged the second there’s a match. When today lines up with someone’s follow-up date, Zapier sends a notification with their name and context attached. This Redditor uses Telegram, but email works just as well. Either way, the moment arrives with the information already in front of you, so there’s no digging back through old messages trying to remember what you talked about.
That’s the whole system. In this Redditor’s words, “I haven’t missed a follow-up since.”
Tips & Tricks 💡
A few ideas worth stealing straight from the comments.
Add a “why,” not just a “when.” One commenter, u/lucky3pointer, made a sharp point: a date tells you to reach out, but it doesn’t tell you what to actually say. Add a short note on what the follow-up is for, so you’re not scrambling for context when the ping lands. Even a five-word note like “wanted quote after Q2 budget” saves you from an awkward “so, remind me what we discussed?” opener.
Automate the intake side too. Another commenter, u/joint_entropy, asked about automating how leads get added to the sheet in the first place, pulling the name and follow-up time straight from a conversation. Worth building out if you’re capturing leads through a form or chat tool, so the row gets created the moment someone shows interest instead of whenever you remember to type it in.
Resist turning it into a CRM. The entire appeal here is that it costs nothing and takes zero willpower to maintain. A few columns is plenty. Adding more fields just gives you more reasons to skip it.
Pick the notification channel you’ll actually see. Telegram works well because it interrupts you the way a text does, but if you live in your inbox, email does the same job. The point isn’t which app, it’s that the ping reaches you somewhere you can’t ignore.
Never Let a Lead Go Cold Again 🚀
The best part of this system is how boring it is. No new app to learn, no subscription, nothing fancy. Just a spreadsheet and an automation doing the one job your memory can’t be trusted to handle consistently. And once it’s running, it just quietly works in the background, forever, catching every lead you’d otherwise let slip.
If you’ve ever lost work to a forgotten follow-up (and be honest, most of us have), this is worth setting up today, not next month. Head over to the original thread on r/ChatGPTPromptGenius to see the full discussion and pick up more ideas from people running their own version of this system.
Frequently Asked Questions
Q: Should I automate adding leads to the sheet?
Manual entry right after a call actually works better than auto-capture. It takes 20 seconds and forces you to capture context, what they said, what they need, while it’s fresh. That context is gold when you follow up days later and need to remember where things stood.
Q: What columns should I add to my follow-up sheet beyond name and date?
Two make the biggest difference: (1) their last words, pasted verbatim, not your summary, so you remember “waiting on finance guy” vs “not a priority” by day 10. (2) Your reason to write, what changed on your side (project finished, price dropped, slot opened). Without a real reason to follow up, push the date forward instead of sending “just checking in.”
Q: Why do some follow-ups feel like spam?
Generic check-ins don’t get replies because they don’t offer value. Always lead with something new on your side, a finished project, price update, or angle specific to them. That’s what makes them open and respond, not ignore.
Q: Do I have to use Zapier?
No. Google Sheets has built-in notifications, or use Make, IFTTT, or a simple script. Pick whatever sends reminders to where you already live, email, Slack, Telegram, SMS. The tool matters less than the discipline of logging and actually following through.
Realized I was losing leads simply by forgetting to follow up — fixed it with a free automation
by u/Safe-Music4100 in ChatGPTPromptGenius