邮件外展自动化
高级
这是一个Lead Nurturing、Multimodal AI领域的自动化工作流，包含 18 个节点。主要使用 If、Set、Html、Wait、Gmail 等节点。 使用Google Sheets和Gmail的免费邮件跟进序列
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
使用的节点 (18 个)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "obx5E5Fbfe9yfECA",
"meta": {
"instanceId": "7a73e968af152b9877d4c64b00e93bdf2a57741f130f9226cd4d7217ba6e5e6c",
"templateCredsSetupCompleted": true
},
"name": "邮件外展自动化",
"tags": [],
"nodes": [
{
"id": "47381995-0595-482e-94c6-19e223722e68",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-736,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a6a48076-ed29-405a-853d-ef1e0a74f592",
"name": "便签15",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1888,
736
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "eb5ee0b6-1be7-43f2-bfe8-04fd02ee8dce",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-2048,
528
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "35214964-7e3e-48bd-9fad-dd3906a2e808",
"name": "设置",
"type": "n8n-nodes-base.set",
"position": [
-1840,
528
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "0827b600-5522-4961-9085-0718e42f906d",
"name": "获取联系人",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1616,
528
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "788de15d-edbf-4f8c-960c-f6ffbff1b7a1",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-768,
528
],
"parameters": {},
"typeVersion": 3
},
{
"id": "7abdf707-87c8-4c69-83d0-b63e7c681bcf",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
800,
528
],
"webhookId": "5210b0f5-71e3-4884-a43b-a7ffaa2e6c1d",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "a0ab3983-4de5-4e4e-8b94-c87f1d581b17",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1856,
-64
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "253f9651-018c-4fac-b423-7ec600db9d57",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
736
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9bd6adaa-d8cc-4901-abc9-1129c730a562",
"name": "邮件模板选择器",
"type": "n8n-nodes-base.googleDocs",
"position": [
-96,
448
],
"parameters": {},
"executeOnce": false,
"typeVersion": 2
},
{
"id": "472d9091-7fca-4e6c-be1d-4ee0a6c765d9",
"name": "确定邮件编号",
"type": "n8n-nodes-base.set",
"position": [
-320,
448
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "a3e8ddb1-7cfd-42be-9503-170cb0965dfe",
"name": "发送消息",
"type": "n8n-nodes-base.gmail",
"position": [
352,
448
],
"webhookId": "d9e04564-b34b-4da0-94c8-6f76f43e1abc",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "b401964f-bd56-45e2-aa04-e5f8b5e6963d",
"name": "更新联系人",
"type": "n8n-nodes-base.googleSheets",
"notes": "row_number (using to match)\n{{ $('contacts').item.json.row_number }}\n\nprocess\n{{ $now.format('yyyy-MM-dd, hh:mm:ss a') }}",
"position": [
576,
448
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "1f4c9ab2-b242-4ae5-87ae-675aa8adb7a7",
"name": "限制每次运行的邮件数量",
"type": "n8n-nodes-base.limit",
"position": [
-1408,
528
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5f2dcdbd-bed8-447c-8350-edd799d349d3",
"name": "筛选器仅传递未处理联系人",
"type": "n8n-nodes-base.filter",
"position": [
-1200,
528
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "acd72b36-9d83-4a84-a566-1ae51498a4df",
"name": "联系人是否真实？",
"type": "n8n-nodes-base.if",
"position": [
-544,
448
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "24e198d1-1131-452b-a51b-c83799b33858",
"name": "联系人是否已完成邮件序列？",
"type": "n8n-nodes-base.filter",
"position": [
-992,
528
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "68d16071-544a-414e-a7c7-52ee88e5443f",
"name": "HTML：格式化并美化邮件",
"type": "n8n-nodes-base.html",
"position": [
128,
448
],
"parameters": {},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "da5f4136-2daf-4ab4-99a1-f112f5ecddf0",
"connections": {
"Wait": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Settings": {
"main": [
[
{
"node": "Get Contacts",
"type": "main",
"index": 0
}
]
]
},
"Get Contacts": {
"main": [
[
{
"node": "Limits the number of emails per run",
"type": "main",
"index": 0
}
]
]
},
"Send a message": {
"main": [
[
{
"node": "updatecontacts",
"type": "main",
"index": 0
}
]
]
},
"updatecontacts": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Is Contact Real?",
"type": "main",
"index": 0
}
]
]
},
"Is Contact Real?": {
"main": [
[
{
"node": "Determine Email Number",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Settings",
"type": "main",
"index": 0
}
]
]
},
"Determine Email Number": {
"main": [
[
{
"node": "email template selector",
"type": "main",
"index": 0
}
]
]
},
"email template selector": {
"main": [
[
{
"node": "HTML: formats and beautifies the email",
"type": "main",
"index": 0
}
]
]
},
"Limits the number of emails per run": {
"main": [
[
{
"node": "Filter passes only unprocessed contacts",
"type": "main",
"index": 0
}
]
]
},
"Has contact completed email sequence?": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"HTML: formats and beautifies the email": {
"main": [
[
{
"node": "Send a message",
"type": "main",
"index": 0
}
]
]
},
"Filter passes only unprocessed contacts": {
"main": [
[
{
"node": "Has contact completed email sequence?",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Lead Nurturing、Multimodal AI等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Upwork 等平台职位申请自动化（使用 Vollna RSS）
通过 OpenRouter 在 Upwork、Freelancer、Guru 和 PPH 上实现职位发现与 AI 提案的自动化
Set
Code
Html
+10
16 节点Gerald Denor
Lead Generation
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
Other
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
Content Creation
来自多个招聘网站的求职自动化
使用 5 个招聘平台和 AI 简历生成器自动化求职与申请
If
Set
Code
+14
34 节点Gerald Denor
Personal Productivity
使用 Browserflow 和 Google Sheets 跟踪自动化 LinkedIn 邀请
使用 Browserflow 和 Google Sheets 跟踪自动化 LinkedIn 邀请
If
Set
Wait
+8
23 节点Stéphane Heckel
Lead Nurturing
GPT-4驱动的冷邮件工作流，包含完全定制的3封邮件跟进
使用GPT-4、Mailgun和Supabase自动化个性化冷邮件序列
If
Set
Code
+22
100 节点Paul
Lead Nurturing
工作流信息
难度等级
高级
节点数量18
分类2
节点类型12
作者
Gerald Denor
@dominixaiGerald Akhidenor is an AI Automation Lead Creative with 5 years of experience in AI automation consultancy. He specializes in n8n and API integrations, driving innovative automation solutions. As founder of DominixAI, Gerald combines creative vision and technical expertise to streamline processes and boost efficiency through cutting-edge AI technologies. Website: https://dominixai.com JobMonkey: https://trafficabc.com/jobmonkey-application-generator/
外部链接
在 n8n.io 上查看 →
分享此工作流