Stop copying emails by hand. Use Google Maps searches to build a clean email list in Google Sheets. Ideal for small teams, agencies, and founders who want more local leads without manual research.

The flow runs from a manual start and then spins up a background scraper for each search query. It opens Google Maps search results, pulls website URLs with a code parser, filters out irrelevant links, and removes duplicates. For each site, it fetches the page and scans for email addresses using a regex that ignores image file matches. It aggregates all emails, splits them into rows, removes duplicates again, filters out bad addresses, and appends clean data to a Google Sheet. A wait step controls pacing between queries.

You only need a Google Sheets account and a prepared list of search queries. Set your Sheet and tab in the Google Sheets node, adjust the optional filters if needed, and choose the delay between runs. Expect a growing sheet of valid emails that can power outreach, list building, and local prospecting. This setup saves hours each week, keeps data tidy, and scales with as many queries as you provide.

• Manual start to run lists of search queries on demand
• Background execution for each query using Execute Workflow to scale processing
• HTTP requests pull Google Maps search result pages for each query
• Code parser extracts website domains from result pages using a URL regex
• URL filtering and de duplication remove social links and repeat sites
• Web page requests fetch each business site and scan content for emails
• Email extraction uses a regex that avoids image file matches
• Aggregation, split out, and final filters clean and structure the email list
• Google Sheets append writes each clean email to your chosen sheet
• Wait control adds a delay between query runs to reduce blocking

• Reduce manual prospecting from hours to minutes by automating Google Maps searches and email capture
• Eliminate duplicate contacts with built in de duplication on URLs and emails
• Cut bounce risk by filtering out bad or irrelevant email formats before saving
• Handle many queries safely with controlled delays between each run
• Send results straight to Google Sheets for instant use by your team

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. Open the Google Sheets node and set your target spreadsheet and sheet tab. If the credential is missing, click Create new credential, name it clearly, and follow the on screen steps to connect your Google account.
4. Open the Manual Trigger area and prepare your list of search queries. Each query should represent a market segment or city, such as plumbers in Austin.
5. In the Execute Workflow node, confirm it is set to run for each query and leave wait for sub workflow disabled to allow background execution.
6. Check the Wait node and adjust the delay between query runs if needed. The default is 2 seconds.
7. Open the Filter irrelevant URLs node and review the rules. Add patterns for links you want to skip, such as social profiles or map links.
8. Open the Filter irrelevant emails node to refine which addresses are allowed. Add or edit patterns to exclude generic or invalid emails if needed.
9. Run a small test with one or two queries. Watch All executions to see the background runs. Confirm that emails appear in your Google Sheet.
10. If pages fail to load or you see empty results, increase the wait time and retry a smaller batch of queries. Review the URL filter settings to ensure you are not excluding valid sites.
11. Once validated, paste your full list of queries and start the run. Monitor the sheet and executions for progress and errors.