This is an n8n workflow that turns Google Maps search results into a deduplicated list of leads with verified email addresses. It scrapes businesses with Apify, finds emails on their websites, checks whether those emails are deliverable, and saves the results to Google Sheets.
The workflow starts manually when you run it. It scrapes Google Maps using the search term, location, result limit and minimum review count you configure, and collects businesses that have websites. It then builds a unique list of those websites and sends them to Apify's Website Email Finder. Discovered emails are deduplicated and sent to Apify's Bulk Email Verifier.
The workflow then joins the Google Maps business data with the emails found and their verification results. It filters out duplicates and non-deliverable emails, and can optionally keep catch-all results. Rows are formatted for export and matched on email address in Google Sheets. New rows are appended and existing ones are updated.
- Platform
- n8n workflow
- Trigger
- Manual
- n8n nodes
- Manual trigger, Set, Code, Sticky note, Google Sheets, Apify (n8n-nodes-apify)
- Apify actors
- Google Maps Scraper, Website Email Finder, Bulk Email Verifier
- Configurable inputs
- Search term, location, result limit, minimum review count
- Requires
- Apify API token credential; Google Sheets OAuth credential and a target spreadsheet/sheet
- Update method
- Matches on email address; appends new rows or updates existing ones
- Sheet headers
- business, category, email, email_status, phone, website, address, rating, reviews, maps_url, email_source, found_at