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.

Four ways to get the names, compared

MethodTime for 100 namesWhat it costsWatch out for
By hand from maps, licenses and websites (this page)About 4 hoursYour timeSlow past a few hundred names
Your own customers, partners and event lists1 hourNothingCheck what those people were told when they signed up before you send them a pitch
A data tool with a contact databaseMinutes to exportA subscription or per-contact creditsStale addresses; verify before sending
A bought list from a brokerMinutesPer name or a flat feeUnknown source, recycled to many buyers, bounces

A purchased list does not change the law. The FTC's CAN-SPAM guide says the law "makes no exception for business-to-business email," so the honest from line, the postal address and the opt-out apply to a list you bought just as they do to one you built. If you are comparing software that builds the list for you, lead generation software for small business sets out what to check.

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 salesperson 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
  • Email
  • 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.

Two optional columns earn their place later. One is a "why them" note, a few words about what you saw on their site ("opened a second location in March", "hiring a night manager"), which becomes the first line of the email. The other is a score from 1 to 3 for how well they fit your one-sentence description. Here is what three rows of Lena's sheet look like:

BusinessContactEmailSourceFitStatus
Cary Family DentalDr. Imani Brooks, ownerimani@caryfamilydental.exampleMap plus practice website3New
Apex PediatricsMaya Chen, practice managermchen@apexpeds.exampleState license lookup2Emailed Oct 6
Garner OrthodonticsNot found yetFront desk line onlyMap2Call to ask

How big does the list need to be?

Work backward from the number of customers you want. Use the ratio Lena expects from her first batch (see below): 88 named people produce about 5 replies and 2 walkthroughs. Suppose she wins one contract for every two walkthroughs, which is her guess to replace with her real number after a month. Then 88 names give her about 1 contract. To win 4 contracts she needs about 4 times as many, 352 names, which is roughly four afternoons like this one. If your first batch of 25 gets no replies, do not build 350 more names yet; fix the email, because the multiplier works the other way as well.

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, Fresh Shift Cleaning, 220 Kildaire Road, Cary, NC 27511. Reply "no thanks" and I won't write again.

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. To see your own first replies come in, begin with the trial. It is free for 7 days and takes a card.