医疗健康邮件自动回复-每日外联
高级
这是一个Multimodal AI领域的自动化工作流，包含 19 个节点。主要使用 If, Set, Wait, Gmail, Limit 等节点。 使用OpenAI、Gmail和Google Sheets发送个性化医疗健康幽默邮件
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (19)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"name": "医疗健康邮件自动回复 - 每日外联",
"tags": [
"email",
"healthcare",
"automation",
"outreach",
"ai-powered"
],
"nodes": [
{
"id": "705daa92-e852-4e55-b508-ffab19804356",
"name": "AI 邮件生成器",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-464,
208
],
"parameters": {
"text": "=Write a friendly email to {{ $json['First Name'] }}\n\nRefer to System message for Context\n",
"options": {
"systemMessage": "=You are a professional healthcare representative writing personalized outreach emails.\n\nUse the following details to craft a friendly and professional email:\n\nRecipient Name: {{ $json['First Name'] }}\n\nWrite an email with the subject line: \"Medical joke of the day\"\n\nEmail body:\nHi {{ $json['First Name'] }},\n\nWhy did the nurse carry a pencil to every shift?\nBecause charting smiles is just as important as charting vitals! 🩺✏️😄\n\nA little laughter is great medicine—no co-pay required.\nWishing you a week full of wellness and giggles!\nWarm regards,\n\n[YOUR NAME HERE] \n[YOUR TITLE HERE] \n[YOUR COMPANY HERE] \n📞 ([YOUR PHONE NUMBER]) \n📧 ([YOUR EMAIL]) \n🌐 ([YOUR WEBSITE])\n\nReturn only the full email body as plain text."
},
"promptType": "define"
},
"typeVersion": 1.9,
"alwaysOutputData": true
},
{
"id": "27bc7664-f669-4c7c-b5c1-1af7c7659937",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-640,
288
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"typeVersion": 1.2
},
{
"id": "b508c9c4-2f17-4ac9-a551-373ceb833032",
"name": "发送邮件",
"type": "n8n-nodes-base.gmail",
"position": [
192,
208
],
"webhookId": "b49a4225-b64d-4cc2-b77a-7fca5aabf535",
"parameters": {
"sendTo": "={{ $('Healthcare_Contact_List').item.json.Email }}",
"message": "={{ $json.output }}",
"options": {
"appendAttribution": false
},
"subject": "=Medical joke of the day",
"emailType": "text"
},
"typeVersion": 2.1
},
{
"id": "46098a2d-31cc-4fab-9921-2e3547a04d4e",
"name": "随机等待 (2-5分钟)",
"type": "n8n-nodes-base.wait",
"position": [
432,
208
],
"webhookId": "6dd3fac9-b65f-4e03-821f-179c84410bb7",
"parameters": {
"unit": "minutes",
"amount": "={{ Math.floor(Math.random() * 4) + 2 }}"
},
"typeVersion": 1.1
},
{
"id": "2bf6901a-93c0-4d9f-b00a-3c3397ede2ee",
"name": "📋 工作流概述",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1136,
-304
],
"parameters": {
"color": 1,
"width": 660,
"height": 320,
"content": "## 医疗健康邮件自动回复 📧"
},
"typeVersion": 1
},
{
"id": "c5efe867-8991-4abb-bd99-b714a85bb742",
"name": "✨ AI 个性化",
"type": "n8n-nodes-base.stickyNote",
"position": [
-704,
-16
],
"parameters": {
"color": 3,
"width": 560,
"height": 460,
"content": "## ✨ AI 邮件生成"
},
"typeVersion": 1
},
{
"id": "b8a01b3d-a9f6-4fb5-a711-eb01f497d577",
"name": "⏰ 速率限制",
"type": "n8n-nodes-base.stickyNote",
"position": [
368,
-304
],
"parameters": {
"color": 4,
"width": 200,
"height": 740,
"content": "## ⏰ 智能定时"
},
"typeVersion": 1
},
{
"id": "13d7a01d-b426-496f-9dec-d164aec411bb",
"name": "🎯 批次控制",
"type": "n8n-nodes-base.stickyNote",
"position": [
-144,
-304
],
"parameters": {
"color": 5,
"width": 220,
"height": 740,
"content": "## 🎯 批处理"
},
"typeVersion": 1
},
{
"id": "8653790a-57ef-4a25-b707-cadb2648a92f",
"name": "📊 进度跟踪",
"type": "n8n-nodes-base.stickyNote",
"position": [
112,
-304
],
"parameters": {
"color": 2,
"height": 740,
"content": "## 📊 邮件跟踪"
},
"typeVersion": 1
},
{
"id": "1a02bc39-cd6b-467d-9f65-4a86183eea31",
"name": "🔄 顺序处理",
"type": "n8n-nodes-base.stickyNote",
"position": [
-464,
-304
],
"parameters": {
"color": 3,
"width": 300,
"height": 260,
"content": "## 🔄 处理流程"
},
"typeVersion": 1
},
{
"id": "d9c64ea9-ebc9-4e04-9383-6ea90cc629ae",
"name": "验证邮箱地址",
"type": "n8n-nodes-base.if",
"position": [
-608,
-208
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6f8c6147-ff4d-4595-9901-920af56a9338",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "Email",
"rightValue": ""
},
{
"id": "e69364ce-e8b3-4d15-8832-383067a26f2d",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{$json[\"Email\"]}}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "60bbf82f-34f9-4d06-becb-ffbf57200447",
"name": "跳过无效邮箱",
"type": "n8n-nodes-base.noOp",
"position": [
-976,
224
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f506ec0f-9104-4060-8a3f-8345ae82baa7",
"name": "逐个处理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-368,
-176
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "1add1e3a-b8a9-4993-bbbc-f7c47e3daa26",
"name": "准备邮件数据",
"type": "n8n-nodes-base.set",
"position": [
-80,
208
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "75df7330-f51c-4dd1-bb30-586787576d60",
"name": "Email",
"type": "string",
"value": "={{ $json.Email }}"
},
{
"id": "d9c981b6-ccd0-4083-ae4c-852d3e0f21c6",
"name": "First Name",
"type": "string",
"value": "={{ $json['First Name'] }}"
},
{
"id": "57f579f2-6b1d-4c15-ab05-a5f9231cad3a",
"name": "EmailContent",
"type": "string",
"value": "={{ $node[\"AI Email Generator\"].json[\"output\"] }}"
}
]
}
},
"typeVersion": 3.4,
"alwaysOutputData": false
},
{
"id": "a279d1d1-28f3-49ae-9481-f303771a0e29",
"name": "限制为10个联系人",
"type": "n8n-nodes-base.limit",
"position": [
-768,
-208
],
"parameters": {
"maxItems": 10
},
"typeVersion": 1
},
{
"id": "0a3b8596-d0c2-481f-979a-b7e3b3b70bd3",
"name": "🚀 使用场景",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1136,
-16
],
"parameters": {
"color": 6,
"width": 420,
"height": 460,
"content": "## 🚀 自动化医疗健康外联"
},
"typeVersion": 1
},
{
"id": "12f7f1c7-e58d-4b00-91b3-8a390697426f",
"name": "医疗健康联系人列表",
"type": "n8n-nodes-base.googleSheets",
"position": [
-944,
-208
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupColumn": "Emailed"
}
]
},
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID_HERE"
}
},
"typeVersion": 4.5
},
{
"id": "66e2da4a-1b0f-462d-aad9-04d3ce778500",
"name": "更新邮件状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
432,
-64
],
"parameters": {
"columns": {
"value": {
"Emailed": "={{ $now }}",
"row_number": "={{ $('Healthcare_Contact_List').item.json.row_number }}"
},
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
]
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID_HERE"
}
},
"typeVersion": 4.5
},
{
"id": "f2c8bf61-3e37-477b-9894-e0d51d381f13",
"name": "每日触发器 (下午1点)",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1104,
-208
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 13
}
]
}
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"timezone": "America/Chicago",
"executionOrder": "v1"
},
"connections": {
"Send Email": {
"main": [
[
{
"node": "Random Wait (2-5min)",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Email Generator",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"AI Email Generator": {
"main": [
[
{
"node": "Prepare Email Data",
"type": "main",
"index": 0
}
]
]
},
"Prepare Email Data": {
"main": [
[
{
"node": "Send Email",
"type": "main",
"index": 0
}
]
]
},
"Process One by One": {
"main": [
[],
[
{
"node": "AI Email Generator",
"type": "main",
"index": 0
}
]
]
},
"Daily Trigger (1 PM)": {
"main": [
[
{
"node": "Healthcare_Contact_List",
"type": "main",
"index": 0
}
]
]
},
"Limit to 10 Contacts": {
"main": [
[
{
"node": "Validate Email Address",
"type": "main",
"index": 0
}
]
]
},
"Random Wait (2-5min)": {
"main": [
[
{
"node": "Process One by One",
"type": "main",
"index": 0
},
{
"node": "Update Email Status",
"type": "main",
"index": 0
}
]
]
},
"Validate Email Address": {
"main": [
[
{
"node": "Process One by One",
"type": "main",
"index": 0
}
],
[
{
"node": "Skip Invalid Email",
"type": "main",
"index": 0
}
]
]
},
"Healthcare_Contact_List": {
"main": [
[
{
"node": "Limit to 10 Contacts",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
完整的 B2B 销售流程：Apollo 潜在客户生成、Mailgun 外展和 AI 回复管理
完整的 B2B 销售流程：Apollo 潜在客户生成、Mailgun 外展和 AI 回复管理
If
Set
Code
+26
116 节点Paul
内容创作
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
Apollo 数据抓取与触达流程 1 ✅
使用 Apollo、AI 解析和定时邮件跟进自动生成潜在客户
If
Code
Wait
+13
39 节点Deniz
内容创作
使用AI自动化Morning Brew风格Reddit摘要并发布至DEV
使用AI自动化Morning Brew风格Reddit摘要并发布至DEV
If
Set
Wait
+13
26 节点Angel Menendez
AI 摘要总结
GPT-4驱动的冷邮件工作流，包含完全定制的3封邮件跟进
使用GPT-4、Mailgun和Supabase自动化个性化冷邮件序列
If
Set
Code
+22
100 节点Paul
客户培育
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
工作流信息
难度等级
高级
节点数量19
分类1
节点类型12
作者
Ronnie Craig
@ronnie-craig-2025Hi, I’m Ronnie! I scaled an eCommerce biz to $14K/month in under a year, grew a YouTube channel to 1K subs in 30 days, booked 28 daycare appointments in 6 days, and built automations for nurses to track clients. I help you create content, repurpose high-performing posts, schedule with ease, monitor trends, and automate marketing—so you stay visible and consistent without burning out.
外部链接
在 n8n.io 查看 →
分享此工作流