Trouver des adresses e-mail par nom d'entreprise avec Anymail Finder
Intermédiaire
Ceci est unLead Generationworkflow d'automatisation du domainecontenant 12 nœuds.Utilise principalement des nœuds comme Switch, Telegram, HttpRequest, GoogleSheets, ManualTrigger. Automatisation de la découverte des e-mails d'entreprise via Anymail Finder, Google Sheets et les alertes Telegram
Prérequis
- •Token Bot Telegram
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
Nœuds utilisés (12)
Catégorie
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"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": "Déclencheur Manuel",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-704,
-448
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1eb2df5c-ad7f-43c7-bb51-26cac9111075",
"name": "Obtenir les Prospects",
"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": "Boucle sur les Éléments",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-288,
-448
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "a6da4992-d53b-4e09-9deb-4ce0aeaa79fe",
"name": "Note Adhésive",
"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": "Commutateur",
"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": "Email trouvé",
"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": "Email non trouvé",
"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": "Note Adhésive1",
"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": "Note Adhésive2",
"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": "Email 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": "Note Adhésive3",
"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": "Envoyer une Alerte",
"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
}
]
]
}
}
}Foire aux questions
Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Intermédiaire - Génération de leads
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Importateur de produits WooCommerce piloté par l'IA avec SEO
Importateur de produits WooCommerce piloté par l'IA basé sur Google Sheets, incluant les métadonnées SEO Yoast
Code
Telegram
Woo Commerce
+
Code
Telegram
Woo Commerce
16 NœudsDavide
Ventes
Génération de questions d'examen
Génération automatique de questions d'examen et de réponses pilotée par l'IA, basée sur Google Docs et Gemini
Code
Google Docs
Http Request
+
Code
Google Docs
Http Request
37 NœudsDavide
Autres
Essayage virtuel AI pour WooCommerce Nano Banana
Génération automatique d'images de essayage virtuel AI pour WooCommerce avec Fal.ai Nano Banana
If
Set
Wait
+
If
Set
Wait
20 NœudsDavide
Création de contenu
Prospection et workflow d'e-mails
Utiliser Google Maps, SendGrid et l'IA pour automatiser le développement de prospects B2B et le marketing par e-mail
If
Set
Code
+
If
Set
Code
141 NœudsEzema Kingsley Chibuzo
Génération de leads
Suppression d'arrière-plan des images de produits WooCommerce
Automatisation de la suppression d'arrière-plan des images de produits WooCommerce via API et Google Sheet
Ftp
Set
Code
+
Ftp
Set
Code
12 NœudsDavide
Design
Conversion d'images JPG/PNG vers WebP
Optimisation automatisée d'images avec APYHub et Google Drive : conversion JPG/PNG en WebP
Set
Code
Switch
+
Set
Code
Switch
12 NœudsDavide
Autres
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds12
Catégorie1
Types de nœuds7
Description de la difficulté
Auteur
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
Liens externes
Voir sur n8n.io →
Partager ce workflow