Getting leads with AI
Turn your customer list into repeat business with AI
A spreadsheet of past clients is a goldmine. Here's how to find them when they search, and book them faster than your competitors.
· 5 min read · Lead generation · Customer retention · AI search · Sales automation

Your best customers are not strangers. They've already bought from you. They know your work. They trust you. And right now, some of them are searching for help with their next problem.
But they're not searching for your name. A dental clinic in Kelowna isn't Googling "Kelowna dental clinic"—they're asking ChatGPT about tooth sensitivity or how to talk to patients about cosmetic work. A plumber in Richmond isn't searching "Richmond plumbing"—they're asking how to upsell water heater replacements or handle a difficult customer. A 12-person software company in Gastown isn't hunting for "Gastown software developer"—they're asking about hiring, scaling, or managing technical debt.
Your spreadsheet of past customers holds the answer. It tells you what they bought, when they bought it, and how much they spent. From that, you can infer what they need next and when. Then you can be there, with a simple, helpful message, before they call someone else.
Why this works better than waiting for inbound
Most service businesses rely on word of mouth and hope. A customer finishes a project, you invoice them, and then you wait. Maybe they call back in six months. Maybe they don't. Maybe they forgot about you and called your competitor instead.
Repeat customers are 5 to 10 times cheaper to acquire than new ones. They already know your quality, your process, and your price. They just need a reminder that you exist and a reason to call.
AI lets you be that reminder, at scale, without feeling pushy. You're not interrupting them with ads. You're reaching out with something relevant to a problem they're already thinking about.
How to find the signal in your data
Start with what you have. Pull your customer list, invoices, or project records into a spreadsheet. You need three things:
- What they paid for (the service type or project category)
- When they paid for it (the date)
- Any notes about their situation (size of business, industry, pain points they mentioned)
Now ask: what typically happens next. A plumber who replaces a water heater usually needs a furnace check in 18 months. A property manager who handles a tenant dispute usually needs legal review within a year. An accounting firm's client who does a year-end review usually needs tax planning advice six months later.
You already know this pattern. You've seen it dozens of times. The spreadsheet just makes it visible and repeatable.
Next, map that to what people are actually searching for. A property manager in Surrey might have a spreadsheet showing that 40% of their clients need eviction support within two years of signing a lease. That same property manager knows that people searching "eviction notice template" or "how to handle a difficult tenant" are probably in that 40%. A tool that watches for those searches and flags matching customers from your list turns that knowledge into action.
The goal is not to spam everyone. It's to find the 10 or 15 past customers who are most likely to need you right now, and reach them with a message that feels personal and timely.
The message that works
Don't sell. Remind and help.
You're not pitching. You're saying: "I noticed you had your kitchen done in 2022. Most of our clients like to refresh the hardware and lighting after a few years. I've got a few ideas if you want to chat."
Or: "We worked together on your tax return last year. I wanted to flag that Q2 is a good time to review your quarterly instalments. No pressure—just wanted to make sure you had it on your radar."
Or: "I saw you signed a new lease with a tenant last month. I know from experience that the first six months are when issues usually pop up. Happy to jump on a call if anything comes up."
These are not cold pitches. They're warm, specific, and they acknowledge the history. A person should write and send these, not a robot. You know your customers. You know what they care about. That voice matters.
What this actually takes
Time: 2 to 4 weeks to set up the first time. You'll need to organize your past customer data, identify the patterns, and write a few template messages. After that, it's 30 minutes to an hour per week to review flagged leads and send outreach.
Money: If you're doing this yourself, it's free except for the time. If you want a tool to help you watch for searches and match them to your customer list, budget 200 to 500 dollars a month. A distributor in Calgary or an accounting firm in Burnaby might see a return within the first month if they're reaching out to 5 to 10 past customers a week.
Risk: Low. You're reaching out to people who already know you. The worst that happens is they say no thanks. The best case is you book 20% of the people you contact, which is typical.
Where to start
- Export your customer list from your invoicing system or CRM into a spreadsheet. Add columns for service type, date, and total spend. Spend 30 minutes sorting by service type to see which ones repeat most often and when.
- Pick one service type—the one your customers need most often or the one with the biggest time gap between purchases. Write down the typical timeline ("Most clients need this again after 18 months") and the problem they're usually solving the second time around.
- Draft three short messages (50 to 100 words each) that you'd send to a past customer in that category. Imagine you're texting a friendly past client, not writing a sales email. Read them out loud. If they sound like you, you're ready to start reaching out.


