Agent Circle This workflow corresponds to n8n.io template #6085 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "wbY4XFrDGp8DBQgi",
"name": "Google Maps - Crawl Email By Keyword",
"tags": [],
"nodes": [
{
"id": "59b4ce0a-ddf4-4fc4-8adc-c25aec2008d7",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-680,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7d1e4c89-b5f0-49a0-ad67-0eb89dbc0680",
"name": "Filter",
"type": "n8n-nodes-base.filter",
"position": [
280,
200
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7ecfbe72-c09a-482e-8f81-43d9e7bb2917",
"operator": {
"type": "string",
"operation": "notRegex"
},
"leftValue": "={{ $json.url }}",
"rightValue": "(google|gstatic|ggpht|schema|example)"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "dc7e6daa-0aa0-4fad-a32f-e6aa3bd905e6",
"name": "Aggregate",
"type": "n8n-nodes-base.aggregate",
"position": [
1400,
200
],
"parameters": {
"options": {
"mergeLists": true
},
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "emails"
}
]
}
},
"typeVersion": 1
},
{
"id": "0c6199c1-7272-41b6-b765-bc89e5fc4925",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"onError": "continueRegularOutput",
"position": [
1600,
200
],
"parameters": {
"options": {},
"fieldToSplitOut": "emails"
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "05de993d-c2e5-44b5-accc-afa324e90c36",
"name": "Remove Site Duplicates",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
500,
200
],
"parameters": {
"compare": "selectedFields",
"options": {},
"fieldsToCompare": "url"
},
"typeVersion": 2
},
{
"id": "f5445655-192b-493b-8bb7-2dad086133c4",
"name": "Remove Email Duplicates",
"type": "n8n-nodes-base.removeDuplicates",
"onError": "continueRegularOutput",
"position": [
1800,
200
],
"parameters": {
"compare": "selectedFields",
"options": {},
"fieldsToCompare": "emails"
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "fdf831d5-a819-413f-87e2-6d6bdba7d27a",
"name": "Google Sheets - Update Data",
"type": "n8n-nodes-base.googleSheets",
"position": [
2000,
200
],
"parameters": {
"columns": {
"value": {
"Emails": "={{ $json.emails }}",
"Keyword": "={{ $('Fields - Set Keyword / Phrase').first().json.keyword }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Emails",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Emails",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Emails"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/17y_MmRHfBbW67bVyRuep1hkpoh2BV3yF5_Woxt0W9kk/edit#gid=0",
"cachedResultName": "Emails"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "17y_MmRHfBbW67bVyRuep1hkpoh2BV3yF5_Woxt0W9kk",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/17y_MmRHfBbW67bVyRuep1hkpoh2BV3yF5_Woxt0W9kk/edit?usp=drivesdk",
"cachedResultName": "Google Maps - Crawl Email By Keyword"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.5
},
{
"id": "6483643a-ca6d-4708-aa6e-0f279aef4991",
"name": "Loop Websites",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
720,
200
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "2faaf6c1-00f1-44e8-8d84-229e85718a64",
"name": "Loop Emails",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
940,
360
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "bc5361c6-21ca-4011-97f9-313504681019",
"name": "HTTP Request - Get Emails",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
940,
0
],
"parameters": {
"url": "={{ $json.url }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "a25ea232-e3c0-4f15-a2c7-c340245eaee5",
"name": "HTTP Request - Get Sites",
"type": "n8n-nodes-base.httpRequest",
"position": [
-140,
200
],
"parameters": {
"url": "=https://www.google.com/maps/search/{{ $json.keyword }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "a9867f9c-0841-432f-b25f-b179c74819b1",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-780,
-260
],
"parameters": {
"color": 4,
"width": 600,
"height": 800,
"content": "## 1. Set The Keyword & Start The Workflow\n- A target keyword (e.g., \u201cn8n workflow\u201d) should be entered in Node **Fields - Set Keyword / Phrase**.\n- Then, the process is triggered by clicking **Test Workflow** or **Execute Workflow**.\n"
},
"typeVersion": 1
},
{
"id": "cd625a6d-a8be-4e37-b6a8-e09c2c67cbbc",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
120
],
"parameters": {
"color": 3,
"width": 300,
"height": 240,
"content": "## Change Keyword Here"
},
"typeVersion": 1
},
{
"id": "f0a61644-cc59-4938-980f-88795742d9a4",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1520,
-260
],
"parameters": {
"width": 720,
"height": 1680,
"content": "## [n8n Automation] Automated Email Extractor By Keyword From Google Maps - Try It Out!\n**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 manual research.**\n\nThis tool is perfect for those who need to collect business email addresses for outreach, research, or marketing purposes, especially those whose success depends on building and managing business relationships at scale.\n- **Sales and Lead Generation Teams**: Quickly build targeted business email lists for efficient cold outreach and follow-up.\n- **Marketing Agencies and Freelancers**: Effortlessly gather contact details for potential clients in specific niches or locations to power outreach campaigns.\n- **Recruiters and Talent Acquisition Specialists**: Easily collect company contacts to connect with HR or hiring managers in targeted industries or regions.\n- **Event Organizers and B2B Promoters**: Rapidly compile relevant business emails for event invitations, sponsorship proposals, or promotional efforts.\n- **Market Researchers and Data Analysts**: Automate large-scale collection of business emails to support industry analysis and data-driven research.\n\n## How It Works\n- A target keyword (e.g., \u201cn8n workflow\u201d) should be entered in Node **Fields - Set Keyword / Phrase**.\n- Then, the process is triggered by clicking **Test Workflow** or **Execute Workflow**.\n- The workflow queries Google Maps, collects keyword-related website URLs from its HTML, and filters for only valid website URLs.\n- Next, it removes duplicate website URLs to ensure each is processed only once later.\n- For every unique valid website URL, the workflow sends an HTTP request to extract all potential email addresses from the website\u2019s content in a loop.\n- After that, the emails are passed through another loop and a code node (**Code \u2013 Match Email**) to ensure each one is a valid, properly formatted email address (not just random text). Any invalid emails are filtered out during this step.\n- All valid emails are then collected and prepared for further processing.\n- The workflow then splits out the results and removes any duplicate emails to ensure each address appears only once.\n- Finally, the list of unique, verified emails (directly related to your chosen keyword) is saved to your connected Google Sheet for easy access and follow-up.\n\n## How To Set Up\n- Download the working package.\n- Import the package into your n8n interface.\n- Duplicate the [**Google Maps - Crawl Emails By Keyword Google Sheets template**](https://docs.google.com/spreadsheets/d/17y_MmRHfBbW67bVyRuep1hkpoh2BV3yF5_Woxt0W9kk/edit?gid=0#gid=0) into your Google Sheets account. \n- Set up necessary credentials in Google Cloud Console for Google Sheets access and usability in Node **Google Sheets - Update Data**.\n- Set up a GET method to access Google Maps in Node **HTTP Request - Get Sites**.\n- Enter your desired keyword or phrase in Node **Fields - Set Keyword / Phrase**.\n- Start the workflow in n8n.\n- Wait a few minutes for the process to finish.\n- Check the list of all valid emails related to your keyword/phrase in the connected Google Sheet.\n\n## Requirements\n- Basic setup in **Google Cloud Console** (OAuth or API Key method enabled) with enabled access to **Google Sheets**.\n- Access to **Google Maps**.\n\n## How To Customize\n- **Adjust the Keyword Input**: You can easily change the keyword or phrase you want to search for by editing the second node, **Fields \u2013 Set Keyword / Phrase**, in your n8n workflow.\n- **Add Follow-up Steps**: Modify the workflow to even trigger follow-up actions like sending emails automatically.\n## Need Help?\nIf you need a step-by-step guide to set up this workflow or want it customized for your specific business needs, feel free to reach out to [**Agent Circle**](https://www.agentcircle.ai/). We\u2019re always here to support and help you to bring automation ideas to life.\nJoin our community on different platforms for assistance, inspiration and tips from others.\nWebsite: https://www.agentcircle.ai/\nEtsy: https://www.etsy.com/shop/AgentCircle\nGumroad: http://agentcircle.gumroad.com/\nDiscord Global: https://discord.gg/d8SkCzKwnP\nFB Page Global: https://www.facebook.com/agentcircle/\nFB Group Global: https://www.facebook.com/groups/aiagentcircle/\nX: https://x.com/agent_circle\nYouTube: https://www.youtube.com/@agentcircle\nLinkedIn: https://www.linkedin.com/company/agentcircle\n\n\n\n\n\n"
},
"typeVersion": 1
},
{
"id": "352594b0-528b-45c6-a110-b38db22c716d",
"name": "Code - Matching URL",
"type": "n8n-nodes-base.code",
"position": [
80,
200
],
"parameters": {
"jsCode": "const urls = $input.first().json.data.match(/https?:\\/\\/[^\\/]+/g);\nreturn urls.map(url => ({json: {url: url}}));"
},
"typeVersion": 2
},
{
"id": "a82989e4-69c0-485e-8158-2ed201baf6f7",
"name": "Code - Match Email",
"type": "n8n-nodes-base.code",
"onError": "continueRegularOutput",
"position": [
1200,
360
],
"parameters": {
"jsCode": "const blockExtensions = [\n 'png', 'jpg', 'jpeg', 'gif', 'webp', 'svg',\n 'mp4', 'avi', 'mov', 'webm', 'mkv',\n 'js', 'css', 'json', 'ts', 'jsx', 'tsx'\n];\n\nconst regex = new RegExp(\n `[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\\\.(?!${blockExtensions.join('|')})[a-zA-Z]{2,}`,\n 'gi'\n);\n\nconst text = $input.first().json.data;\nconst emails = text.match(regex);\n\nreturn { json: { emails: emails } };"
},
"typeVersion": 2
},
{
"id": "f74128d6-40bb-4c6b-8278-90d653a495f4",
"name": "Fields - Set Keyword / Phrase",
"type": "n8n-nodes-base.set",
"position": [
-420,
200
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "0543578e-56af-4bd7-b05f-f61652f47315",
"name": "keyword",
"type": "string",
"value": "n8n workflow"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "6e41a17b-59bc-4cc0-9db0-77613e660b35",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-260
],
"parameters": {
"color": 4,
"width": 820,
"height": 800,
"content": "## 2. Collect & Filter Website URLs\n- The workflow queries Google Maps, collects keyword-related website URLs from its HTML, and filters for only valid website URLs.\n- Duplicate website URLs are removed to ensure each website is only processed once.\n"
},
"typeVersion": 1
},
{
"id": "8babfc9b-4c40-434a-8887-257e3baa7984",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
680,
-260
],
"parameters": {
"color": 4,
"width": 680,
"height": 800,
"content": "## 3. Extract & Validate Emails\n- The unique valid website URLs will be sent to a loop.\n- For each of them, the workflow sends an HTTP request to extract all potential email addresses from its website\u2019s content.\n- After that, the emails are passed through another loop (**Loop Emails**) and a code node (**Code \u2013 Match Email**) to ensure each one is a valid, properly formatted email address (not just random text). Any invalid emails are filtered out during this step."
},
"typeVersion": 1
},
{
"id": "669fcf0e-34e0-445e-8491-97ff3f493cba",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1380,
-260
],
"parameters": {
"color": 4,
"width": 780,
"height": 800,
"content": "## 4. Aggregate, Deduplicate & Save Results\n- All valid emails are collected, and duplicates are removed.\n- The final list of unique, verified emails is saved to your connected Google Sheet for easy access and follow-up.\n"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "b27f6a74-6321-4082-b1fd-c124a513b6e7",
"connections": {
"Filter": {
"main": [
[
{
"node": "Remove Site Duplicates",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Remove Email Duplicates",
"type": "main",
"index": 0
}
]
]
},
"Loop Emails": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
],
[
{
"node": "Code - Match Email",
"type": "main",
"index": 0
}
]
]
},
"Loop Websites": {
"main": [
[
{
"node": "Loop Emails",
"type": "main",
"index": 0
}
],
[
{
"node": "HTTP Request - Get Emails",
"type": "main",
"index": 0
}
]
]
},
"Code - Match Email": {
"main": [
[
{
"node": "Loop Emails",
"type": "main",
"index": 0
}
]
]
},
"Code - Matching URL": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Remove Site Duplicates": {
"main": [
[
{
"node": "Loop Websites",
"type": "main",
"index": 0
}
]
]
},
"Remove Email Duplicates": {
"main": [
[
{
"node": "Google Sheets - Update Data",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request - Get Sites": {
"main": [
[
{
"node": "Code - Matching URL",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request - Get Emails": {
"main": [
[
{
"node": "Loop Websites",
"type": "main",
"index": 0
}
]
]
},
"Fields - Set Keyword / Phrase": {
"main": [
[
{
"node": "HTTP Request - Get Sites",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Fields - Set Keyword / Phrase",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This tool is perfect for those who need to collect business email addresses for outreach, research, or marketing purposes, especially those whose success depends on building and managing business relationships at scale. Sales and Lead Generation Teams: Quickly build targeted…
Source: https://n8n.io/workflows/6085/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Automate LinkedIn lead generation by scraping comments from targeted posts and enriching profiles with detailed data
Form Trigger, HTTP Request, Google Sheets
This automated n8n workflow scrapes job listings from Upwork using Apify, processes and cleans the data, and generates daily email reports with job summaries. The system uses Google Sheets for data st
Google Sheets, HTTP Request, Gmail
Transform LinkedIn profile URLs into comprehensive enriched lead profiles, quickly and automatically.
HTTP Request, Google Sheets
Transform any website into a structured knowledge repository with this intelligent crawler that extracts hyperlinks from the homepage, intelligently filters images and content pages, and aggregates fu
HTTP Request, Google Sheets
Content creators, researchers, educators, and digital marketers who need to discover high-quality YouTube training videos on specific topics. Perfect for building curated learning resource lists, comp
HTTP Request, Google Sheets