How to Build a Prospect List in an Afternoon, No Scraping

You need a list of companies to contact this week. Doing it by hand means Googling each one and pasting facts into a spreadsheet. The other choice is a scraper or a data tool that takes a day to set up. Here's how to build a prospect list faster. Write one sentence about who you sell to. Pick the five or six facts you need about each company. Then have each row researched on the web, not copied by hand. In Autofill, you type that sentence, Autofill suggests the columns, and it fills each row while you do something else.

What a prospect list is (and what it isn't)

A prospect list is a short list of companies that fit your ideal customer profile, plus the people at those companies who are most likely to buy. SalesIntel defines it about the same way. The key word is "fit." Thousands of scraped emails is not a prospect list. A good list is one where you can say why each row is on it.

That's why most good guides start with the same step: define your ideal customer profile first, so you know which businesses you're looking for. The rest of the work is collecting facts about each one, and that part takes the hours.

Step 1: Write your ideal customer in one sentence

Skip the ten-page persona doc. You need one sentence that a smart intern could act on:

• "Specialty coffee roasters in Portland that sell wholesale"
• "Dental clinics in Austin with online booking"
• "Seed-stage HR software companies in Ohio"

Good sentences include a type of business, a place or market, and one sign of fit, like "sells wholesale" or "has online booking." That sign of fit is what turns a phone book into a prospect list.

Step 2: Pick the columns before you look up anything

Decide what you need to know about each company before you research the first one. If you add columns halfway through, you end up revisiting every company. Nimble's guide suggests a simple set: company name, website, industry, a short note on why it's a good fit, where the contact info came from, and a status column.

For outbound, a set like this works well:

Keep it to what you'll actually use in the first message. If you won't use a column, you don't need it.

Step 3: Fill the rows (this is where the afternoon goes)

By hand, every row takes the same steps: search, open the site, find the About page, look up the owner, and copy five things into five cells. Thirty companies take most of a day. Scrapers and data vendors are faster, but they come with setup, upkeep, and often stale data.

Autofill handles this step for you. Here's the same list built in Autofill:

1. Describe the list. From Your sheets, start a new sheet and type something like "Portland coffee roasters that sell wholesale: name, website, owner, wholesale program, recent news."
2. Check the proposed columns. Autofill suggests a sheet with columns. Rename or drop any you don't need before you spend anything.
3. Let it find the rows. When you create the sheet, choose Parallel and Autofill finds the companies too, not just facts about companies you already listed. If you already have a list, paste your companies in instead.
4. Fill. Autofill researches each row on the web and fills cells as it finds answers. A progress strip above the sheet shows the run. If the results look wrong, press Stop to end the run.
5. Ask for changes. Open the Assistant panel on the right and ask for what you need, like a new column for "uses Shopify?" or a tighter fit rule.

None of this is scraping in the usual sense. You don't write selectors, rotate proxies, or keep a script running. Autofill does the research one row at a time, much like you would, only faster.

Step 4: Spot-check before you send anything

AI research is fast, but it isn't perfect. Before your first email goes out, open five random rows and check the decision maker and the fit signal against the company's own website. If one column keeps coming back wrong, change the prompt for that column and fill it again rather than fixing every cell by hand. Treat the sheet as a researched first draft that you approve.

Cost matters here too. Autofill shows your usage to a tenth of a credit, and the Usage page breaks down spending by sheet. You can see what this list cost before you build the next one.

Step 5: Take it where you sell

A list only helps once you start contacting people. Download the sheet as CSV or Excel and import it into your CRM or email tool. If you run scripts or AI agents, they can read the sheet through Autofill's REST API or MCP server. Setup is on the developer docs. Share a read-only link with a cofounder or client so they can review the list before you start.

Prospect lists go stale, so plan to refresh yours. New companies open, and owners change. You can set a sheet to refresh in Autofill, so new rows show up without redoing the research.

When Autofill isn't the right tool

Autofill is a research sheet, not a contact database or an email verifier. If your outreach depends on verified direct emails and phone numbers at scale, keep a dedicated contact-data provider for that step. Autofill can still handle the research about each company before you look up contacts. If your team already runs complex multi-step enrichment workflows in Clay, those workflows may serve you better than a sentence. Autofill suits founders, solo sellers, and small agencies who need a good list this week and don't want to build a workflow first.

If you mainly want to add facts to a list of companies you already have, see how to enrich a company list with AI. For other kinds of tables, see the AI table generator guide.

Questions

What is the best way to prospect?

Start with a narrow ideal customer profile, build a short list where each row has a reason to be there, and open every message with something specific to that company. Fewer, better-researched rows beat a big list. Autofill fills a "something to mention" column for every row.

What is a prospect in Salesforce?

It depends on which Salesforce product you mean. Salesforce's own blog says a prospect is "a lead who has been qualified", meaning a lead judged more likely to buy. In Account Engagement (formerly Pardot), though, every person record is called a "prospect", which often confuses new users.

What is the meaning of prospect list?

It's a list of potential customers your team plans to contact, nurture, and turn into paying clients, as Cognism puts it. In practice, it's a sheet of companies that fit your ideal customer profile, with the right contact and the facts you'll use to reach out.

What is the 3 3 3 rule in sales?

It's a follow-up habit, and people describe it in different ways. One common version is three follow-ups, in three different ways, over three days. Another spreads three calls, three emails, and three social touches over three weeks. Either way, it only works if the list behind it is well researched.

Can I add my own companies instead of having it find them?

Yes. Paste in the companies you already have and fill the columns you need. Or choose Parallel when you create the sheet and Autofill finds the rows for you.