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

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.