Back to Templates

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

Created by

Created by: Meak || meak

Meak

Last update

Last update 3 days ago

Share


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

  1. Form Submit: Enter Business Type, Location, Lead Number, Email Style.
  2. Find Leads (Apify): Search places in the target location (up to your lead count).
  3. Filter: Keep only results that include a website.
  4. Extract Email (AI): Visit the website and pull one valid email address.
  5. Save Lead (Sheets): Add company name, category, website, phone, address, email.
  6. Generate Email (AI): Create subject + body using your selected style.
  7. Send (Gmail): Email the scraped address; retry-safe.
  8. Log Result (Sheets): Mark “Cold Mail Status = ✅” and add send time.
  9. 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.