Búsqueda de correos electrónicos basado en el nombre de la empresa con Anymail Finder
Intermedio
Este es unLead Generationflujo de automatización del dominio deautomatización que contiene 12 nodos.Utiliza principalmente nodos como Switch, Telegram, HttpRequest, GoogleSheets, ManualTrigger. Automatización del descubrimiento de correos empresariales con Anymail Finder, Google Sheets y recordatorios de Telegram
Requisitos previos
- •Bot Token de Telegram
- •Pueden requerirse credenciales de autenticación para la API de destino
- •Credenciales de API de Google Sheets
Nodos utilizados (12)
Categoría
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
"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": "Activador Manual",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-704,
-448
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1eb2df5c-ad7f-43c7-bb51-26cac9111075",
"name": "Obtener Leads",
"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": "Bucle sobre Elementos",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-288,
-448
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "a6da4992-d53b-4e09-9deb-4ce0aeaa79fe",
"name": "Nota Adhesiva",
"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": "Selector",
"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": "Correo encontrado",
"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": "Correo no encontrado",
"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": "Nota Adhesiva1",
"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": "Nota Adhesiva2",
"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": "Buscador de Correos",
"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": "Nota Adhesiva3",
"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": "Enviar Alerta",
"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
}
]
]
}
}
}Preguntas frecuentes
¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Intermedio - Generación de leads
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
Importador de Productos WooCommerce con IA y SEO
Importador de productos WooCommerce impulsado por IA basado en Hojas de Cálculo de Google, incluye metadatos SEO de Yoast
Code
Telegram
Woo Commerce
+
Code
Telegram
Woo Commerce
16 NodosDavide
Ventas
Generar preguntas de examen
Generación automática de preguntas y respuestas para exámenes impulsada por IA, basada en documentos de Google y Gemini
Code
Google Docs
Http Request
+
Code
Google Docs
Http Request
37 NodosDavide
Otros
Prueba virtual de IA para Nano Banana de WooCommerce
Usar Fal.ai Nano Banana para generar automáticamente imágenes de prueba de vestuario virtual AI para WooCommerce
If
Set
Wait
+
If
Set
Wait
20 NodosDavide
Creación de contenido
Desarrollo de leads y flujos de correo electrónico
Usar Google Maps, SendGrid e IA para automatizar el desarrollo de leads B2B y el marketing por correo electrónico
If
Set
Code
+
If
Set
Code
141 NodosEzema Kingsley Chibuzo
Generación de leads
Eliminación de fondo de las imágenes de productos de WooCommerce
Automatización de eliminación de fondo de imágenes de productos de WooCommerce con API y Google Sheet
Ftp
Set
Code
+
Ftp
Set
Code
12 NodosDavide
Diseño
Conversión de imágenes de JPG/PNG a WebP
Optimización automática de imágenes con APYHub y Google Drive: conversión de JPG/PNG a WebP
Set
Code
Switch
+
Set
Code
Switch
12 NodosDavide
Otros
Información del flujo de trabajo
Nivel de dificultad
Intermedio
Número de nodos12
Categoría1
Tipos de nodos7
Descripción de la dificultad
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
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo