How to Build a Simple Lead Follow-Up System in a Spreadsheet

Prefer to watch?

This guide is also a video.

Watch the video →

Why do leads go quiet?

The most expensive lost leads share a trait: they never said no. An estimate went out, the customer went quiet, and nothing in the business was responsible for what happened next. Following up meant remembering to, and remembering competes with the job currently in front of you, which always wins.

There's a compounding problem: uncertainty. Weeks later, the lead crosses your mind, but you can't reconstruct whether you already nudged them, whether they declined, or whether the quote is still open. Acting feels risky in every direction, so the safe move becomes doing nothing, and the job resolves itself by going to someone else.

A follow-up system removes both failure points. It replaces memory with a written state and replaces uncertainty with a pre-decided action. Three columns on the tracker you already keep accomplish that. If there's no tracker yet, build one first with the guide on organizing customer information.

Column one: what status labels do I need?

Status answers "where does this person stand?" for every row at a glance. Five or six labels cover nearly any service business:

Adapt the wording to your trade; the labels matter less than the value they create, which is that the whole pipeline becomes readable in one scan. The middle statuses are the valuable ones. "Estimate sent" and "waiting on customer" are exactly the leads that evaporate in a memory-based system, and exactly the ones a status column keeps visible.

Column two: what makes a good next step?

A status describes the situation; it doesn't prescribe an action. Without the second column, a tracker degrades into a well-organized list of names, which is a filing cabinet, not a system.

The test for a next step is whether it can be executed the moment it's read, with no further thinking:

One action per person, written at the moment you last touched the lead, while the context is fresh. The payoff comes later: when you sit down to work the list, every decision has already been made. The session becomes pure execution, which is why it fits into minutes instead of getting postponed.

Column three: why a specific date?

"Follow up later" fails for a structural reason: later is not a trigger. Nothing in the world fires on "later." A date, by contrast, can be sorted on, synced to a calendar, and acted on the morning it arrives.

Dates matter most for long-window leads, which are also the highest-value ones to systematize. Some buyers operate on cycles: municipal customers, schools, and fire departments often cannot spend until a budget resets, and homeowners defer projects to spring or to after the holidays. Those sales go to whichever business makes contact when the window opens. "Reach out in the fall" leaves that to chance; a row dated October 1 makes it mechanical.

The customer's own words convert directly. "Check back next month" becomes a specific date typed while they're still on the phone. That ten-second habit is most of the system.

What does the daily routine look like?

The three columns only pay off through a small ritual.

Each morning, open the sheet and sort by the date column. Everything dated today or earlier is the day's follow-up list, usually two or three items. Work them, then update each row: new status, new next step, new date. Two minutes, done before the first job.

Once a week, run a slightly longer sweep. Scan for anything sitting in "waiting on customer" beyond a week or two and give each one a nudge date. Scan for rows with no date at all, which are leads drifting back toward the memory system, and date them. Five minutes on a Friday keeps the sheet honest.

How many times should I follow up before letting go?

The two failure modes are quitting after one attempt and pestering forever. A simple cadence avoids both: three attempts, spaced out, then a clean close.

A working default: first follow-up a few days after the estimate, second about a week later through a different channel (a text if the first was an email), third a couple of weeks after that as a low-pressure check-in. If all three go unanswered, send a final message that closes the loop without burning it: the quote stands, the door is open, reach out whenever the timing works. Then mark the row "not interested" and stop.

The close-out message matters more than it looks. Timing kills more deals than price, and the lead who ignored three messages in March calls back in June surprisingly often, precisely because the last contact was graceful. The system's job is making sure the three attempts actually happen and the file actually closes, so no lead occupies attention forever.

Where should all of this live, and when do I outgrow it?

One home. The statuses, next steps, dates, and customer notes live in the same tracker, reachable from a phone. Parallel note systems, some context in the phone contacts, some in an app, some on paper in the truck, mean no single place can be trusted, and an untrusted system stops being consulted.

Outgrowing the spreadsheet has specific symptoms: more active leads than a morning scan can cover, or several people working the same list and colliding. At that point a CRM such as Monday CRM or HubSpot adds automatic reminders and shared visibility, and a year of tracker habits will tell you exactly which features you need. Until the symptoms show up, the spreadsheet wins on the only metric that matters, which is whether it gets opened every day. If you want a broader check on your operations, the free self-assessment covers ten areas including follow-up systems.