Extract business emails from Google Maps search results to Google Sheets
Ready for 3.0What this workflow does
This workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fields - Set Keyword / Phrase (Edit Fields (Set)): sets 1 field: keyword
- HTTP Request: calls an HTTP API
- Code: runs custom JavaScript code
- Filter: keeps only the items that match a condition
- Remove Site Duplicates (Remove Duplicates): removes duplicate items
- Loop Websites (Loop Over Items (Split in Batches)): loops over the items in batches
- Loop Emails (Loop Over Items (Split in Batches)): loops over the items in batches
- HTTP Request: calls an HTTP API
- Aggregate: combines items into one
- Code: runs custom JavaScript code
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Filter
n8n-nodes-base.filter - Aggregate
n8n-nodes-base.aggregate - Split Out
n8n-nodes-base.splitOut - Remove Duplicates
n8n-nodes-base.removeDuplicates - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set
From the author
This workflow demonstrates how to automate the extraction of business emails from Google Maps results using a specific keyword. It streamlines the process of finding, filtering, and saving contact emails into a Google Sheet, eliminating the need for tedious…