自动化潜在客户生成与冷邮件工作流（AI + Telegram + Google Sheets 跟踪）
高级
这是一个自动化工作流，包含 22 个节点。主要使用 If, Set, Wait, Gmail, Filter 等节点。 使用OpenAI、Apify、Gmail和Telegram的自动化B2B潜在客户生成与冷邮件
前置要求
- •Google 账号和 Gmail API 凭证
- •Telegram Bot Token
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (22)
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "SGeX0P1dV45h4WOd",
"meta": {
"instanceId": "2dca1134465d0cbe3b05a9f076a75e14b91f343a2d1220d75eced3ee8dbe57ba"
},
"name": "自动化潜在客户生成与冷邮件工作流（AI + Telegram + Google Sheets 跟踪）",
"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": "发送短信",
"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": "在表格中添加行",
"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": "如果",
"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": "筛选",
"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": "在表格中追加或更新行",
"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": "发送消息",
"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": "获取简报",
"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": "OpenAI 聊天模型1",
"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": "信息提取器1",
"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": "等待",
"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": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-672,
288
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "ac4d2d4d-ac22-4ced-8bf4-f57003e0a2ee",
"name": "OpenAI Chat Model",
"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": "信息提取器",
"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": "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": "表单提交时",
"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": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-592,
-320
],
"parameters": {
"width": 384,
"height": 336,
"content": "## 步骤 2"
},
"typeVersion": 1
},
{
"id": "d4a85604-bfcb-4d98-a346-89977ce61db5",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1040,
-512
],
"parameters": {
"width": 320,
"height": 320,
"content": "## 步骤 1"
},
"typeVersion": 1
},
{
"id": "65445276-a992-4515-a9c1-84fe84e4f141",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-112,
-416
],
"parameters": {
"width": 400,
"height": 480,
"content": "## 步骤 3"
},
"typeVersion": 1
},
{
"id": "07f3e732-16f2-4133-87d9-e33a6a2006aa",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
352,
-368
],
"parameters": {
"width": 432,
"height": 480,
"content": "## 步骤 4"
},
"typeVersion": 1
},
{
"id": "9a59a5e5-9a74-4fd0-bcb6-9660b4b06b97",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-688,
160
],
"parameters": {
"width": 976,
"height": 432,
"content": "## 步骤 5"
},
"typeVersion": 1
},
{
"id": "c251a56e-1419-46f2-8561-ef2f13e07aa4",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
336,
480
],
"parameters": {
"width": 416,
"height": 272,
"content": "## 步骤 6.2"
},
"typeVersion": 1
},
{
"id": "f29a55af-00d0-42f8-b3ea-ecd0c958ce55",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
336,
160
],
"parameters": {
"width": 400,
"height": 304,
"content": "## 步骤 6.1"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"On form submission": [
{
"json": {}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "71475201-f82e-48de-a606-8772aba1bc49",
"connections": {
"If": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Information Extractor1",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "Information Extractor",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Send a message",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Send a message": {
"main": [
[
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
},
{
"node": "Send a text message",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Information Extractor",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Information Extractor1",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Append row in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Information Extractor": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Information Extractor1": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Append or update row in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AI潜在客户挖掘智能体
使用Apify、AI和Gmail的自动化潜在客户生成与冷邮件发送
If
Set
Wait
+11
20 节点Rakin Jakaria
潜在客户开发
自动化本地线索查找与冷邮件发送
使用 Apify、AI 和 Gmail 自动查找本地线索并发送冷邮件
If
Set
Wait
+10
18 节点Meak
内容创作
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
If
Set
Code
+21
40 节点Immanuel
人工智能
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
工作流信息
难度等级
高级
节点数量22
分类-
节点类型13
作者
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.
外部链接
在 n8n.io 查看 →
分享此工作流