Google Maps Lead Gen: Apify Scraping & Email Extraction to Airtable

This n8n workflow automates B2B lead generation by pulling business data from Google Maps via Apify actors. It starts with a form trigger for keyword, location, and lead count inputs, then scrapes detailed business info including websites. Next, it performs lightweight HTTP requests to those sites, rotating user-agents and adding randomized delays to mimic human behavior and evade detection.

Websites are converted from HTML to Markdown for efficient processing, followed by intelligent email extraction that identifies valid addresses. The workflow refines URLs by stripping only query parameters and fragments, preserving paths like social links. This ensures reliable data collection without heavy crawlers or external APIs.

Benefits include stealthy, scalable scraping that's resilient to rate limits and IP bans, delivering actionable leads with emails ready for outreach. Ideal for freelancers, marketers, and small teams targeting niche B2B prospects. Outputs integrate seamlessly with Airtable, Google Sheets, or any CRM for streamlined follow-up.

Perfect for low-footprint automation that saves hours on manual research, enabling focused sales efforts with high-quality, verified contact data.