Prospect research to outreach drafts
A workflow we use: find businesses, look for evidence of a problem, log it in a spreadsheet, and draft personal emails for a person to review.
https://innervault.aetherai.pro/library/r/workflow-prospect-research
Before you use it
- This is how we work, not a promise of replies or sales. Collect only public business information and follow spam and privacy law where you and they are. The full walkthrough is inside InnerVault.
What it is
Workflows from InnerVault. Good for:
- Find clients who have a problem you can fix
- Do outreach that's specific instead of spammy
Level: builder
Steps
- Pick one kind of business and one area to focus on.
- Use a scraper (for example the Apify MCP server) to collect public listings: name, website, reviews.
- For each business, run the "Diagnose a business from its website" prompt and note the evidence.
- Log everything in a Google Sheet: business, problem, evidence, confidence.
- Draft an email for the strongest leads with the "personal outreach" prompt and save them as Gmail drafts.
- Read, edit and send each email yourself. Nothing goes out automatically.
How to get it
Setup steps: not provided by the source. Follow the instructions on the source.
Uses
-
Apify MCP server
MCP serversLets an agent run Apify's ready-made scrapers to pull data from websites, search engines, maps and social platforms.
-
Turns a company's website text into a short list of problems you can see evidence for, what each might cost, and the one fix worth raising first.
-
Google Sheets API
Public APIsRead and write Google Sheets from code. A spreadsheet is often all the database a small workflow needs.
-
Writes a short first email built on one specific thing you noticed about the business, for you to check and send yourself.
-
Gmail API
Public APIsRead, draft and send Gmail messages from your own code or automations.
Related
-
n8n
WorkflowsVisual workflow automation with built-in AI steps. Use their cloud or host it yourself.
docker run -it --rm --name n8n -p 5678:5678 -v n8n_data:/home/node/.n8n docker.n8n.io/n8nio/n8n