E-Mail-Adressen auf Basis des Firmennamens mit Anymail Finder finden
Fortgeschritten
Dies ist ein Lead Generation-Bereich Automatisierungsworkflow mit 12 Nodes. Hauptsächlich werden Switch, Telegram, HttpRequest, GoogleSheets, ManualTrigger und andere Nodes verwendet. Automatisierung der Firmene-Mail-Entdeckung mit Anymail Finder, Google Sheets und Telegram-Benachrichtigungen
Voraussetzungen
- •Telegram Bot Token
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
- •Google Sheets API-Anmeldedaten
Verwendete Nodes (12)
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
{
"id": "8WkZpiRCYlakSpNY",
"meta": {
"instanceId": "a4bfc93e975ca233ac45ed7c9227d84cf5a2329310525917adaf3312e10d5462",
"templateCredsSetupCompleted": true
},
"name": "Find email by company name with Anymail Finder",
"tags": [],
"nodes": [
{
"id": "24f96fe4-0e5f-4127-90d9-754ef254a48e",
"name": "Manueller Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-704,
-448
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1eb2df5c-ad7f-43c7-bb51-26cac9111075",
"name": "Leads abrufen",
"type": "n8n-nodes-base.googleSheets",
"position": [
-496,
-448
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupColumn": "PROCESSING"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit?usp=drivesdk",
"cachedResultName": "Find Email by Company"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "1b4cb64a-d43b-4063-8884-e163fcd93c46",
"name": "Über Elemente iterieren",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-288,
-448
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "a6da4992-d53b-4e09-9deb-4ce0aeaa79fe",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
-704
],
"parameters": {
"width": 608,
"height": 144,
"content": "- Clone this [sheet](https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit?usp=sharing)\n- Get your [Anymail Finder](https://anymailfinder.com) API Key (FREE Trial)\n- In \"Email finder\" node Create a credential named “Anymail Finder” of type HTTP Header Auth. In the “Name” field, enter \"Authorization\" and in the “Value” field, enter your Anymail Finder API key (in the format YOUR_API_KEY)"
},
"typeVersion": 1
},
{
"id": "539a8f1c-bdcd-4450-bd63-a4845063d6bf",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
272,
-464
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "valid",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e2d035e7-353e-4c3e-a82a-5ab3ad5de400",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.email_status }}",
"rightValue": "valid"
}
]
},
"renameOutput": true
},
{
"outputKey": "risky",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7440ef17-b184-49f9-bc92-0ec289e11ccf",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.email_status }}",
"rightValue": "risky"
}
]
},
"renameOutput": true
},
{
"outputKey": "not found",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7eec38fb-005c-4ea7-9b7b-2e39e0ac4156",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "6259403f-2327-438d-97e1-7b4a8a369158",
"name": "E-Mail gefunden",
"type": "n8n-nodes-base.googleSheets",
"position": [
576,
-496
],
"parameters": {
"columns": {
"value": {
"EMAIL": "={{JSON.stringify( $json.emails) }}",
"PROCESSING": "x",
"row_number": "={{ $('Loop Over Items').item.json.row_number }}"
},
"schema": [
{
"id": "COMPANY NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "COMPANY NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "WEBSITE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "WEBSITE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PROCESSING",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PROCESSING",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit?usp=drivesdk",
"cachedResultName": "Find Email by Company"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "02a1ec6c-4e58-44c5-b7ba-891e4065594d",
"name": "E-Mail nicht gefunden",
"type": "n8n-nodes-base.googleSheets",
"position": [
784,
-416
],
"parameters": {
"columns": {
"value": {
"EMAIL": "=",
"PROCESSING": "x",
"row_number": "={{ $('Loop Over Items').item.json.row_number }}"
},
"schema": [
{
"id": "COMPANY NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "COMPANY NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "WEBSITE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "WEBSITE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PROCESSING",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PROCESSING",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit?usp=drivesdk",
"cachedResultName": "Find Email by Company"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "2f24945d-a082-474b-86bf-d552f6728289",
"name": "Haftnotiz 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
-528
],
"parameters": {
"width": 224,
"height": 224,
"content": "Classify if email is valid, risky and not found."
},
"typeVersion": 1
},
{
"id": "8dad63c6-d171-4895-86f0-65e7d73f56ae",
"name": "Haftnotiz 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-48,
-528
],
"parameters": {
"width": 224,
"height": 224,
"content": "Find email"
},
"typeVersion": 1
},
{
"id": "4e1ff1f3-c0c8-406b-bd79-d008fabac373",
"name": "E-Mail-Finder",
"type": "n8n-nodes-base.httpRequest",
"notes": "This node sends the request to Anymailfinder.\nMake sure you've connected your API key in the credentials (HTTP Header Auth).",
"onError": "continueErrorOutput",
"position": [
0,
-432
],
"parameters": {
"url": "https://api.anymailfinder.com/v5.1/find-email/company",
"method": "POST",
"options": {
"timeout": 180000
},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "domain",
"value": "={{ $json[\"WEBSITE\"] }}"
},
{
"name": "company_name",
"value": "={{ $json[\"COMPANY NAME\"] }}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "h3AkgiVUAlGDw3Ec",
"name": "Anymail Finder"
}
},
"typeVersion": 4.2
},
{
"id": "3a741450-561c-49de-bb53-988b7afa2cb6",
"name": "Haftnotiz 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
-896
],
"parameters": {
"color": 3,
"width": 608,
"content": "## Find email address by company with Anymail Finder\n\nThis automation **retrieves company information** from a Google Sheet, uses the Anymail Finder API to **discover email addresses associated with each company**, and then writes the results (including the email status) back into the same Google Sheet."
},
"typeVersion": 1
},
{
"id": "2bd1b49d-7f98-4a80-aa07-48413a896ed6",
"name": "Benachrichtigung senden",
"type": "n8n-nodes-base.telegram",
"position": [
1008,
-416
],
"webhookId": "16b603d6-121f-4531-b01f-0fb8e22c06ba",
"parameters": {
"text": "Alert! Email not found",
"chatId": "XXXXXX",
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "rQ5q95W7uKesMDx4",
"name": "Telegram account Fastewb"
}
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "33bcd6d5-9863-4fcb-bae2-95cbc800c354",
"connections": {
"539a8f1c-bdcd-4450-bd63-a4845063d6bf": {
"main": [
[
{
"node": "6259403f-2327-438d-97e1-7b4a8a369158",
"type": "main",
"index": 0
}
],
[
{
"node": "6259403f-2327-438d-97e1-7b4a8a369158",
"type": "main",
"index": 0
}
],
[
{
"node": "02a1ec6c-4e58-44c5-b7ba-891e4065594d",
"type": "main",
"index": 0
}
]
]
},
"1eb2df5c-ad7f-43c7-bb51-26cac9111075": {
"main": [
[
{
"node": "1b4cb64a-d43b-4063-8884-e163fcd93c46",
"type": "main",
"index": 0
}
]
]
},
"2bd1b49d-7f98-4a80-aa07-48413a896ed6": {
"main": [
[
{
"node": "1b4cb64a-d43b-4063-8884-e163fcd93c46",
"type": "main",
"index": 0
}
]
]
},
"6259403f-2327-438d-97e1-7b4a8a369158": {
"main": [
[
{
"node": "1b4cb64a-d43b-4063-8884-e163fcd93c46",
"type": "main",
"index": 0
}
]
]
},
"4e1ff1f3-c0c8-406b-bd79-d008fabac373": {
"main": [
[
{
"node": "539a8f1c-bdcd-4450-bd63-a4845063d6bf",
"type": "main",
"index": 0
}
]
]
},
"24f96fe4-0e5f-4127-90d9-754ef254a48e": {
"main": [
[
{
"node": "1eb2df5c-ad7f-43c7-bb51-26cac9111075",
"type": "main",
"index": 0
}
]
]
},
"02a1ec6c-4e58-44c5-b7ba-891e4065594d": {
"main": [
[
{
"node": "2bd1b49d-7f98-4a80-aa07-48413a896ed6",
"type": "main",
"index": 0
}
]
]
},
"1b4cb64a-d43b-4063-8884-e163fcd93c46": {
"main": [
[],
[
{
"node": "4e1ff1f3-c0c8-406b-bd79-d008fabac373",
"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?
Fortgeschritten - 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
KI-gesteuerter WooCommerce-Produktimport mit SEO
KI-gesteuerter WooCommerce-Produktimport basierend auf Google Tabellen, inklusive Yoast SEO-Metadaten
Code
Telegram
Woo Commerce
+
Code
Telegram
Woo Commerce
16 NodesDavide
Vertrieb
Prüfungsfragen generieren
KI-gesteuerte automatische Generierung von Prüfungsfragen und Antworten basierend auf Google Docs und Gemini
Code
Google Docs
Http Request
+
Code
Google Docs
Http Request
37 NodesDavide
Sonstiges
AI-Virtuelle Anprobe für WooCommerce Nano Banana
Automatisierte Erstellung virtueller KI-Anprobierbilder für WooCommerce mit Fal.ai Nano Banana
If
Set
Wait
+
If
Set
Wait
20 NodesDavide
Content-Erstellung
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
Hintergrund aus WooCommerce-Produktbildern entfernen
Automatisiere das Entfernen von Bildhintergründen für WooCommerce-Produktbilder mit API und Google Sheet
Ftp
Set
Code
+
Ftp
Set
Code
12 NodesDavide
Design
Konvertiere Bilder von JPG/PNG zu WebP
Automatische Bildoptimierung mit APYHub und Google Drive: Konvertierung von JPG/PNG in WebP
Set
Code
Switch
+
Set
Code
Switch
12 NodesDavide
Sonstiges
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes12
Kategorie1
Node-Typen7
Autor
Davide
@n3witaliaFull-stack Web Developer based in Italy specialising in Marketing & AI-powered automations. For business enquiries, send me an email at info@n3w.it or add me on Linkedin.com/in/davideboizza
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen