通过邮件和短信发送自动患者预约提醒，支持多数据库
高级
这是一个Support Chatbot领域的自动化工作流，包含 23 个节点。主要使用 Set, Code, Wait, Twilio, Webhook 等节点。 通过邮件和短信发送自动患者预约提醒，支持多数据库
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •Airtable API Key
- •PostgreSQL 数据库连接信息
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "a9d91614-af71-4fb2-8d70-31f924d25f1c",
"name": "Webhook：新预约",
"type": "n8n-nodes-base.webhook",
"position": [
-2656,
112
],
"webhookId": "bc1193f5-e81b-448d-a747-d2585b2511b7",
"parameters": {},
"typeVersion": 1
},
{
"id": "68db087c-8c0c-4d07-b7d4-ab11e130273b",
"name": "提取预约数据",
"type": "n8n-nodes-base.set",
"position": [
-2432,
112
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "c092578d-1c3b-46cf-be2b-798ab3204fcd",
"name": "格式化与验证数据",
"type": "n8n-nodes-base.code",
"position": [
-2208,
112
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8045beb6-3991-4be1-b4bb-dd9639180a48",
"name": "存储到Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1984,
16
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "b91c8dfa-f6be-49e9-84ab-7dfc477d7876",
"name": "存储到Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
-1984,
208
],
"parameters": {},
"typeVersion": 2
},
{
"id": "58623e20-a443-494c-ae69-3e7bc2741527",
"name": "等待：3天前",
"type": "n8n-nodes-base.wait",
"position": [
-1760,
16
],
"webhookId": "346b9c02-59ff-4f3f-9214-a5dc0f94cae6",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "cb96b8a0-e5dd-40d9-b5e6-d21857c3305e",
"name": "发送3天前邮件提醒",
"type": "n8n-nodes-base.emailSend",
"position": [
-1536,
-192
],
"webhookId": "6533c920-c4ec-4694-8103-d2daa32767a3",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "1029daf8-22f4-45dc-9249-23bb3368521b",
"name": "发送3天前短信提醒",
"type": "n8n-nodes-base.twilio",
"position": [
-1536,
304
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2792acef-a716-42ba-b401-e1b84408ef5f",
"name": "更新Google Sheets：3天前已发送",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1312,
-96
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "8b5748ed-a62e-4725-a2ad-6412d1468b18",
"name": "更新Airtable：3天前已发送",
"type": "n8n-nodes-base.airtable",
"position": [
-1232,
176
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4caf96ed-2006-41fa-9c4f-ede96ea654e0",
"name": "等待：1天前",
"type": "n8n-nodes-base.wait",
"position": [
-1088,
16
],
"webhookId": "8d343987-0a5f-4ef5-bf0e-ce7cb5fd5cff",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "e1ca4c2d-bcb4-48b1-bed9-9c74a77901e4",
"name": "发送1天前邮件提醒",
"type": "n8n-nodes-base.emailSend",
"position": [
-864,
-96
],
"webhookId": "f5af9abf-f65e-47a4-aead-6bcb99662081",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "88834f46-bcca-4d49-bc56-24b2b26065a6",
"name": "发送1天前短信提醒",
"type": "n8n-nodes-base.twilio",
"position": [
-864,
112
],
"parameters": {},
"typeVersion": 1
},
{
"id": "586716de-9d48-468a-8f97-a7e8f87dd1e4",
"name": "更新Google Sheets：1天前已发送",
"type": "n8n-nodes-base.googleSheets",
"position": [
-640,
-96
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "2398d8d2-7255-4306-806a-aaac78aeaecd",
"name": "更新Airtable：1天前已发送",
"type": "n8n-nodes-base.airtable",
"position": [
-640,
112
],
"parameters": {},
"typeVersion": 2
},
{
"id": "00e32802-9651-4aa9-9143-81a90b7fe00d",
"name": "系统概览",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2704,
-560
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4a1619df-aed7-4527-9d00-0a571d3cec83",
"name": "数据库选择指南",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2352,
-560
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e8b7763b-3fcf-4956-9fde-5ee17a084a8d",
"name": "Google Sheets设置",
"type": "n8n-nodes-base.stickyNote",
"position": [
-464,
-432
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c3e818dc-46d6-4f83-a195-05eee8a1c5ee",
"name": "Airtable设置",
"type": "n8n-nodes-base.stickyNote",
"position": [
-464,
48
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e4db5054-ad97-4d4d-a2e7-8c6288e22a63",
"name": "客户端设置清单",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1120,
-528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e1c7410d-a009-48ce-a348-367e2f4b285b",
"name": "存储到PostgreSQL",
"type": "n8n-nodes-base.postgres",
"position": [
-1984,
-192
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "3701ff81-7ed4-4961-bac9-6ffa149d5b53",
"name": "更新PostgreSQL：3天前已发送",
"type": "n8n-nodes-base.postgres",
"position": [
-1312,
-288
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "b58b6cdb-c01f-426d-a1af-9ad37c1b4cce",
"name": "更新PostgreSQL：1天前已发送",
"type": "n8n-nodes-base.postgres",
"position": [
-640,
-288
],
"parameters": {},
"typeVersion": 2.6
}
],
"pinData": {},
"connections": {
"Store in Airtable": {
"main": [
[
{
"node": "Wait: 3 Days Before",
"type": "main",
"index": 0
}
]
]
},
"Wait: 1 Day Before": {
"main": [
[
{
"node": "Send 1-Day Email Reminder",
"type": "main",
"index": 0
},
{
"node": "Send 1-Day SMS Reminder",
"type": "main",
"index": 0
}
]
]
},
"Store in PostgreSQL": {
"main": [
[
{
"node": "Wait: 3 Days Before",
"type": "main",
"index": 0
}
]
]
},
"Wait: 3 Days Before": {
"main": [
[
{
"node": "Send 3-Day Email Reminder",
"type": "main",
"index": 0
},
{
"node": "Send 3-Day SMS Reminder",
"type": "main",
"index": 0
}
]
]
},
"Format & Validate Data": {
"main": [
[
{
"node": "Store in Google Sheets",
"type": "main",
"index": 0
},
{
"node": "Store in Airtable",
"type": "main",
"index": 0
},
{
"node": "Store in PostgreSQL",
"type": "main",
"index": 0
}
]
]
},
"Store in Google Sheets": {
"main": [
[
{
"node": "Wait: 3 Days Before",
"type": "main",
"index": 0
}
]
]
},
"Send 1-Day SMS Reminder": {
"main": [
[
{
"node": "Update Google Sheets: 1-Day Sent",
"type": "main",
"index": 0
},
{
"node": "Update Airtable: 1-Day Sent",
"type": "main",
"index": 0
},
{
"node": "Update PostgreSQL: 1-Day Sent",
"type": "main",
"index": 0
}
]
]
},
"Send 3-Day SMS Reminder": {
"main": [
[
{
"node": "Update Google Sheets: 3-Day Sent",
"type": "main",
"index": 0
},
{
"node": "Update Airtable: 3-Day Sent",
"type": "main",
"index": 0
},
{
"node": "Update PostgreSQL: 3-Day Sent",
"type": "main",
"index": 0
}
]
]
},
"Extract Appointment Data": {
"main": [
[
{
"node": "Format & Validate Data",
"type": "main",
"index": 0
}
]
]
},
"Webhook: New Appointment": {
"main": [
[
{
"node": "Extract Appointment Data",
"type": "main",
"index": 0
}
]
]
},
"Send 1-Day Email Reminder": {
"main": [
[
{
"node": "Update Google Sheets: 1-Day Sent",
"type": "main",
"index": 0
},
{
"node": "Update Airtable: 1-Day Sent",
"type": "main",
"index": 0
},
{
"node": "Update PostgreSQL: 1-Day Sent",
"type": "main",
"index": 0
}
]
]
},
"Send 3-Day Email Reminder": {
"main": [
[
{
"node": "Update Google Sheets: 3-Day Sent",
"type": "main",
"index": 0
},
{
"node": "Update Airtable: 3-Day Sent",
"type": "main",
"index": 0
},
{
"node": "Update PostgreSQL: 3-Day Sent",
"type": "main",
"index": 0
}
]
]
},
"Update Airtable: 3-Day Sent": {
"main": [
[
{
"node": "Wait: 1 Day Before",
"type": "main",
"index": 0
}
]
]
},
"Update PostgreSQL: 3-Day Sent": {
"main": [
[
{
"node": "Wait: 1 Day Before",
"type": "main",
"index": 0
}
]
]
},
"Update Google Sheets: 3-Day Sent": {
"main": [
[
{
"node": "Wait: 1 Day Before",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 客服机器人
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
太阳能线索重新激活
AI驱动的短信、邮件和Google表格自动化重新激活太阳能线索
Code
Wait
Open Ai
+7
28 节点David Olusola
客户培育
使用Google套件、PDF和邮件自动化商业保险提交
通过Google套件、PDF和邮件自动化商业保险提交流程
If
Set
Code
+10
37 节点David Olusola
文档提取
使用SignSnapHome、HubSpot和Twilio自动化房地产开放日跟进
通过SignSnapHome、HubSpot和Twilio实现房地产开放日跟进的自动化
If
Set
Code
+9
32 节点Kaden Reese
内容创作
基于AI的新闻转视频生成器（使用Heygen和GPT4o）
使用Heygen和GPT-4o将RSS新闻转换为AI虚拟形象视频
Set
Code
Wait
+9
18 节点David Olusola
设计
使用Postiz自动创建AI新闻视频并发布到社交媒体
使用GPT-4o和HeyGen创建AI新闻视频并发布到社交媒体
Set
Code
Wait
+10
37 节点David Olusola
内容创作
LinkedIn潜在客户生成与CRM自动化套件
使用Apify提取LinkedIn个人资料并为Google Sheets CRM自动生成潜在客户数据
If
Set
Code
+7
18 节点David Olusola
潜在客户开发
工作流信息
难度等级
高级
节点数量23
分类1
节点类型10
作者
David Olusola
@dae221I help ambitious businesses eliminate operational bottlenecks and scale faster with AI automation. My clients typically see 40-60% efficiency gains within 90 days. Currently accepting 3 new projects this quarter - david@daexai.com
外部链接
在 n8n.io 查看 →
分享此工作流