Local Lead Finder + Cold Email Sender (Form → Apify → AI → Gmail + Google Sheets)
Fill a short form with business type, location, and how many leads you want.
This workflow finds local businesses, grabs a valid email from each website, writes a cold email in your chosen style, sends it, and logs everything to Google Sheets.
Benefits
- Simple form input (business type, location, lead count, email style)
- Finds local businesses with Apify and filters only those with a website
- Scrapes one best email address from each site
- Writes cold emails with AI (style: Friendly / Professional / Simple)
- Sends via Gmail and updates Google Sheets with status + send time
How It Works
- Form Submit: Enter Business Type, Location, Lead Number, Email Style.
- Find Leads (Apify): Search places in the target location (up to your lead count).
- Filter: Keep only results that include a website.
- Extract Email (AI): Visit the website and pull one valid email address.
- Save Lead (Sheets): Add company name, category, website, phone, address, email.
- Generate Email (AI): Create subject + body using your selected style.
- Send (Gmail): Email the scraped address; retry-safe.
- Log Result (Sheets): Mark “Cold Mail Status = ✅” and add send time.
- Batching/Wait: Process leads one by one with a short wait to avoid limits.
Who Is This For
- Agencies doing local outreach
- Freelancers offering lead gen services
- SMBs testing cold email in a city or niche
Setup
- Connect the built-in Form Trigger (use provided fields)
- Add Apify actor endpoint + token
- Add Google Gemini (for email extraction) and OpenAI (for email writing) keys
- Connect Gmail OAuth2 to send emails
- Connect Google Sheets (Spreadsheet ID + Sheet1)
ROI & Monetization
- Spin up targeted campaigns in minutes (no manual research)
- Sell as a local lead-gen + outreach package ($500–$2k/campaign)
- Reuse the form for any niche and city to scale quickly
Strategy Insights
In the full walkthrough, I show how to:
- Tune the Apify search for better niches and categories
- Improve email extraction prompts for higher-quality addresses
- Adjust templates for short, compliant cold emails
- Add fallbacks (no email → skip or save for manual review)
Check Out My Channel
For more AI outreach workflows that get real results, check out my YouTube channel where I share the exact setups I use to win clients and scale to $20k+ monthly revenue.