未出席跟进与重新安排
高级
这是一个Lead Nurturing领域的自动化工作流，包含 28 个节点。主要使用 If、Set、Wait、Gmail、GoogleSheets 等节点。 智能会议重新安排：Gmail+日历+Sheets自动化
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "T07dgMHOSZIFln2L",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "未出席跟进与重新安排",
"tags": [],
"nodes": [
{
"id": "a4c7e084-144a-41ba-9101-5e261b8b9651",
"name": "检查是否未预约",
"type": "n8n-nodes-base.if",
"position": [
-1488,
432
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3d3e2ade-adfb-45f2-9b3b-cd475e698f1d",
"name": "创建日历占位符",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-960,
416
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "b5f79d41-2aff-4685-9a68-59177f7865f5",
"name": "发送跟进邮件",
"type": "n8n-nodes-base.gmail",
"position": [
-1200,
416
],
"webhookId": "0c82c299-6938-42ed-bda6-5007d79af34f",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "c8997a52-f409-4794-b18e-88ff6e6aef83",
"name": "获取表格中的行数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1744,
432
],
"parameters": {},
"typeVersion": 4
},
{
"id": "81f001df-85f5-4a04-a56b-cf3f2bccbcbe",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1952,
432
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5a74f0f5-a52c-4f3f-8496-fd5d6a187ac8",
"name": "获取会话线程",
"type": "n8n-nodes-base.gmail",
"position": [
-512,
416
],
"webhookId": "ffb3a844-8c8b-4f17-a6e9-98e0371f4214",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "a99f1f94-b32c-4fac-b641-f7a0d9428916",
"name": "条件判断",
"type": "n8n-nodes-base.if",
"position": [
-288,
416
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "5aef320f-fdfc-4229-9caa-374ef43199cd",
"name": "发送跟进邮件1",
"type": "n8n-nodes-base.gmail",
"position": [
-64,
528
],
"webhookId": "0c82c299-6938-42ed-bda6-5007d79af34f",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "e02be106-a971-4959-9684-e6e9b353ff19",
"name": "条件判断1",
"type": "n8n-nodes-base.if",
"position": [
560,
528
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "6248893d-4afd-4e31-86b6-1930eb64c4ab",
"name": "获取会话线程1",
"type": "n8n-nodes-base.gmail",
"position": [
368,
528
],
"webhookId": "ffb3a844-8c8b-4f17-a6e9-98e0371f4214",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "498d7092-850f-4bb0-b39e-5eb5cf08ea4f",
"name": "追加或更新表格行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1056,
640
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "d9894085-c755-4aa9-b156-9e5b0acbf8f9",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
832,
640
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "da5192cb-6b0d-433c-b22b-a7c86c896f34",
"name": "等待24小时",
"type": "n8n-nodes-base.wait",
"position": [
-736,
416
],
"webhookId": "7475fece-4562-46b3-a702-7a5c5fe88266",
"parameters": {},
"typeVersion": 1
},
{
"id": "5216cbeb-7f11-466d-8ade-2868a12b4681",
"name": "等待24小时1",
"type": "n8n-nodes-base.wait",
"position": [
160,
528
],
"webhookId": "7475fece-4562-46b3-a702-7a5c5fe88266",
"parameters": {},
"typeVersion": 1
},
{
"id": "27821bdf-19ac-475f-bf64-f5547508de80",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2032,
176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a268381e-6388-4202-a8e7-28eb7527e82d",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1808,
608
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "269c0fe6-7aec-4b52-974d-0c5034ad61f2",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1552,
96
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3a248d59-a035-4ebd-8e13-3ae6d902750c",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1280,
608
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "dc4aa7e7-88ed-4b3c-8862-b744ad4b93c0",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1040,
112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6bb7d990-ede7-476e-9541-f4570325e94b",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
608
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "31143aba-1195-4456-afcf-18ee8a535ca6",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-576,
160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "648c1a89-4a97-4eec-94b9-9a63f26d1e05",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-368,
608
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b22607d4-bba8-42b0-a5e8-719da2347d79",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-128,
192
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "91f81739-c817-4291-a2b0-dcc04df921ff",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
112,
720
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2751bf34-065b-4ce9-a1e0-e2556e37b872",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
288,
288
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4014f225-1ee3-44f5-962b-cb3238e6427a",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
512,
704
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d887437a-61d6-4d8d-9e50-f9cbc44ce3cf",
"name": "便签 12",
"type": "n8n-nodes-base.stickyNote",
"position": [
768,
336
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "48b9bea1-e30d-4e3a-be4a-a918430ca071",
"name": "便签 13",
"type": "n8n-nodes-base.stickyNote",
"position": [
1008,
832
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "9ea7f85e-d7ee-45a2-8346-bc16a77cf1b6",
"connections": {
"If": {
"main": [
[],
[
{
"node": "Send Follow-up Email1",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[],
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Wait 24hr": {
"main": [
[
{
"node": "Get a thread",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Get a thread": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Wait 24 hr 1": {
"main": [
[
{
"node": "Get a thread1",
"type": "main",
"index": 0
}
]
]
},
"Get a thread1": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"Check If Unbooked": {
"main": [
[
{
"node": "Send Follow-up Email",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet1": {
"main": [
[
{
"node": "Check If Unbooked",
"type": "main",
"index": 0
}
]
]
},
"Send Follow-up Email": {
"main": [
[
{
"node": "Create Calendar Placeholder",
"type": "main",
"index": 0
}
]
]
},
"Send Follow-up Email1": {
"main": [
[
{
"node": "Wait 24 hr 1",
"type": "main",
"index": 0
}
]
]
},
"Create Calendar Placeholder": {
"main": [
[
{
"node": "Wait 24hr",
"type": "main",
"index": 0
}
]
]
},
"Append or update row in sheet": {
"main": [
[]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Get row(s) in sheet1",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Lead Nurturing等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
潜在客户培育流失检测器
使用HighLevel、Gmail、Slack和Google表格的自动化销售跟进系统
If
Code
Wait
+6
23 节点Rahul Joshi
Lead Nurturing
API速率限制与认证FAQ测试
使用GPT-4o-mini、Google表格和Slack提醒自动化API常见问题质量测试
If
Set
Code
+7
19 节点Rahul Joshi
Document Extraction
个性化拒绝/下一步邮件
使用Google Sheets、GPT-4o-mini、Gmail和ClickUp自动化候选人拒绝
If
Set
Code
+7
38 节点Rahul Joshi
HR
新开发人员入职自动化
使用 GPT-4o 实现员工入职自动化：Jira、Notion 和 Gmail 集成
If
Set
Code
+9
21 节点Rahul Joshi
HR
服务后评价收集器
客户评价收集与情感分析：HighLevel、GPT-4o、Gmail和Slack
If
Wait
Gmail
+7
20 节点Rahul Joshi
CRM
敏捷团队冲刺规划自动化
使用OpenAI、Google日历和Gmail为敏捷团队自动化冲刺规划
If
Set
Code
+17
52 节点Willemijn
Product
工作流信息
难度等级
高级
节点数量28
分类1
节点类型8
作者
Rahul Joshi
@rahul08Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.
外部链接
在 n8n.io 上查看 →
分享此工作流