Use this powerful n8n workflow template to automatically scrape business emails from Google Maps search results based on custom queries and save them directly to Google Sheets.
Download this n8n workflow template and start using it instantly.
This solution provides a robust, self-hosted method for high-volume lead generation directly from Google Maps, bypassing the need for expensive third-party APIs. This advanced n8n workflow template utilizes recursive execution and sophisticated regex patterns within several n8n node components to systematically search Google Maps based on a list of queries, extract corresponding website URLs, visit those websites, and finally scrape publicly listed email addresses. The extracted data is cleaned, de-duplicated, and automatically saved to a Google Sheet, offering a powerful, customized data pipeline built entirely within n8n.
This complex n8n workflow operates in two main phases: a primary execution loop and a recursive scraping loop.
Manual Trigger: The primary n8n trigger starting the execution, containing the list of search queries.
Execute Workflow n8n node: Facilitates running the scraper logic recursively for each query, essential for managing parallel batch execution within this n8n workflow.
Wait n8n node: Introduces a 2-second delay between starting each query's scraping job, crucial for maintaining stability and avoiding external rate limits.
HTTP Request n8n node (Search Google Maps): Performs the initial search query against the Google Maps URL to retrieve the HTML results.
Code n8n node (Scrape URLs from results): Uses custom JavaScript and regex to extract primary domain URLs from the raw Google Maps search HTML.
Filter n8n node (Filter irrelevant URLs): Cleans the extracted URL list, removing generic hostnames (e.g., google, wix) using specific regex patterns.
HTTP Request n8n node (Request web page for URL): Fetches the content of each specific business website, configured to continue output even if a request fails (onError: continueRegularOutput).
Code n8n node (Scrape emails from page): Extracts valid email patterns from the website content using advanced email regex.
Remove Duplicates n8n node: Used twice in the n8n workflow to ensure both the list of URLs and the final list of emails are unique.
Google Sheets n8n node: The final output n8n node, configured to append the clean, validated email leads into a designated spreadsheet.
Use this powerful n8n workflow to scrape complex web pages, clean HTML, and use Google Gemini to generate custom Cheerio.js extraction code for structured JSON output. Deploy this advanced n8n automation today.

Scrape websites and run advanced custom analysis prompts using this powerful n8n workflow. Integrate Apify scraping data with Gemini via OpenRouter to get structured results.

Use this powerful n8n workflow to scrape Amazon product details via Decodo, leverage OpenAI for competitive analysis and structured insights, and automatically log the findings to Google Sheets.

Automate seamless web scraping using this powerful n8n workflow template. Bypass anti-bot systems with Scrappey, starting from an n8n trigger and handling test data input.

Automate pre-call research using this powerful n8n workflow. Scrape the latest company news based on your Google Calendar entries and receive a formatted email digest daily. Download this n8n template for sales enablement.

n8n Automation Freelancer ------------------------ Contact me at: [email protected]







































