You can build a usable lead list of 100 people in about four hours with a spreadsheet, a browser and a phone. Pick who belongs on it, pull names from public sources, find the decision maker at each, add an email and phone number, check them, clean the list, and send to the first 25. That's the whole method. The rest of this page is the detail.
We'll use a running example. Lena runs a small commercial cleaning company with four employees. She wants steady evening contracts with dental and medical offices in her county. Her goal for the afternoon: 100 offices on a sheet, 25 of them ready to email.
Step 1: Decide who goes on the list
Write one sentence before you open a browser. Lena's: "Practice managers or owners of dental, orthodontic and primary care offices with 2 to 15 staff in Wake County." It names a role, a business type, a size and a place. Anything that doesn't fit gets skipped without a debate.
Add one exclusion. Lena skips large hospital groups, since those buy through procurement and take a year. Exclusions save more time than inclusions. If you want help sharpening the sentence, how to find your ideal customers walks through the one-sentence test.
Step 2: Find the names from public sources
Start with the map. Search "dental office near Cary" and similar terms, zoom out, and copy business name, address, phone and website into your sheet. Then cross-check with a second source: the state dental board's license lookup, a professional association's member directory, or the county's business license list. Two sources catch offices the map misses and drop ones that closed.
Aim for volume first. Lena collects 140 offices in 90 minutes, knowing she'll lose a third before she's done. Don't research each one deeply yet. You're casting a net, and you'll refine it in the next steps. For more on where names come from without paying, see build a list without buying one and how to build a prospect list for free.
Step 3: Add the owner or decision maker
A list of businesses isn't a list of leads yet. You need a person. Open each website and look at "About", "Team", "Meet the doctors" and the footer. Small offices almost always name the owner. Write the name and title next to the business. If there's no name, check the state license lookup, which usually lists the licensee, or call and ask: "Hi, who handles the cleaning contract for the office?" The receptionist will often just tell you.
Lena finds a name for 88 of 140 offices in about an hour. She leaves the other 52 for a phone pass later. That's fine. A list with 88 named people is already worth working. How to find the decision maker at a company covers the harder cases.
Step 4: Find or verify email and phone
You've got the business phone from the map. For email, check the site's contact page, then guess the common pattern (first name at the domain, or first initial plus last name) and test it. The method, and what to do when a guess bounces, is in how to find a business owner's email address.
Never send to an address you haven't checked. Free checkers and your own eyes catch the obvious misses (typos, dead domains, role addresses like info@ that nobody reads). Bounces damage your sending reputation, and it's slow to rebuild. Lead data you can check before paying shows what to look at.
Doing steps 2 through 4 by hand is a good way to learn your market. It's also slow once you need more than a few hundred names. That's the point where Rocketship's AI worker takes over: you describe the buyer in plain English, and it finds them by name with verified contact details, instead of you copying them one at a time.
Step 5: Put it in one sheet with six columns
Keep the sheet boring. Six columns are enough:
- Business name
- Contact name and title
- Phone
- Source (where you found them)
- Status (new, emailed, replied, call booked, not now, do not contact)
Add a date column later if you want, but resist the urge to build a fifteen-column monster. Every extra column is a field you'll stop filling in by Thursday. The "source" column matters more than it looks: when a prospect asks how you got their address, you can answer honestly and specifically. The "do not contact" status matters most of all, because it's how you keep a promise.
Step 6: Remove the people you should not email
Before the first send, clean the list. Remove duplicates, anyone who's already a customer, anyone who told you no, competitors, friends, and any address that looks personal. For people covered by special rules, such as EU residents under GDPR, don't email them unless you've checked the rules. Anyone who replies "remove me" goes to "do not contact" the same day, permanently. Keep that list even if you switch tools later.
In the US, CAN-SPAM requires a truthful from line and subject, your physical address in the email, and a working way to opt out, honored within 10 business days. Build those into your template once and you don't have to think about them again.
Step 7: Start with the first 25
Don't send to all 88. Sort by fit, pick the 25 best, and send those first. Lena's email, to Dr. Imani Brooks at a dental office:
Subject: Evening cleaning for Cary Family Dental
Hi Dr. Brooks, I run Fresh Shift Cleaning. We clean medical and dental offices after hours, five nights a week, with a checklist your team can sign off each morning. If your current cleaning is working, ignore this. If you're open to a quote for your Cary office, reply with a good day for a 15-minute walkthrough. Lena Ortiz, 220 Kildaire Road, Cary.
Send 20 to 50 a day from one inbox. Follow up once after four days and once after ten. Read what comes back, and fix the email before you send the next 25. If your reply rate is low, the list or the first line is usually the problem, not the volume. After 25 sends you'll know more than any amount of planning would have told you.
Keep an honest view of what you've built, too. A finished list is a good start, but the list is not the customer. Lena's 88 names turn into maybe 5 replies and 2 walkthroughs if the email is decent. That's a perfectly good result for a first batch, and it's the reason to keep adding names every week instead of treating the afternoon as a one-time project. Block 30 minutes on Fridays to add ten more offices, call five of the 52 that had no name, and mark the status column. A list that gets tended stays accurate, and a list that doesn't goes stale in a few months as people change jobs and offices close.
You can keep running this in a spreadsheet for as long as it's working. Rocketship does the same loop on its own, with the people it finds already in your pipeline. Rocketship finds the buyers, emails them from your own Gmail, follows up, and books the meeting on its own. Plans that get you customers start at $24.99 a month (Launch), and every monthly plan starts with a 7-day free trial, card required. Answering your existing number is included; a dedicated line is $5 a month.