8
n8n 中文网amn8n.com

医疗账单自动化模板

中级

这是一个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)可能需要您自行付费。

工作流信息
难度等级
中级
节点数量11
分类1
节点类型8
难度说明

适合有一定经验的用户,包含 6-15 个节点的中等复杂度工作流

作者
David Olusola

David Olusola

@dae221

I 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 查看

分享此工作流