带跟进与回复追踪的自动邮件群发
中级
这是一个Social Media, Multimodal AI领域的自动化工作流，包含 11 个节点。主要使用 If, Gmail, Switch, GoogleSheets, EmailReadImap 等节点。 带跟进与回复追踪的自动邮件群发
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "8urb5ud9FW5of1Ct",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "带跟进与回复追踪的自动邮件群发",
"tags": [],
"nodes": [
{
"id": "263d7a2a-0185-47b5-a58b-c00a0f756dcc",
"name": "每日触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-80,
-485
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "d5b54189-9981-4b23-afa1-d8c2007ce94d",
"name": "获取联系人数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
-485
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 686562196,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit#gid=686562196",
"cachedResultName": "Sheet3"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit?usp=drivesdk",
"cachedResultName": "PageRankChecker"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 4.6
},
{
"id": "f2525c0e-4f9b-4430-a4f1-d21c18977095",
"name": "遍历联系人",
"type": "n8n-nodes-base.splitInBatches",
"position": [
360,
-485
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "55ff15d6-15ed-4197-b2b4-98df8695f98c",
"name": "确定跟进阶段",
"type": "n8n-nodes-base.if",
"onError": "continueErrorOutput",
"position": [
580,
-560
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8533f0cb-5664-4ba3-ac35-46587194560d",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Reply }}",
"rightValue": "no"
}
]
}
},
"typeVersion": 2.2,
"alwaysOutputData": true
},
{
"id": "11f2e1b6-0f21-4d5b-aced-a4c45e29f970",
"name": "按跟进阶段路由",
"type": "n8n-nodes-base.switch",
"position": [
800,
-560
],
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bde52b5f-b028-4849-acd0-fd976bbae44d",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json['Follow-up'] }}",
"rightValue": 6
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1a69881c-21ce-4cb7-9c17-f5ed0e5dd6ac",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json['Follow-up'] }}",
"rightValue": 7
}
]
}
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "2dbd64d3-ec48-4992-a25e-f665d4f04001",
"name": "发送跟进邮件 1",
"type": "n8n-nodes-base.gmail",
"position": [
1020,
-660
],
"webhookId": "3844e21b-95b7-4e7c-81ef-5e49a9e8a6f1",
"parameters": {
"sendTo": "={{ $json['User Email'] }}",
"message": "Testing-6",
"options": {
"appendAttribution": false
},
"subject": "Testing-6",
"emailType": "text",
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 2.1
},
{
"id": "c2ed8d92-11c0-49df-87c2-191917a18a9b",
"name": "发送跟进邮件 2",
"type": "n8n-nodes-base.gmail",
"position": [
1020,
-460
],
"webhookId": "0e770d89-aadf-4a63-a769-f142de4da2e2",
"parameters": {
"sendTo": "={{ $json['User Email'] }}",
"message": "Testing-7",
"options": {
"appendAttribution": false
},
"subject": "Testing-7",
"emailType": "text",
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 2.1
},
{
"id": "715c5558-6bdb-4b8b-afc1-ae62bbf175f0",
"name": "更新跟进状态到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1240,
-460
],
"parameters": {
"columns": {
"value": {
"Reply": "={{ $('Route by Follow-Up Stage').item.json.Reply }}",
"Follow-up": "={{ $('Route by Follow-Up Stage').item.json['Follow-up'] + 1}}",
"Send Mail": "=yes (Follow-up = {{ $('Route by Follow-Up Stage').item.json['Follow-up'] }}) ",
"User Name": "={{ $('Route by Follow-Up Stage').item.json['User Name'] }}",
"Inquiry ID": "={{ $('Route by Follow-Up Stage').item.json['Inquiry ID'] }}",
"User Email": "={{ $('Route by Follow-Up Stage').item.json['User Email'] }}",
"Follow-up Type": "Email",
"Submission Date": "={{ new Date($now).toISOString().split('T')[0] }}",
"Next Follow-up Date": "={{ new Date(Date.now() + 3 * 24 * 60 * 60 * 1000).toISOString().split('T')[0] }}"
},
"schema": [
{
"id": "User Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "User Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "User Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "User Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Inquiry ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Inquiry ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reply",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Reply",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Follow-up",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Follow-up",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Send Mail",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Send Mail",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Follow-up Type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Follow-up Type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Communication Mode",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Communication Mode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Comment",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Comment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Requirement Doc",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Requirement Doc",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Workflow Diagram",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Workflow Diagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Test Cases",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Test Cases",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Call Schedule",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Call Schedule",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Submission Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Submission Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next Follow-up Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Next Follow-up Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"User Name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 686562196,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit#gid=686562196",
"cachedResultName": "Sheet3"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit?usp=drivesdk",
"cachedResultName": "PageRankChecker"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 4.6
},
{
"id": "009b187a-a8b6-4748-bc9a-2e7dcd69f233",
"name": "检查邮件回复",
"type": "n8n-nodes-base.emailReadImap",
"position": [
-80,
-200
],
"parameters": {
"options": {
"customEmailConfig": "[\"UNSEEN\", [\"SUBJECT\", \"Testing\"]]"
}
},
"credentials": {
"imap": {
"id": "D3nLrSlP1dHWcIDE",
"name": "IMAP account"
}
},
"typeVersion": 2
},
{
"id": "91e87156-bd84-4df5-ad9e-11089af50c02",
"name": "更新回复状态到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
-200
],
"parameters": {
"columns": {
"value": {
"reply": "=yes",
"user email": "={{ $json.from }}"
},
"schema": [
{
"id": "user name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "user name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "user email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "user email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reply",
"type": "string",
"display": true,
"required": false,
"displayName": "reply",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "followup",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "followup",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Send mail",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Send mail",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"user email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 686562196,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit#gid=686562196",
"cachedResultName": "Sheet3"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit?usp=drivesdk",
"cachedResultName": "PageRankChecker"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 4.6
},
{
"id": "a599605e-e3a6-412c-a221-cc73d87d7d74",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-960
],
"parameters": {
"color": 4,
"width": 920,
"height": 240,
"content": "## 节点详情"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "437e7f2a-166b-487d-a269-7fc2dbebb917",
"connections": {
"263d7a2a-0185-47b5-a58b-c00a0f756dcc": {
"main": [
[
{
"node": "d5b54189-9981-4b23-afa1-d8c2007ce94d",
"type": "main",
"index": 0
}
]
]
},
"f2525c0e-4f9b-4430-a4f1-d21c18977095": {
"main": [
[],
[
{
"node": "55ff15d6-15ed-4197-b2b4-98df8695f98c",
"type": "main",
"index": 0
}
]
]
},
"d5b54189-9981-4b23-afa1-d8c2007ce94d": {
"main": [
[
{
"node": "f2525c0e-4f9b-4430-a4f1-d21c18977095",
"type": "main",
"index": 0
}
]
]
},
"009b187a-a8b6-4748-bc9a-2e7dcd69f233": {
"main": [
[
{
"node": "91e87156-bd84-4df5-ad9e-11089af50c02",
"type": "main",
"index": 0
}
]
]
},
"c2ed8d92-11c0-49df-87c2-191917a18a9b": {
"main": [
[
{
"node": "715c5558-6bdb-4b8b-afc1-ae62bbf175f0",
"type": "main",
"index": 0
}
]
]
},
"2dbd64d3-ec48-4992-a25e-f665d4f04001": {
"main": [
[
{
"node": "715c5558-6bdb-4b8b-afc1-ae62bbf175f0",
"type": "main",
"index": 0
}
]
]
},
"11f2e1b6-0f21-4d5b-aced-a4c45e29f970": {
"main": [
[
{
"node": "2dbd64d3-ec48-4992-a25e-f665d4f04001",
"type": "main",
"index": 0
}
],
[
{
"node": "c2ed8d92-11c0-49df-87c2-191917a18a9b",
"type": "main",
"index": 0
}
]
]
},
"55ff15d6-15ed-4197-b2b4-98df8695f98c": {
"main": [
[
{
"node": "11f2e1b6-0f21-4d5b-aced-a4c45e29f970",
"type": "main",
"index": 0
}
]
]
},
"Send a message for followup 6": {
"main": [
[
{
"node": "HRMS api for upadte inqiery data direclty in db",
"type": "main",
"index": 0
}
]
]
},
"Send a message for followup 7": {
"main": [
[
{
"node": "HRMS api for upadte inqiery data direclty in db",
"type": "main",
"index": 0
}
]
]
},
"715c5558-6bdb-4b8b-afc1-ae62bbf175f0": {
"main": [
[
{
"node": "f2525c0e-4f9b-4430-a4f1-d21c18977095",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 社交媒体, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
通过WhatsApp、邮件和Twilio SMS发送的食品菜单更新通知器
食品菜单更新通知器
If
Set
Code
+
If
Set
Code
22 节点Oneclick AI Squad
社交媒体
AI驱动的Instagram评论自动回复
使用OpenAI和Redis跟踪自动化Instagram评论回复
If
Code
Merge
+
If
Code
Merge
27 节点Oneclick AI Squad
社交媒体
通过Excel + AI的智能邮件营销生成器（表格到收件箱）
基于Google Sheets使用Llama AI生成个性化营销邮件
Code
Gmail
Google Sheets
+
Code
Gmail
Google Sheets
7 节点Oneclick AI Squad
社交媒体
Instagram恶意评论审核与自动防御工作流
使用Perspective API和Slack提醒自动审核Instagram评论
If
Set
Cron
+
If
Set
Cron
15 节点Oneclick AI Squad
社交媒体
使用Google Sheet和Gmail实现电商生日折扣邮件自动化
使用Google Sheet和Gmail实现电商生日折扣邮件自动化
If
Gmail
Function
+
If
Gmail
Function
7 节点Marth
社交媒体
Instagram影响者交付物和合同合规性自动化
使用Claude AI和Slack提醒自动化Instagram影响者合同合规性
If
Set
Code
+
If
Set
Code
26 节点Oneclick AI Squad
社交媒体
工作流信息
难度等级
中级
节点数量11
分类2
节点类型8
作者
Oneclick AI Squad
@oneclick-aiThe AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.
外部链接
在 n8n.io 查看 →
分享此工作流