The clients already in your phone are not on your customer list yet

Scroll back through your messages far enough and you will find them. The woman who booked three sessions in 2024 and then got busy. The eleven people from that workshop you ran above a cafe. The person who paid by bank transfer because your checkout was not ready yet. They liked your work enough to hand over money, and most of them have not heard from you since the invoice.

Why this group gets neglected

Old clients are scattered by nature. They live in your bank statements, your email archive, a booking tool you stopped paying for, a paper sign-up sheet in a drawer, and a WhatsApp thread you cannot search properly. There is no single screen showing them, so there is no moment where you notice how many there are.

There is also a social awkwardness that nobody talks about. Writing to someone after fourteen months of silence feels like an admission. You worry it reads as a sales approach, because in part it is one. That hesitation is worth naming, because it is the actual reason most of these lists never get built, and the fix is tone rather than technology.

The last difficulty is genuine and legal. People who paid you for one thing did not necessarily agree to receive marketing. Different jurisdictions treat existing customers differently, and you should check what applies where you are based before you send anything. Gathering the records is safe. Deciding what you may send is a separate judgement you have to make yourself.

Scattered records versus one list

The point of the import is not tidiness for its own sake. It is that a single list can be counted, exported, segmented and written to, whereas five partial lists can only be worried about.

The sweep, in one sitting

Set aside ninety minutes. Open a blank spreadsheet with the columns email, first name, source, first paid date and rough total spent. Then work through the sources below in order, pasting as you go. Do not clean anything until the end.

1. 1Search your email archive for the words invoice, receipt and booking confirmation, and pull every address that appears as a client rather than a supplier.
2. 2Open your bank or payment history for the past three years and match unfamiliar names back to email threads.
3. 3Export from any tool you used before: an old newsletter platform, a scheduling app, an event ticketing page. Almost all of them offer CSV export even on a cancelled free account.
4. 4Type up paper sign-up sheets and workshop registers. This is the slowest step and usually the highest quality data.
5. 5Sort the sheet by email address and delete duplicates, keeping the row with the most information.
6. 6Remove anyone who asked not to be contacted, and mark anyone whose consent status you are unsure of so you can treat them differently.
7. 7In your dashboard, open Customers and use the CSV import. Map your columns to the fields it offers, then run the import.
8. 8Send one short reconnection email to the confident portion of the list before you do anything else with it.

What a sweep usually turns up

A coach who has been working for three years might expect to find forty or fifty past clients. In practice the sweep tends to surface more, because workshop attendees and one-off buyers have been forgotten entirely. Say the total comes to 130 addresses after deduplication, of which she is comfortable contacting 95.

She writes one email: what she is doing now, one line about a new booking option, and an easy way to reply or opt out. Some will not remember her. Some will book. The realistic value is not the immediate replies, it is that 130 people who previously existed only in a bank statement are now countable, exportable and reachable next quarter too. Nothing here is a promise about revenue, only about what becomes possible once the records exist in one place.

The mistake most people make

The most common error is importing a cold list and treating it as warm. Addresses collected from a giveaway, scraped from a group, or bought from anyone at all will damage your sending reputation and irritate people who never asked for you. This guide is specifically about people who paid you or attended something of yours. That distinction is the whole point.

The second error is over-designing the first message. A plain paragraph from a person outperforms a designed template with three buttons, particularly after a long silence. Save the polished campaigns for later, and if you are on Pro you can build them with the email tools once the relationship is warm again. The FAQ covers what each plan includes.

You are not starting from zero. You are starting from a few years of people who already said yes once, currently filed in seven places. Spend one evening putting them in one place, and the rest of your audience work gets considerably easier.