How to keep your customer list
Your customer list is the most valuable thing the business owns and it's usually scattered across your phone, WhatsApp and your memory. Putting it in a free spreadsheet, with seven columns, turns that mess into the cheapest source of work you'll ever have: people who already paid you once and don't need convincing. You don't need a $50-a-month CRM until somebody is using one every day.
Updated 2026-08-16
Why it matters this much
Getting a new customer costs money: ads, time, quotes that don't close.
Writing to someone who already paid you costs one message.
And yet almost every small business spends on the first and skips the second, because the numbers aren't written down anywhere.
That list is also genuinely yours. Followers belong to Instagram, rankings belong to Google, but the list goes with you wherever you go.
The seven columns
This is enough. Anything more stops getting filled in after two weeks.
| Column | What it's for |
|---|---|
| Name | Obvious |
| Phone | The WhatsApp one |
| What you did | "Water heater replacement," "color and cut" |
| When | The date |
| What you charged | To know who's a good customer |
| Area | To group routes and see where work comes from |
| When to write again | The column that makes money |
That last one is what turns a dead list into a source of work.
Where to keep it
**Google Sheets.** Free, opens on your phone, and survives a broken handset. It's what I'd recommend for almost everyone.
**Google Contacts**, if you'd rather have it in your phone's address book, with labels.
What doesn't work is keeping it only in WhatsApp: you can't sort it, you can't filter it, and the day you change phones it gets complicated.
How to fill it without dreading it
The trick is doing it in the moment, not "later."
When the job ends, with the customer in front of you and while they pay, two minutes on your phone. If you leave it to the end of the day, it doesn't happen.
And if you've been working for years without a list: don't try to reconstruct all of it. Start with today, and add the old ones during dead time.
How to use it to sell
This is the whole point. Three uses, in order of return:
**1. The trade's reminder cycle.** Every trade has one: a water heater lasts eight years, color is five weeks, AC gets checked before summer, roofs get inspected yearly. Putting that date in the "write again" column and honoring it is work that appears on its own.
**2. Quotes that didn't close.** The person who said you were expensive in March has a different need in October. Write to them at six months.
**3. The seasonal heads-up.** Before summer to the AC customers, before the rains to the roofing ones, before the holidays to the cleaning ones. One message to fifty people who already know you beats any campaign.
The message that works
Short, personal, with a real reason:
"Hi Luis, it's Samuel, I installed your water heater back in 2018. It's at the age where they start to fail. Happy to come check it, no charge."
What makes it work is that it's true and it's useful. It isn't a promotion, it's a heads-up.
When a paid CRM does make sense
When you have somebody answering the phone all day, several technicians in the field, or more than five hundred active customers. There a sheet runs out of room.
Before that, a CRM is an expense and an excuse not to do what actually works, which is writing things down and following up.
doubts
What people usually ask
What about privacy laws?
Keeping your own customers' details for your own business is normal. What needs care is mass marketing: always leave a way to say they don't want more messages, and honor it.
How often can I write without being annoying?
Two or three times a year per customer is plenty, always with a real reason. What's annoying isn't the frequency, it's writing with nothing to say.
Should I keep the ones who didn't hire me?
Especially those. You already know what they needed and what you quoted, and your competition doesn't have that.
Is it useful for asking for reviews?
It's one of the best uses: filter the happy ones who never left a review and ask them one by one.
What if I have employees?
Then the sheet has to be shared, not on one person's phone. Google Sheets already does that for free, with per-person permissions.