Build a Dream 100 prospect list from AI web research

You describe your ideal customer and the AI searches the web to find 100 matching prospects in Google Sheets.

How the work actually flows

A straight line.

Pattern: Sequence (1)

flowchart TD trig(("user describes ideal customer")):::human s0["turn criteria into search prompts"]:::task s1["search web for matches"]:::svc s2["reformat results into entries"]:::task s3[("add prospects to sheet")]:::store trig --> s0 s0 --> s1 s1 --> s2 s2 --> s3 out[/"sheet of 100 prospects"/]:::out pay{{"saves hours of manual research"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
A stepAn outside serviceA personA record or sheetResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
AI Agents & Autonomous SystemsAI Chatbots & AssistantsLead Generation & ProspectingSpreadsheet & Database OpsResearch & Market Intelligence
Connects
PerplexityGoogle SheetsOpenRouter

The problem it solves

Building a list of ideal prospects by hand means hours of searching, cross-checking, and copying names into a spreadsheet. Most people give up after a handful of names instead of building the full list they actually need. This does the research for you and hands you a ready-to-use list.

Who it fits

Sales teams or founders doing outbound prospecting who need a fast list of ideal-fit companies.

How it works

  1. You tell the AI agent about your business and your ideal customer
  2. It turns your criteria into specific search prompts
  3. Perplexity searches the web using those prompts to find matching companies
  4. AI reformats the results into clean entries
  5. The list is added to Google Sheets for you to review
What you get

A hundred matching prospects without searching yourself

Describe your ideal customer and a list of one hundred matching prospects appears in Google Sheets, ready for outreach.

What you get

A Google Sheet listing up to 100 prospects that match your ideal customer profile.

What you need

An OpenRouter API key, a Perplexity API key, and a Google account for Sheets.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Find and verify new sales leads automatically with AI research

AI finds companies matching your target market, then finds and verifies real contact emails for outreach.

Advanced

Track how your brand shows up in AI search results

The system asks AI search engines about your brand each day and sends your team a graded visibility report.

Advanced

Turn real customer complaints from Reddit into LinkedIn posts

Finds real business problems people post about on Reddit and turns them into LinkedIn content that shows you understand the problem.

Advanced

Create personalized outreach videos and voice notes for new leads

Researches each new lead, then creates a personalized outreach video, voice note and email automatically.

Advanced
Back to the AI Playbook