Flujo de trabajo de generación de leads y frío (AI + Telegram + Google Sheets para seguimiento)
Avanzado
Este es unautomatización que contiene 22 nodos.Utiliza principalmente nodos como If, Set, Wait, Gmail, Filter. Generación automatizada de leads B2B y correos fríos, usando OpenAI, Apify, Gmail y Telegram
Requisitos previos
- •Cuenta de Google y credenciales de API de Gmail
- •Bot Token de Telegram
- •Pueden requerirse credenciales de autenticación para la API de destino
- •Credenciales de API de Google Sheets
- •Clave de API de OpenAI
Nodos utilizados (22)
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": "SGeX0P1dV45h4WOd",
"meta": {
"instanceId": "2dca1134465d0cbe3b05a9f076a75e14b91f343a2d1220d75eced3ee8dbe57ba"
},
"name": "Automated Lead Generation & Cold Email Workflow (AI + Telegram + Google Sheets Tracking)",
"tags": [
{
"id": "HHejL0bhIyOtURIl",
"name": "Custom",
"createdAt": "2025-10-16T11:07:53.098Z",
"updatedAt": "2025-10-16T11:07:53.098Z"
}
],
"nodes": [
{
"id": "76176e5d-13fa-41a9-89f6-fe3244818c76",
"name": "Enviar mensaje de texto",
"type": "n8n-nodes-base.telegram",
"position": [
384,
288
],
"webhookId": "3135f165-b6b0-467e-92e0-525ed76098b4",
"parameters": {
"text": "=✅ Cold Email sent!\n\n🔸Company Name ➡ {{ $('Loop Over Items').item.json['Company Name'] }}\n\n🔸Mail Address ➡ {{ $('Edit Fields').item.json['Email Address'] }}\n\n🔸Mail Subject ➡ {{ $('Information Extractor1').item.json.output['Mail Subject'] }}\n\n🔸Mail Body ➡ {{ $('Information Extractor1').item.json.output['Mail Body'] }}",
"additionalFields": {}
},
"typeVersion": 1.2
},
{
"id": "45dd2650-3dcf-43e3-a53d-4a96039e0c50",
"name": "Agregar fila en hoja",
"type": "n8n-nodes-base.googleSheets",
"position": [
608,
-48
],
"parameters": {
"columns": {
"value": {
"Address": "={{ $('Filter').item.json.address }}",
"Website": "={{ $('Filter').item.json.website }}",
"Category": "={{ $('Filter').item.json.categoryName }}",
"Company Name": "={{ $('Filter').item.json.title }}",
"Email Address": "={{ $json.output['Email Address'] }}",
"Phone Nummber": "={{ $('Filter').item.json.phoneUnformatted }}"
},
"schema": [
{
"id": "Company Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Category",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone Nummber",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Phone Nummber",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Cold Mail Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Cold Mail Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SEND Time",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SEND Time",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "="
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"typeVersion": 4.7
},
{
"id": "e8a9f686-d626-4891-a6ab-661d8de6ed93",
"name": "Si",
"type": "n8n-nodes-base.if",
"position": [
400,
-208
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0bef85fd-156f-476a-b7b5-86c414e37a5e",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.output['Email Address'] }}",
"rightValue": "@"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "18bf98e1-78a0-40ea-a021-caabfabf55c3",
"name": "Filtrar",
"type": "n8n-nodes-base.filter",
"position": [
-352,
-176
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "45bc2a48-a148-462a-a316-8f3dc020e567",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.website }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "c649fd90-9e3e-4e00-9bb8-30a66375af1f",
"name": "Agregar o actualizar fila en hoja",
"type": "n8n-nodes-base.googleSheets",
"position": [
384,
592
],
"parameters": {
"columns": {
"value": {
"SEND Time": "={{ $('Edit Fields').item.json['Send Time'] }}",
"Email Address": "={{ $('Edit Fields').item.json['Email Address'] }}",
"Cold Mail Status": "✅"
},
"schema": [
{
"id": "Company Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Company Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Category",
"type": "string",
"display": true,
"required": false,
"displayName": "Category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone Nummber",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone Nummber",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Address",
"type": "string",
"display": true,
"required": false,
"displayName": "Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Cold Mail Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Cold Mail Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SEND Time",
"type": "string",
"display": true,
"required": false,
"displayName": "SEND Time",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email Address"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1i2__OUxPtEQL0H7_9wByfVcXDZJliOVxT1yrj3yOfns/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": ""
}
},
"typeVersion": 4.7
},
{
"id": "b533939d-5237-45ee-ba58-98c08ff16ee8",
"name": "Enviar mensaje",
"type": "n8n-nodes-base.gmail",
"position": [
160,
304
],
"webhookId": "a540f17f-bff7-4316-908c-f91e652b632a",
"parameters": {
"sendTo": "={{ $json['Email Address'] }}",
"message": "={{ $('Information Extractor1').item.json.output['Mail Body'] }}",
"options": {},
"subject": "={{ $('Information Extractor1').item.json.output['Mail Subject'] }}",
"emailType": "text"
},
"typeVersion": 2.1
},
{
"id": "30cd146e-1275-48e7-87da-da2db976a7b4",
"name": "Editar campos",
"type": "n8n-nodes-base.set",
"position": [
-16,
304
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "e8182ef2-8755-4ff8-9ecb-4185ae782cde",
"name": "Send Time",
"type": "string",
"value": "={{$now.toFormat(\"dd-MM-yyyy (h:mm:s a)\")}}"
},
{
"id": "4b3a6df0-eebd-46db-bc18-a26f85d7fef4",
"name": "Email Address",
"type": "string",
"value": "={{ $('Wait').item.json['Email Address'] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "9d8d7555-7587-4f4b-8178-2faab50ce85f",
"name": "Modelo de chat OpenAI1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-304,
464
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": ""
},
"options": {}
},
"typeVersion": 1.2
},
{
"id": "42210a49-490c-4d6c-9171-2213e7ecb385",
"name": "Extractor de información1",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
-304,
304
],
"parameters": {
"text": "=You are a perfect cold mail generator for a Workflow Process Automation Specialist (Lead Generation) Agency named \"Your name\"\n\nHere's the Information about the Recipient:\n\nCompany Name: {{ $('Loop Over Items').item.json['Company Name'] }}\nBusiness Type: {{ $('Loop Over Items').item.json.Category }}\n\nEmail Style / Email Tune : {{ $('On form submission').item.json['Email Style'] }}\n\nThe Email style is given just to understand how the mail will be.\n\nInstructions:\n\n1. Always start with giving a greting to the Company like Hi Company Name,\n2. Always use We not I,\n3. Mail have to be professional, Clean and to the point,\n4. At last give a Signeture Like:\n\n Your Name",
"options": {},
"attributes": {
"attributes": [
{
"name": "Mail Subject",
"required": true,
"description": "Eye catchy mail Subject for the cold mail"
},
{
"name": "Mail Body",
"required": true,
"description": "=body message of the mail, a perfect and clear cold mail."
}
]
}
},
"typeVersion": 1.2
},
{
"id": "e32e288f-abb6-4cb2-ae8f-c227bb8380b7",
"name": "Esperar",
"type": "n8n-nodes-base.wait",
"position": [
-464,
304
],
"webhookId": "dafc76c4-972d-49fd-8f1a-546d7b0e9eb5",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "c1cadd00-ddff-4d37-9db2-fe4cb21b4cfe",
"name": "Iterar sobre elementos",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-672,
288
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "ac4d2d4d-ac22-4ced-8bf4-f57003e0a2ee",
"name": "Modelo de chat OpenAI",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
0,
-64
],
"parameters": {
"model": {
"__rl": true,
"mode": "id",
"value": ""
},
"options": {}
},
"typeVersion": 1.2
},
{
"id": "f01fbab3-38fb-4825-b4c4-e9a04bd8b851",
"name": "Extractor de información",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
0,
-272
],
"parameters": {
"text": "=Website: {{ $json.website }}",
"options": {},
"attributes": {
"attributes": [
{
"name": "Email Address",
"required": true,
"description": "=Find out the best only one email address from the website after scraping the website. The mail address have to be in ideal format."
}
]
}
},
"typeVersion": 1.2
},
{
"id": "8bb28604-810b-41db-afe5-b56322483f72",
"name": "Solicitud HTTP",
"type": "n8n-nodes-base.httpRequest",
"position": [
-544,
-176
],
"parameters": {
"url": "https://api.apify.com",
"options": {},
"jsonBody": "={\n \"includeWebResults\": false,\n \"language\": \"en\",\n \"locationQuery\": \"{{ $json.Location }}\",\n \"maxCrawledPlacesPerSearch\":{{ $json['Lead Number'] }} ,\n \"maxImages\": 0,\n \"maximumLeadsEnrichmentRecords\": 0,\n \"scrapeContacts\": false,\n \"scrapeDirectories\": false,\n \"scrapeImageAuthors\": false,\n \"scrapePlaceDetailPage\": false,\n \"scrapeReviewsPersonalData\": true,\n \"scrapeTableReservationProvider\": false,\n \"searchStringsArray\": [\n \"{{ $json['Business Type'] }}\"\n ],\n \"skipClosedPlaces\": false\n}",
"sendBody": true,
"specifyBody": "json"
},
"typeVersion": 4.2
},
{
"id": "150960a4-6e70-4e40-9671-e9608d890664",
"name": "Al enviar formulario",
"type": "n8n-nodes-base.formTrigger",
"position": [
-864,
-336
],
"webhookId": "26c21777-7345-4570-ac12-5703dbd11119",
"parameters": {
"options": {
"buttonLabel": "Submit GO 🚀",
"appendAttribution": false
},
"formTitle": "Lead Collect Tool",
"formFields": {
"values": [
{
"fieldLabel": "Business Type",
"placeholder": "e.g. Restaurant",
"requiredField": true
},
{
"fieldLabel": "Location",
"placeholder": "e.g. Rome, Italy",
"requiredField": true
},
{
"fieldType": "number",
"fieldLabel": "Lead Number",
"placeholder": "e.g. 5",
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Email Style",
"fieldOptions": {
"values": [
{
"option": "Friendly"
},
{
"option": "Professional"
},
{
"option": "Simple"
}
]
}
}
]
},
"formDescription": "Provide the info below..."
},
"typeVersion": 2.3
},
{
"id": "a8a4c50d-6aa1-4223-b9c5-0118b371407b",
"name": "Nota adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
-592,
-320
],
"parameters": {
"width": 384,
"height": 336,
"content": "## Step 2\nIn this step, apify searches for businesses in the relevant city based on the type and number of businesses entered on the form page. Businesses with websites pass through the filter."
},
"typeVersion": 1
},
{
"id": "d4a85604-bfcb-4d98-a346-89977ce61db5",
"name": "Nota adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1040,
-512
],
"parameters": {
"width": 320,
"height": 320,
"content": "## Step 1\nIn this step, we fill in the n8n form tool titled Lead Collect Tool with the requested information:\n1-business name\n2-number of businesses to be searched, etc."
},
"typeVersion": 1
},
{
"id": "65445276-a992-4515-a9c1-84fe84e4f141",
"name": "Nota adhesiva2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-112,
-416
],
"parameters": {
"width": 400,
"height": 480,
"content": "## Step 3\nAt this stage, the email addresses of the businesses that pass through the filter are found by AI from their own web addresses."
},
"typeVersion": 1
},
{
"id": "07f3e732-16f2-4133-87d9-e33a6a2006aa",
"name": "Nota adhesiva3",
"type": "n8n-nodes-base.stickyNote",
"position": [
352,
-368
],
"parameters": {
"width": 432,
"height": 480,
"content": "## Step 4\nIn this step, businesses with email addresses found by Open AI are recorded in Google Sheets \nwith information such as company name, email address, etc. "
},
"typeVersion": 1
},
{
"id": "9a59a5e5-9a74-4fd0-bcb6-9660b4b06b97",
"name": "Nota adhesiva4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-688,
160
],
"parameters": {
"width": 976,
"height": 432,
"content": "## Step 5\nThis step consists of a loop. In the previous steps, emails are sent to each business that has a website and email address. This email is generated by AI according to the type specified in the form at the beginning. Sometimes the email addresses found may not contain the @ sign, so the filter in the loop adjusts for this. And this loop repeats as many times as there are email addresses."
},
"typeVersion": 1
},
{
"id": "c251a56e-1419-46f2-8561-ef2f13e07aa4",
"name": "Nota adhesiva5",
"type": "n8n-nodes-base.stickyNote",
"position": [
336,
480
],
"parameters": {
"width": 416,
"height": 272,
"content": "## Step 6.2\nIn this step, the business information in the previously created Google Sheet file is updated, and the status of the cold email process is confirmed."
},
"typeVersion": 1
},
{
"id": "f29a55af-00d0-42f8-b3ea-ecd0c958ce55",
"name": "Nota adhesiva6",
"type": "n8n-nodes-base.stickyNote",
"position": [
336,
160
],
"parameters": {
"width": 400,
"height": 304,
"content": "## Step 6.1\nAt this step, the system enters a loop and sends emails assigned to each business to the designated Telegram account owner, allowing the automation owner to instantly view emails sent to businesses."
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"On form submission": [
{
"json": {}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "71475201-f82e-48de-a606-8772aba1bc49",
"connections": {
"e8a9f686-d626-4891-a6ab-661d8de6ed93": {
"main": [
[
{
"node": "45dd2650-3dcf-43e3-a53d-4a96039e0c50",
"type": "main",
"index": 0
}
]
]
},
"e32e288f-abb6-4cb2-ae8f-c227bb8380b7": {
"main": [
[
{
"node": "Information Extractor1",
"type": "main",
"index": 0
}
]
]
},
"18bf98e1-78a0-40ea-a021-caabfabf55c3": {
"main": [
[
{
"node": "Information Extractor",
"type": "main",
"index": 0
}
]
]
},
"30cd146e-1275-48e7-87da-da2db976a7b4": {
"main": [
[
{
"node": "b533939d-5237-45ee-ba58-98c08ff16ee8",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "18bf98e1-78a0-40ea-a021-caabfabf55c3",
"type": "main",
"index": 0
}
]
]
},
"b533939d-5237-45ee-ba58-98c08ff16ee8": {
"main": [
[
{
"node": "c649fd90-9e3e-4e00-9bb8-30a66375af1f",
"type": "main",
"index": 0
},
{
"node": "76176e5d-13fa-41a9-89f6-fe3244818c76",
"type": "main",
"index": 0
}
]
]
},
"c1cadd00-ddff-4d37-9db2-fe4cb21b4cfe": {
"main": [
[],
[
{
"node": "e32e288f-abb6-4cb2-ae8f-c227bb8380b7",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Information Extractor",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"150960a4-6e70-4e40-9671-e9608d890664": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Information Extractor1",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"45dd2650-3dcf-43e3-a53d-4a96039e0c50": {
"main": [
[
{
"node": "c1cadd00-ddff-4d37-9db2-fe4cb21b4cfe",
"type": "main",
"index": 0
}
]
]
},
"Information Extractor": {
"main": [
[
{
"node": "e8a9f686-d626-4891-a6ab-661d8de6ed93",
"type": "main",
"index": 0
}
]
]
},
"Information Extractor1": {
"main": [
[
{
"node": "30cd146e-1275-48e7-87da-da2db976a7b4",
"type": "main",
"index": 0
}
]
]
},
"c649fd90-9e3e-4e00-9bb8-30a66375af1f": {
"main": [
[
{
"node": "c1cadd00-ddff-4d37-9db2-fe4cb21b4cfe",
"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?
Avanzado
¿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
Agente inteligente de prospección de leads por IA
Generación automatizada de prospectos y envío de correos fríos usando Apify, AI y Gmail
If
Set
Wait
+
If
Set
Wait
20 NodosRakin Jakaria
Generación de leads
Búsqueda automatizada de prospectos locales y envío de fríos
Búsqueda automatizada de leads locales y envío de correos fríos usando Apify, IA y Gmail
If
Set
Wait
+
If
Set
Wait
18 NodosMeak
Creación de contenido
Explorar nodos de n8n en la biblioteca de referencias visuales
Explorar nodos de n8n en la base de referencia visual
If
Ftp
Set
+
If
Ftp
Set
113 NodosI versus AI
Otros
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
Automatización de publicación de contenido RSS en publicaciones de blog con GPT-4o, WordPress y LinkedIn
Usar GPT-4o, WordPress y LinkedIn para automatizar la publicación de contenido RSS en artículos de blog
If
Set
Code
+
If
Set
Code
40 NodosImmanuel
Inteligencia Artificial
WordPress Blog Automation Pro (Investigación profunda) v2.1 Marketplace
Usar GPT-4o, Perplexity AI y soporte multilingüe para automatizar la creación de blogs optimizados para SEO
If
Set
Xml
+
If
Set
Xml
125 NodosDaniel Ng
Creación de contenido
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos22
Categoría-
Tipos de nodos13
Descripción de la dificultad
Autor
Adem Tasin
@ademtasinI've been building automation workflows for over 3 years, mostly using tools like n8n, Zapier, and Make. I enjoy creating clean, reliable, and scalable automations that help small businesses and freelancers streamline their daily operations. My focus is on practical solutions — from lead tracking to API integrations — that are easy to understand and customize.
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo