Geschäftse-Mails aus Google Maps-Listen für die Lead-Generierung extrahieren
Experte
Dies ist ein Lead Generation-Bereich Automatisierungsworkflow mit 20 Nodes. Hauptsächlich werden Code, Wait, Limit, Filter, SplitOut und andere Nodes verwendet. Extrahieren von geschäftlichen E-Mail-Adressen aus Google Maps-Listen zur Lead-Generierung
Voraussetzungen
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
- •Google Sheets API-Anmeldedaten
Verwendete Nodes (20)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"meta": {
"instanceId": "5935d23fce125caa8ab93af824f47776e317d824634bf7b68a810b49a4038f0a"
},
"nodes": [
{
"id": "f892006c-8856-4a24-8ad5-71fb19c57011",
"name": "Bei Klick auf 'Workflow testen'",
"type": "n8n-nodes-base.manualTrigger",
"notes": "Entry point — manually start the workflow via the Test button.",
"position": [
-2400,
384
],
"parameters": {},
"typeVersion": 1
},
{
"id": "202d221b-a899-455b-884f-1661496a9866",
"name": "Google Maps durchsuchen",
"type": "n8n-nodes-base.httpRequest",
"notes": "Fetches the Google Maps search results page for 'calgary dentists'.",
"position": [
-2176,
384
],
"parameters": {
"url": "https://www.google.com/maps/search/carpinteros+en+tarragona/@41.1402229,1.0832014,56063m/data=!3m1!1e3?entry=ttu&g_ep=EgoyMDI1MTAwMS4wIKXMDSoASAFQAw%3D%3D",
"options": {
"response": {
"response": {
"fullResponse": true
}
},
"allowUnauthorizedCerts": true
}
},
"typeVersion": 4.2
},
{
"id": "50bc0bec-b364-41cb-84bd-9c26f1b92b86",
"name": "URLs extrahieren",
"type": "n8n-nodes-base.code",
"notes": "Extracts all URLs from the HTML response and returns one item per URL.",
"position": [
-1952,
384
],
"parameters": {
"jsCode": "const input = $input.first().json.data\nconst regex = /https?:\\/\\/[^\\/\\s\"'>]+/g\nconst websites = input?.match?.(regex) || []\nreturn websites.map(website => ({ json: { website } }))"
},
"typeVersion": 2
},
{
"id": "65bbd225-9663-4853-82be-18ec96cd52b8",
"name": "Google URLs filtern",
"type": "n8n-nodes-base.filter",
"notes": "Removes unwanted Google-related or tracking URLs.",
"position": [
-1728,
384
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bf0a5053-9660-457c-9581-964793bb6d7d",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.website }}",
"rightValue": "schema"
},
{
"id": "9110b9e0-12aa-45cc-bde0-9eda8c10970e",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.website }}",
"rightValue": "google"
},
{
"id": "fb9b6ed6-96a5-4560-ab10-b8a4b9a61a2b",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.website }}",
"rightValue": "gg"
},
{
"id": "10500c0b-cdbd-4816-aba3-df60d69845dc",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.website }}",
"rightValue": "gstatic"
},
{
"id": "c0f78219-b32c-4483-8596-22628a28acf7",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.website }}",
"rightValue": "sentry.wixpress.com"
},
{
"id": "d162a4cf-02f3-492e-adb7-333bf6cd152b",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.website }}",
"rightValue": "sentry.io"
},
{
"id": "1e88aa52-44e3-459e-bcec-e18bd3de3d2a",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.website }}",
"rightValue": "sentry-next.wixpress.com"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a6c87588-44f9-44f3-8b61-95e27d1e4442",
"name": "Duplikate entfernen",
"type": "n8n-nodes-base.removeDuplicates",
"notes": "Removes duplicate website URLs.",
"position": [
-1504,
384
],
"parameters": {
"options": {}
},
"typeVersion": 2
},
{
"id": "902fc9fa-4908-460a-b3d5-e8396917b2fc",
"name": "Limitieren",
"type": "n8n-nodes-base.limit",
"notes": "Limits the number of websites processed per run to 10.",
"position": [
-1280,
384
],
"parameters": {
"maxItems": 100
},
"typeVersion": 1
},
{
"id": "5b49547e-f87b-4e7f-97f8-ba4e4976fb90",
"name": "Über Elemente iterieren",
"type": "n8n-nodes-base.splitInBatches",
"notes": "Processes websites one at a time (batch processing).",
"position": [
-1056,
384
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "86312345-b2e2-46cf-80bc-4836f58b9e44",
"name": "Warten1",
"type": "n8n-nodes-base.wait",
"notes": "Adds a delay between requests to avoid server blocking.",
"position": [
-832,
192
],
"webhookId": "0fe34756-6e43-4603-8891-5747a9a6500a",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "eae01ed2-f39b-443f-91a5-39a6e8d98b91",
"name": "Website durchsuchen",
"type": "n8n-nodes-base.httpRequest",
"notes": "Fetches the website HTML (does not follow redirects).",
"onError": "continueRegularOutput",
"position": [
-832,
384
],
"parameters": {
"url": "={{ $json.website }}",
"options": {
"redirect": {
"redirect": {
"followRedirects": false
}
}
}
},
"typeVersion": 4.2
},
{
"id": "b7f7a122-c882-4a58-9a80-9c94ad58b600",
"name": "Warten",
"type": "n8n-nodes-base.wait",
"notes": "Short wait before parsing to prevent hitting rate limits.",
"position": [
-608,
384
],
"webhookId": "19cc6ed4-4fe7-485b-b879-c679e4b3374d",
"parameters": {
"amount": 1
},
"typeVersion": 1.1
},
{
"id": "dbe428f8-7a47-4438-a869-9813db4d1a4e",
"name": "E-Mails extrahieren",
"type": "n8n-nodes-base.code",
"notes": "Extracts email addresses from the website HTML.",
"onError": "continueRegularOutput",
"position": [
-384,
464
],
"parameters": {
"jsCode": "const input = $input.first().json.data\nconst regex = /[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.(?!jpeg|jpg|png|gif|webp|svg)[a-zA-Z]{2,}/g\nconst emails = input?.match?.(regex) || []\nreturn { json: { emails } }"
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "c25386cf-cfd0-4546-ae30-d79c628b0415",
"name": "Leereinträge ausfiltern",
"type": "n8n-nodes-base.filter",
"notes": "Passes through only items where 'emails' exists and is not empty.",
"position": [
-608,
192
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "a6786c58-424a-409a-b87f-8a7592cb7944",
"operator": {
"type": "array",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.emails }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "6367d624-1559-40ee-8f90-9293c0ce8847",
"name": "Aufteilen",
"type": "n8n-nodes-base.splitOut",
"notes": "Splits multiple emails into separate items (one per row).",
"position": [
-384,
192
],
"parameters": {
"options": {},
"fieldToSplitOut": "emails"
},
"typeVersion": 1
},
{
"id": "5b81ce13-0e56-4aac-aaa3-91be7d9103aa",
"name": "Duplikate entfernen (2)",
"type": "n8n-nodes-base.removeDuplicates",
"notes": "Removes duplicate emails before saving.",
"position": [
-160,
192
],
"parameters": {
"options": {}
},
"typeVersion": 2
},
{
"id": "7fd76480-d159-4566-9f2c-12ee0e5797c2",
"name": "Zu Tabelle hinzufügen",
"type": "n8n-nodes-base.googleSheets",
"notes": "Appends the extracted emails into the specified Google Sheet.",
"position": [
64,
192
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "Título",
"type": "string",
"display": true,
"required": false,
"displayName": "Título",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Texto",
"type": "string",
"display": true,
"required": false,
"displayName": "Texto",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HECHO",
"type": "string",
"display": true,
"required": false,
"displayName": "HECHO",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TIKTOK",
"type": "string",
"display": true,
"required": false,
"displayName": "TIKTOK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SHORTS",
"type": "string",
"display": true,
"required": false,
"displayName": "SHORTS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Fecha",
"type": "string",
"display": true,
"required": false,
"displayName": "Fecha",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1mlBYMLXdNNp3yTVJHpt3nKgVmTUR4fi09dBpp3k41r8/edit#gid=0",
"cachedResultName": "Hoja 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1mlBYMLXdNNp3yTVJHpt3nKgVmTUR4fi09dBpp3k41r8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1mlBYMLXdNNp3yTVJHpt3nKgVmTUR4fi09dBpp3k41r8/edit?usp=drivesdk",
"cachedResultName": "ideas"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "3ATVfFLykTq2D8XH",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "b69e82bf-71b9-4fca-a086-53efd0c52ad7",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2512,
592
],
"parameters": {
"width": 272,
"height": 192,
"content": "## Manual Trigger\nStarts the workflow when you click “Test Workflow”.\nUse this to manually run the scraper whenever you need fresh results."
},
"typeVersion": 1
},
{
"id": "159c0f17-46b0-4ad1-8563-2e0bf506a164",
"name": "Haftnotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2128,
576
],
"parameters": {
"width": 304,
"height": 192,
"content": "## Scrape Google Maps + Extract URLs\nFetches the HTML from your chosen Google Maps search, then extracts all website links from the page."
},
"typeVersion": 1
},
{
"id": "5aaf7168-dc3b-4b49-a916-5e60de270f34",
"name": "Haftnotiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1648,
176
],
"parameters": {
"width": 448,
"content": "## Filter Google URLs + Remove Duplicates + Limit\nRemoves unwanted Google/tracking links, keeps only unique websites, and limits total results to 100 for safe execution."
},
"typeVersion": 1
},
{
"id": "c71740e9-a8d2-4cb2-955b-bae9f52db2ab",
"name": "Haftnotiz3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
688
],
"parameters": {
"width": 384,
"height": 112,
"content": "## Scrape Site + Extract Emails\nVisits each website, extracts visible email addresses, and prepares them for export."
},
"typeVersion": 1
},
{
"id": "164cbf16-1491-427e-b449-8921b90f78d9",
"name": "Haftnotiz4",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"width": 288,
"content": "## Add to Google Sheet\nSaves all extracted emails directly into your Google Sheet (optional step)."
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"b7f7a122-c882-4a58-9a80-9c94ad58b600": {
"main": [
[
{
"node": "dbe428f8-7a47-4438-a869-9813db4d1a4e",
"type": "main",
"index": 0
}
]
]
},
"902fc9fa-4908-460a-b3d5-e8396917b2fc": {
"main": [
[
{
"node": "5b49547e-f87b-4e7f-97f8-ba4e4976fb90",
"type": "main",
"index": 0
}
]
]
},
"86312345-b2e2-46cf-80bc-4836f58b9e44": {
"main": [
[
{
"node": "c25386cf-cfd0-4546-ae30-d79c628b0415",
"type": "main",
"index": 0
}
]
]
},
"6367d624-1559-40ee-8f90-9293c0ce8847": {
"main": [
[
{
"node": "5b81ce13-0e56-4aac-aaa3-91be7d9103aa",
"type": "main",
"index": 0
}
]
]
},
"eae01ed2-f39b-443f-91a5-39a6e8d98b91": {
"main": [
[
{
"node": "b7f7a122-c882-4a58-9a80-9c94ad58b600",
"type": "main",
"index": 0
}
]
]
},
"50bc0bec-b364-41cb-84bd-9c26f1b92b86": {
"main": [
[
{
"node": "65bbd225-9663-4853-82be-18ec96cd52b8",
"type": "main",
"index": 0
}
]
]
},
"dbe428f8-7a47-4438-a869-9813db4d1a4e": {
"main": [
[
{
"node": "5b49547e-f87b-4e7f-97f8-ba4e4976fb90",
"type": "main",
"index": 0
}
]
]
},
"5b49547e-f87b-4e7f-97f8-ba4e4976fb90": {
"main": [
[
{
"node": "86312345-b2e2-46cf-80bc-4836f58b9e44",
"type": "main",
"index": 0
}
],
[
{
"node": "eae01ed2-f39b-443f-91a5-39a6e8d98b91",
"type": "main",
"index": 0
}
]
]
},
"a6c87588-44f9-44f3-8b61-95e27d1e4442": {
"main": [
[
{
"node": "902fc9fa-4908-460a-b3d5-e8396917b2fc",
"type": "main",
"index": 0
}
]
]
},
"65bbd225-9663-4853-82be-18ec96cd52b8": {
"main": [
[
{
"node": "a6c87588-44f9-44f3-8b61-95e27d1e4442",
"type": "main",
"index": 0
}
]
]
},
"c25386cf-cfd0-4546-ae30-d79c628b0415": {
"main": [
[
{
"node": "6367d624-1559-40ee-8f90-9293c0ce8847",
"type": "main",
"index": 0
}
]
]
},
"202d221b-a899-455b-884f-1661496a9866": {
"main": [
[
{
"node": "50bc0bec-b364-41cb-84bd-9c26f1b92b86",
"type": "main",
"index": 0
}
]
]
},
"5b81ce13-0e56-4aac-aaa3-91be7d9103aa": {
"main": [
[
{
"node": "7fd76480-d159-4566-9f2c-12ee0e5797c2",
"type": "main",
"index": 0
}
]
]
},
"f892006c-8856-4a24-8ad5-71fb19c57011": {
"main": [
[
{
"node": "202d221b-a899-455b-884f-1661496a9866",
"type": "main",
"index": 0
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Experte - Lead-Generierung
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
Google Maps E-Mail-Sammler mit HTTP-Anfragen und JavaScript
Lead-Generierungssystem: von Google Maps zu E-Mail-Sammlern, exportiert zu Google Sheets
Code
Wait
Limit
+
Code
Wait
Limit
19 NodesNick Saraev
Lead-Generierung
Lead-Generierung und E-Mail-Arbeitsabläufe
Automatisierung der B2B-Lead-Generierung und E-Mail-Marketing mit Google Maps, SendGrid und KI
If
Set
Code
+
If
Set
Code
141 NodesEzema Kingsley Chibuzo
Lead-Generierung
n8n-Knoten in der visuellen Referenzbibliothek erkunden
Erkundung von n8n-Knoten in der visuellen Referenzbibliothek
If
Ftp
Set
+
If
Ftp
Set
113 NodesI versus AI
Sonstiges
Lead-Generierung mit Google Maps - AlexK1919
Potenzielle Kunden mit Google Maps generieren
If
Set
Code
+
If
Set
Code
42 NodesAlex Kim
Vertrieb
AI-Powered Lead Generation System with Email Personalization and LinkedIn
If
Code
Limit
+
If
Code
Limit
51 NodesMatthieu
Lead-Generierung
Erstellung qualifizierter Leads und Kaltakquise-Skripte mit LinkedIn, OpenAI und Sales Navigator
Erstellen Sie qualifizierte Leads und Kaltakripte mit LinkedIn, OpenAI und Sales Navigator
If
Code
Limit
+
If
Code
Limit
47 NodesMatthieu
Lead-Generierung
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes20
Kategorie1
Node-Typen11
Autor
Jose Castillo
@j4ssn3oAutomation & Growth Engineer | Founder of Automation Hub I build practical, AI-powered workflows that help creators and businesses automate daily tasks, track performance, and make smarter decisions — all without code. Passionate about turning complex systems into simple, scalable automations.
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen