Automated Local Lead Finder & Cold Email Sender with Apify, AI, and Gmail

Description

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.