A spreadsheet with six columns and one daily fifteen-minute habit outperforms most CRM software that nobody updates. What actually matters is not the tool but three things: every lead lands in one place, every lead has a next action date, and someone looks at that list every day. A free sheet with those three properties beats paid software without them.
Most owners assume the reason follow-up does not happen is that they lack a system. Usually they lack a habit, and buying software is a way of feeling like the problem is being addressed without addressing it. Building the habit is part of the systems work behind our AI & automation work.
Why leads get lost without one
An inbox is not a follow-up system, for one structural reason: there is no way to see what needs action today. Messages arrive in the order they were sent, not the order they need attention, and anything that scrolls up is functionally gone. A follow-up system has one job the inbox cannot do: show you, today, exactly who to contact.
The six columns
Open a blank sheet. Six columns:
- Name
- How to reach them (Viber number, Messenger, whatever they actually use)
- What they asked about
- Date of last contact
- Next action date
- Status (New, Following up, Quoted, Won, Lost)
That is a working CRM. Add nothing else until you have used it for a month and can name specifically what is missing.
Why "next action date" is the entire system
Every other column is reference. That one column is the machine. Sort by it, and your sheet answers "who do I contact today" without any thinking. Without it, you have a list of people and no idea which ones are due, which is barely better than the inbox. Every lead must have a date in it. Not blank. If you genuinely do not know, put a date two weeks out and decide then.
The fifteen-minute daily habit
Same time every day, non-negotiable:
- Sort by next action date
- Contact everyone due today
- Update their last-contact date and set a new next-action date
- Add any new leads from yesterday's messages
Fifteen minutes. If it takes longer, either you have been skipping days, or your business has grown enough to justify actual software.
Getting leads into the sheet
The weak point of any manual system is capture. Three ways to make it reliable:
End-of-day sweep. Five minutes reviewing the day's messages and adding anyone new. Simplest, works fine at low volume.
Add on first reply. When you respond to a new inquiry, add them immediately. Better, because nothing depends on remembering later.
Automate the capture. If inquiries come through a web form or booking tool, a connection tool can push them into the sheet automatically. Worth doing once volume makes the manual sweep annoying, as covered in our automation cluster.
Start manual. Automate when the manual version has proven the habit sticks.
Working within the messaging rules
Worth knowing, because it shapes what the system can do: Messenger restricts automated messages sent more than 24 hours after a customer's last message. This is exactly why a follow-up sheet matters more than automation software here. You cannot automate the message to a lead who went quiet a week ago. You can absolutely automate the reminder that tells you to send it personally, and that reminder is what the sheet provides. Our guide to automating follow-up covers the window in detail.
What to actually send
- Reference the specific thing they asked about
- Add something useful they did not have before
- Make the next step small and concrete
- Keep it shorter than your first message
Two or three follow-ups over a week to ten days, then stop and mark them Lost. Marking things Lost is important. A list full of leads from four months ago becomes a list nobody wants to open.
Sharing it with staff
If more than one person handles inquiries, add a seventh column: Owner. One named person per lead. Shared responsibility for follow-up reliably produces no follow-up, because everyone assumes someone else has it. The column costs nothing and prevents the most common failure in a team setting.
When you actually need real software
Genuine signals, as opposed to feeling like you should have one:
- More than a few hundred active leads, where a sheet becomes slow to work with
- Several people needing to update simultaneously without overwriting each other
- Needing conversation history attached to each contact rather than just a status
- Genuine need for reporting beyond counting rows
Until then, the sheet is not a compromise. It is the correct tool, and it has one significant advantage: it takes seconds to change when your process changes, while software takes a migration.
The number worth watching
Once a month, count how many leads you marked Won versus how many entered the sheet. That percentage is your conversion rate, and knowing it changes decisions. It tells you whether your problem is getting more leads or handling the ones you have. Most owners who build this discover their problem was the second one, not the first, which is genuinely good news because it is cheaper to fix.
The uncomfortable first month
Building this usually reveals more uncontacted leads than expected, because they were never visible enough to count. That reading is uncomfortable and it is the most valuable thing the system produces, since it makes the invisible cost visible for the first time.