医疗账单自动化模板
中级
这是一个Finance领域的自动化工作流,包含 11 个节点。主要使用 If, Set, Code, Gmail, FormTrigger 等节点。 使用Google Sheets和Gmail自动化医疗账单处理
前置要求
- •Google 账号和 Gmail API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"id": "pJLEzimgy33CTesQ",
"meta": {
"instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc",
"templateCredsSetupCompleted": true
},
"name": "医疗账单自动化模板",
"tags": [],
"nodes": [
{
"id": "a35b7936-081d-40cd-ab1d-be7104135780",
"name": "数据结构1",
"type": "n8n-nodes-base.set",
"position": [
-240,
980
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c7c3c834-7415-478a-8d14-9435249da169",
"name": "错误检查1",
"type": "n8n-nodes-base.if",
"position": [
400,
980
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3ab7cc86-44bb-457a-b55a-b2289fa1a436",
"name": "管理员通知1",
"type": "n8n-nodes-base.httpRequest",
"position": [
780,
1020
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a04df0cf-b88f-4548-a574-4f0b43d159dd",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
-440,
980
],
"webhookId": "1fd452db-53ad-43a0-b3b0-5150ac15b5e2",
"parameters": {},
"typeVersion": 2.2
},
{
"id": "0739a55b-cfdd-47b5-8168-5af16cd71465",
"name": "计算价格",
"type": "n8n-nodes-base.code",
"position": [
200,
980
],
"parameters": {},
"typeVersion": 2
},
{
"id": "aa8322bd-f007-4ce5-8bc4-51c705cffe1e",
"name": "格式化日期",
"type": "n8n-nodes-base.code",
"position": [
-40,
980
],
"parameters": {},
"typeVersion": 2
},
{
"id": "43105af9-fb2f-483f-9c5c-1d6baa6688bc",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-460,
740
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6ad456b7-69ef-419a-9e69-da5620c747f7",
"name": "生成错误消息1",
"type": "n8n-nodes-base.set",
"position": [
580,
1020
],
"parameters": {},
"typeVersion": 1
},
{
"id": "83cd63f1-91cb-4f7e-8950-8a9a07e8e582",
"name": "发送患者发票邮件",
"type": "n8n-nodes-base.gmail",
"position": [
560,
840
],
"webhookId": "4d3f2c71-62f6-439b-8999-935bb545bbba",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "e93ac2e2-113f-463d-a4f8-215cf6bf1d66",
"name": "记录发票到Google表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
780,
840
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "6e3cb4a0-e9f4-4625-a87e-05009c16453f",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
340,
720
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "a4080380-112f-49c8-8031-08535b92cb04",
"connections": {
"Format Date": {
"main": [
[
{
"node": "Calculate prices",
"type": "main",
"index": 0
}
]
]
},
"Error Check1": {
"main": [
[
{
"node": "Generate Error Message1",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Patient Invoice Email",
"type": "main",
"index": 0
}
]
]
},
"Data Structure1": {
"main": [
[
{
"node": "Format Date",
"type": "main",
"index": 0
}
]
]
},
"Calculate prices": {
"main": [
[
{
"node": "Error Check1",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "Data Structure1",
"type": "main",
"index": 0
}
]
]
},
"Generate Error Message1": {
"main": [
[
{
"node": "Admin Notification1",
"type": "main",
"index": 0
}
]
]
},
"Send Patient Invoice Email": {
"main": [
[
{
"node": "Log Invoice to Googlesheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 财务
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
AI潜在客户机器专业版:Google地图→Slack→HubSpot→$$$
使用Google地图、GPT-4和HubSpot的自动化潜在客户生成与资格认证
If
Set
Code
+7
16 节点David Olusola
销售
GPT-4o与错误处理的自动化简历筛选 - Google表格与云端硬盘流程
GPT-4o与错误处理的自动化简历筛选 - Google表格与云端硬盘流程
If
Set
Gmail
+12
34 节点David Olusola
内容创作
LinkedIn潜在客户生成与CRM自动化套件
使用Apify提取LinkedIn个人资料并为Google Sheets CRM自动生成潜在客户数据
If
Set
Code
+7
18 节点David Olusola
潜在客户开发
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
使用Gmail、GPT-4和向量知识库的自动化客户支持系统
使用Gmail、GPT-4和向量知识库的自动化客户支持系统
If
Set
Code
+15
32 节点Khair Ahammed
AI RAG 检索增强
使用Apify和DeepSeek AI批量分析YouTube频道内容至Google表格
使用Apify和DeepSeek AI批量分析YouTube频道内容至Google表格
If
Set
Code
+14
33 节点OwenLee
工作流信息
难度等级
中级
节点数量11
分类1
节点类型8
作者
David Olusola
@dae221I love building smart, efficient automations with n8n that help businesses save time and scale effortlessly. Turning complex workflows into simple solutions is where I have the most fun
外部链接
在 n8n.io 查看 →
分享此工作流