真正能获得回复的AI驱动冷邮件开场白
高级
这是一个自动化工作流，包含 19 个节点。主要使用 If, GoogleSheets, ManualTrigger, SplitInBatches, OpenAi 等节点。 使用Perplexity研究和Claude Sonnet生成个性化冷邮件开场白
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (19)
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "Aze4xNW0bG2NTuIf",
"meta": {
"instanceId": "84280226fffa0e8a3206dee30fe2043ca65af7920df5605b8479b2950b4310cc"
},
"name": "真正能获得回复的 AI 驱动冷邮件开场白",
"tags": [],
"nodes": [
{
"id": "33074582-e6ea-4ba4-be34-a6f4695b5958",
"name": "便利贴 - 数据源",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1376,
-80
],
"parameters": {
"color": 5,
"width": 452,
"height": 508,
"content": "## 📊 数据源：GOOGLE SHEETS"
},
"typeVersion": 1
},
{
"id": "7f8ff355-6c3a-4bdf-ae3a-2339cec3c289",
"name": "便利贴 - 批量处理",
"type": "n8n-nodes-base.stickyNote",
"position": [
-928,
-80
],
"parameters": {
"color": 6,
"width": 264,
"height": 508,
"content": "## 🔄 处理"
},
"typeVersion": 1
},
{
"id": "0bd311ec-7e5c-42ab-bfaf-d7765ba7ca84",
"name": "便利贴 - 公司名称清理",
"type": "n8n-nodes-base.stickyNote",
"position": [
-672,
-80
],
"parameters": {
"color": 7,
"width": 348,
"height": 512,
"content": "## ✏️ 公司名称标准化"
},
"typeVersion": 1
},
{
"id": "65c388ac-5d75-4ee3-8886-31208aba6725",
"name": "便利贴 - 研究",
"type": "n8n-nodes-base.stickyNote",
"position": [
-336,
-80
],
"parameters": {
"color": 3,
"width": 372,
"height": 520,
"content": "## 🔎 公司研究"
},
"typeVersion": 1
},
{
"id": "38c666f7-d9a3-4888-9626-6aec78a6fd7c",
"name": "便利贴 - 开场白生成",
"type": "n8n-nodes-base.stickyNote",
"position": [
32,
-80
],
"parameters": {
"color": 3,
"width": 376,
"height": 512,
"content": "## ✨ 开场白生成"
},
"typeVersion": 1
},
{
"id": "89b9858e-2ef6-448a-8e06-b0b734f35311",
"name": "便利贴 - 更新",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-80
],
"parameters": {
"color": 5,
"width": 300,
"height": 512,
"content": "## 💾 更新电子表格"
},
"typeVersion": 1
},
{
"id": "715bd285-c8a7-4520-9571-8e2c3db18511",
"name": "便利贴 - 快速开始",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1680,
-336
],
"parameters": {
"color": 4,
"width": 304,
"height": 772,
"content": "## 🚀 快速开始指南"
},
"typeVersion": 1
},
{
"id": "9ec50fca-839f-446d-87b9-1d03e7a0baff",
"name": "便利贴 - 成本分析",
"type": "n8n-nodes-base.stickyNote",
"position": [
688,
-80
],
"parameters": {
"color": 4,
"width": 280,
"height": 512,
"content": "## 💰 成本分析"
},
"typeVersion": 1
},
{
"id": "e47f3da6-f275-4de1-8cda-d9f6e8bbb09f",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1600,
256
],
"parameters": {},
"typeVersion": 1
},
{
"id": "55f0d612-d933-42c0-9724-23a9ade26fb1",
"name": "循环处理线索",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-880,
256
],
"parameters": {
"options": {},
"batchSize": 25
},
"typeVersion": 3
},
{
"id": "1ac1c796-fb63-4505-aab2-e03bf331bd19",
"name": "公司名称清理",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-608,
256
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "GPT-4O-MINI"
},
"options": {
"topP": 1,
"maxTokens": 250,
"temperature": 0.6
},
"messages": {
"values": [
{
"role": "system",
"content": "You are a helpful, intelligent writing assistant."
},
{
"content": "=Your task is to make an icebreaker.\n\n\nTo clean up company name paraphrase {{ $('Get Leads').item.json.organization_name }}\ne.g.:\n\"The Boathouse Agency\" MUST be \"Boathouse\"\n\"Baaba Holland Agency\" MUST be \"Baaba Holland\"\n\"BNR Branding Solutions\" MUST be \"BNR\"\n\"Van Ness Agency\" MUST be \"Van Ness\"\n\"IRL Agency\" MUST be \"IRL\"\n\"Sharp Guys Web Design and Digital Marketing Agency\" MUST be \"Sharp Guys\"\n\nAlways output a cleaned up company name!\n\nReturn JSON:\n{\nCompanyNameCleanUp: \"\"\n}"
},
{
"content": "Shorten all organizations, company & projects names, paraphrase so prospects think a human wrote it. \n\nExamples:\n\"Fashion Hall agency\" or \"Fashion Hall\" NOT \"THE FASHION HALL AGENCY\"; \"81 agency\" NOT \"Eighteen81 Agency\" NOT \"eighteen81 Agency\"; \"WT\" or \"WT agency\" NOT \"WT Digital Agency\"; \"Pearls\" NOT \"Pearls Marketing Agency\"; \"Kannon\" NOT \"Kannon Marketing Agency\"; \"PURE\" NOT \"Agency PURE\". If a company name contains word \"Agency\" like this: \"Cheeky Agency\" use only name of agency, e.g \"Cheeky\". If a company has \"Inc.\" or \"Group\" in the name avoid using these words in the text"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "NtqJ7vfx8zEk4am9",
"name": "OpenAi account"
}
},
"retryOnFail": true,
"typeVersion": 1.6
},
{
"id": "d3fc0e7f-aa5c-4371-9320-8464732f974a",
"name": "Perplexity Sonar",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
-256,
352
],
"parameters": {
"model": "perplexity/sonar",
"options": {}
},
"typeVersion": 1
},
{
"id": "b995242f-530f-4ab0-8aa6-805cb02ccac7",
"name": "Claude Sonnet",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
112,
352
],
"parameters": {
"model": "anthropic/claude-sonnet-4",
"options": {
"topP": 0.8,
"maxTokens": 300
}
},
"typeVersion": 1
},
{
"id": "107c9bc9-0ed5-4513-9312-b287705e1842",
"name": "解析 JSON",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
256,
352
],
"parameters": {
"jsonSchemaExample": "{\"icebreaker\":\"\"}"
},
"typeVersion": 1.3
},
{
"id": "9433978e-fbcc-4c33-8366-285ff7a7ae17",
"name": "生成开场白",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
112,
256
],
"parameters": {
"text": "=You are a helpful, intelligent assistant",
"batching": {},
"messages": {
"messageValues": [
{
"message": "=You are a helpful, intelligent assistant"
},
{
"type": "HumanMessagePromptTemplate",
"message": "=Write an icebreaker—a one line, customized introduction—for a cold email campaign.\n\nUse the provided data (from a Google Search) as context.\n\nGuidlines:\n1. Your tone of voice should be \"casual bar converation\" and very spartan. No fancy language.\n2. Look for plausible (but vague) connections wherever possible.\n3. Do not lie & stratch the truth. For example, if one was a poker pro player, do not mention that I was as well!\n4. After \"Hey [firstName],\" always put \\n\\n\n5. End the icebreaker with \"I wanted to share something that could be relevant for {{ $('Company Name Clean Up').item.json.message.content.CompanyNameCleanUp }}\".\n\nExample icebreakers:\n\n\"Hey Boris,\\n\\nReally like the way Parisleaf started with that whole print and plant tree thing back in 2015 - pretty cool how you've grown that into helping nonprofits with their fundraising campaigns, I wanted to share something that could be relevant Parismover\""
},
{
"type": "HumanMessagePromptTemplate",
"message": "={\"context\":\"{{ $json.text }}\"}"
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "5442e9b6-32a4-4c7d-9502-e444f3d3e8dd",
"name": "Perplexity 研究",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
-256,
256
],
"parameters": {
"text": "=Find information",
"batching": {},
"messages": {
"messageValues": [
{
"type": "HumanMessagePromptTemplate",
"message": "={{ $('Get Leads').item.json.first_name }} {{ $('Get Leads').item.json.last_name }} {{ $('Get Leads').item.json.title }} {{ $('Get Leads').item.json.organization_name }} at {{ $now.toFormat('dd.MM.yyyy') }}"
}
]
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "1489908c-e151-416e-93df-9c56ba8e7d92",
"name": "更新开场白",
"type": "n8n-nodes-base.googleSheets",
"maxTries": 2,
"position": [
496,
256
],
"parameters": {
"columns": {
"value": {
"id": "={{ $('Get Leads').item.json.id }}",
"Icebreaker": "={{ $json.output.icebreaker }}",
"row_number": 0,
"company_name_cleanup": "={{ $('Company Name Clean Up').item.json.message.content.CompanyNameCleanUp }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "company_name_cleanup",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_name_cleanup",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Icebreaker",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Icebreaker",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "name",
"value": " "
},
"documentId": {
"__rl": true,
"mode": "id",
"value": ""
}
},
"retryOnFail": false,
"typeVersion": 4.6
},
{
"id": "ae2616ec-c0e4-4267-ace9-523e475c9f8d",
"name": "检查是否未处理",
"type": "n8n-nodes-base.if",
"position": [
-1104,
256
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "ebb9dbd8-0616-4a42-a4c2-1aa2532f8b15",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Icebreaker }}",
"rightValue": "no data"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b92cd82b-8276-48a6-b99f-c9cc5351492a",
"name": "获取潜在客户",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1328,
256
],
"parameters": {
"sheetName": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": ""
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"executeOnce": false,
"typeVersion": 4.6
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "9d51a60e-dd00-4180-a410-a55786c900c7",
"connections": {
"b92cd82b-8276-48a6-b99f-c9cc5351492a": {
"main": [
[
{
"node": "ae2616ec-c0e4-4267-ace9-523e475c9f8d",
"type": "main",
"index": 0
}
]
]
},
"107c9bc9-0ed5-4513-9312-b287705e1842": {
"ai_outputParser": [
[
{
"node": "9433978e-fbcc-4c33-8366-285ff7a7ae17",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"b995242f-530f-4ab0-8aa6-805cb02ccac7": {
"ai_languageModel": [
[
{
"node": "9433978e-fbcc-4c33-8366-285ff7a7ae17",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"55f0d612-d933-42c0-9724-23a9ade26fb1": {
"main": [
[],
[
{
"node": "1ac1c796-fb63-4505-aab2-e03bf331bd19",
"type": "main",
"index": 0
}
]
]
},
"d3fc0e7f-aa5c-4371-9320-8464732f974a": {
"ai_languageModel": [
[
{
"node": "5442e9b6-32a4-4c7d-9502-e444f3d3e8dd",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"1489908c-e151-416e-93df-9c56ba8e7d92": {
"main": [
[
{
"node": "55f0d612-d933-42c0-9724-23a9ade26fb1",
"type": "main",
"index": 0
}
]
]
},
"9433978e-fbcc-4c33-8366-285ff7a7ae17": {
"main": [
[
{
"node": "1489908c-e151-416e-93df-9c56ba8e7d92",
"type": "main",
"index": 0
}
]
]
},
"5442e9b6-32a4-4c7d-9502-e444f3d3e8dd": {
"main": [
[
{
"node": "9433978e-fbcc-4c33-8366-285ff7a7ae17",
"type": "main",
"index": 0
}
]
]
},
"ae2616ec-c0e4-4267-ace9-523e475c9f8d": {
"main": [
[
{
"node": "55f0d612-d933-42c0-9724-23a9ade26fb1",
"type": "main",
"index": 0
}
]
]
},
"1ac1c796-fb63-4505-aab2-e03bf331bd19": {
"main": [
[
{
"node": "5442e9b6-32a4-4c7d-9502-e444f3d3e8dd",
"type": "main",
"index": 0
}
]
]
},
"e47f3da6-f275-4de1-8cda-d9f6e8bbb09f": {
"main": [
[
{
"node": "b92cd82b-8276-48a6-b99f-c9cc5351492a",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
LinkedIn和X病毒内容自动引擎
使用AI生成和发布自动创建LinkedIn和X的病毒内容
If
Set
Wait
+
If
Set
Wait
156 节点Diptamoy Barman
内容创作
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
If
Set
Code
+
If
Set
Code
52 节点Daniel Lianes
杂项
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+
If
Ftp
Set
113 节点I versus AI
其他
基于LinkedIn数据通过OpenRouter使用Claude
基于LinkedIn数据通过OpenRouter使用Claude 3.7生成个性化销售邮件
If
Set
Gmail
+
If
Set
Gmail
23 节点Adam Janes
客户培育
使用AI（GPT-4o）自动化数字产品和SaaS销售
使用AI（GPT-4o）自动化数字产品和SaaS销售
If
Code
Wait
+
If
Code
Wait
34 节点Badr
销售
AI 邮件分析器：处理 PDF、图片
处理PDF、图片并保存至Google云端硬盘和Telegram
If
Set
Code
+
If
Set
Code
31 节点Davide
人工智能
