Generate a prospect list from your ideal customer profile
- Level Beginner
- Setup~30 min (estimated)
- Evidence Anecdotal
- CostNot stated in source
- No-codeYes
What they did
A media company trained a Zapier agent on its target advertiser personas. The agent searches the web for matching companies and contacts and drops them into Google Sheets, ready for review or for import into Salesforce or Instantly.
How it went
The company reports more than 2,000 qualified leads in one month from a single agent and a response rate near 50% on cold email.
Worth knowing
- Vendor case study; figures are the customer's.
- Check that contacts are real and that you have a lawful basis to email them.
Prompt
Cleaned version rewritten from the source — not a direct quote.
Using this ideal customer profile [paste], find [50] companies that match and the right contact at each. Put name, title, company, website, source link and a one-line reason they fit into [Google Sheet]. Skip anyone already in the sheet.
Recommended
Try it in Grok Bot
- Copy the prompt (button below).
- Open Grok Bot chat and paste it. Replace any [bracketed] placeholders.
- Connect the listed tools (Google Sheets) as connectors when Grok Bot asks.
- If the task repeats, ask: "Make this a daily routine."
Alternatives: the same prompt works in Zapier Agents, Claude, ChatGPT Agent, OpenClaw.
Set it up
Tools: Google Sheets · Stack: Zapier Agents + Google Sheets
- Read the original source for full context.
- Connect the tools your agent needs.
- Paste the prompt and replace [bracketed] placeholders.
- Run once manually and check the output before scheduling it.
Generic suggested steps, not from the source.
Evidence
Vendor case study; figures are the customer's. Check that contacts are real and that you have a lawful basis to email them
Source: Web · Verified by us: not yet · Report broken or outdated