Automate B2B lead generation & email campaigns with Google Maps, SendGrid & AI

📌 Overview This n8n-powered workflow automates the entire lifecycle of lead generation and email workflows/campaign. It combines six specialized workflows into one seamless system that scrapes fresh leads, sends personalized emails, tracks engagements, detects replies, classifies responses, handles follow-ups, and keeps a live CRM updated — all in one loop. Designed for B2B cold outreach and follow-up nurturing, this system integrates with Apify, Google Sheets, SendGrid, Gmail, and OpenAI for AI summarization and real-time alerts.

🧠 What It Does This workflow automates the entire lifecycle of B2B cold campaign. It: - Scrapes targeted leads directly from Google Maps (via Apify). - Extracts verified emails from business websites with anti-blocking safeguards. - Stores everything in a centralized Google Sheets CRM. - Sends personalized emails via SendGrid, with unique embedded IDs for tracking. - Tracks delivery, opens, clicks, and bounces in real time through webhook events. - Detects replies from Gmail, matches them to the right campaign stage, and updates the CRM. - Uses AI classification to label replies (Interested, Not Interested, Miscellaneous). - Routes qualified replies directly to your sales team or Slack/Telegram channel. - Automates follow-up emails (5-day & 10-day intervals) for non-responders. - Provides light analytics & reporting in Google Sheets for quick insights (with deeper logs available in SendGrid).

💡 Why This Workflow - All-in-One Solution: Instead of juggling multiple tools, this workflow handles lead gen, outreach, tracking, and CRM updates in one place. - Smart Reply Handling: Never lose a lead — every reply is tracked, classified, and routed intelligently. - Scalable & Modular: Each workflow (lead gen, email sending, webhook, replies, routing, follow-ups) can run independently or as part of the full system. - Time-Saving: Reduces manual lead collection, email follow-up, and CRM updating by 90%+. - Client-Ready: Built with reliability in mind — randomized delays, duplicate prevention, priority logic for status updates, and AI-powered classification.

👤 Who It’s For This workflow is ideal for: - Agencies running cold campaigns for clients. - B2B Businesses looking to automate lead generation and follow-ups. - Freelancers / Consultants who need a plug-and-play outreach system without expensive SaaS subscriptions. - Sales Teams that want structured, real-time leads routed directly to their inbox or Slack. - Startups who want a scalable, low-cost alternative to tools like Apollo, Firecrawl, Bright Data or Reply.io.

⚙️ How It Works 🧩 1. Lead Generation Workflow 🎯 Purpose Scrape fresh B2B leads from Google Maps, crawl their websites to extract verified email addresses, and upload structured, clean lead data into a Google Sheets CRM. 🛠 How It Works 1. User Input via Form Trigger - The workflow begins with a form asking for: - Business keyword (e.g. "Dentist") - Location (e.g. "Florida") - Lead limit (e.g. 50) 2. Scrape Google Maps via Apify - Calls the Apify Google Maps Scraper Actor - Extracts structured business data like: Business Name, Website, Phone, Category, Rating, Address.

3. Website Filtering & Normalization - Filters out businesses with no website - Cleans up URLs

4. Website Email Extraction - Sends direct HTTP GET requests to the homepage of each business - Parses the raw HTML for public-facing email addresses using regex - Implements anti-blocking techniques: - Random delays between requests - Custom headers / User-Agent spoofing - Graceful skip on failures 5. Final Filtering & Data Structuring - Keeps only businesses with a valid email address - Constructs lead objects with: Business Name, Category, Email, Website, Phone, Rating, Location.

6. Upload to Google Sheets CRM - Pushes leads to a connected Google Sheet that acts as the system’s central CRM - This CRM becomes the source for the email sending workflow