8
n8n 中文网amn8n.com

医疗保健索赔

中级

这是一个AI Summarization, Multimodal AI领域的自动化工作流,包含 9 个节点。主要使用 GoogleDrive, GoogleSheets, VlmRun, GoogleDriveTrigger 等节点。 使用VLM Run、Google Drive和Sheets提取并处理医疗保健索赔

前置要求
  • Google Drive API 凭证
  • Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "K7Qgj2t2LiYmsePq",
  "meta": {
    "instanceId": "6e41c99fc72ee60a73d864359ddc42110d2e155de3fb4e7d01b7a6b357d5e8ec"
  },
  "name": "医疗保健索赔",
  "tags": [],
  "nodes": [
    {
      "id": "dff7701d-c30b-4a93-a2c0-a2d1b3f191e7",
      "name": "VLM 运行",
      "type": "@vlm-run/n8n-nodes-vlmrun.vlmRun",
      "position": [
        1136,
        496
      ],
      "parameters": {
        "domain": "healthcare.claims-processing"
      },
      "credentials": {
        "vlmRunApi": {
          "id": "AhqrLiODMllC9iCR",
          "name": "VLM Run account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "64b5605f-f09d-4f50-b834-4d90ce102ba7",
      "name": "在表格中追加行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1584,
        496
      ],
      "parameters": {
        "columns": {
          "value": {
            "FORM TYPE": "={{ $json.response.form_type }}",
            "AMOUNT DUE": "={{ $json.response.balance_due }}",
            "AMOUNT PAID": "={{ $json.response.amount_paid }}",
            "INSURED DOB": "={{ $json.response.insured_dob }}",
            "INSURED SEX": "={{ $json.response.insured_sex }}",
            "PATIENT SEX": "={{ $json.response.patient_sex }}",
            "CARRIER NAME": "={{ $json.response.carrier_name }}",
            "FORM VERSION": "={{ $json.response.form_version }}",
            "INSURANCE ID": "={{ $json.response.insured_id_number }}",
            "INSURED NAME": "={{ $json.response.insured_name }}",
            "PATIENT NAME": "={{ $json.response.patient_name }}",
            "TOTAL CHARGE": "={{ $json.response.total_charge }}",
            "AUTO ACCIDENT": "={{ $json.response.auto_accident }}",
            "INSURANCE TYPE": "={{ $json.response.insurance_type }}",
            "MARTIAL STATUS": "={{ $json.response.marital_status }}",
            "OTHER ACCIDENT": "={{ $json.response.other_accident }}",
            "INSURED ADDRESS": "={{ $json.response.insured_address.street }}, {{ $json.response.insured_address.city }}, {{ $json.response.insured_address.state }}, {{ $json.response.insured_address.zip_code }}",
            "PATIENT ADDRESS": "={{ $json.response.patient_address.street }}, {{ $json.response.patient_address.city }}, {{ $json.response.patient_address.state }}, {{ $json.response.patient_address.zip_code }}",
            "INSURED EMPLOYER": "={{ $json.response.insured_employer }}",
            "INSURED PHONE NO": "={{ $json.response.insured_address.phone }}",
            "PATIENT PHONE NO": "={{ $json.response.patient_address.phone }}",
            "PROCESSING NOTES": "={{ $json.response.processing_notes }}",
            "EMPLOYMENT STATUS": "={{ $json.response.employment_status }}",
            "OTHER INSURED DOB": "={{ $json.response.other_insured_dob }}",
            "OTHER INSURED SEX": "={{ $json.response.other_insured_sex }}",
            "UNABLE TO WORK TO": "={{ $json.response.unable_to_work_to }}",
            "EMPLOYMENT RELATED": "={{ $json.response.employment_related }}",
            "FORM APPROVAL DATE": "={{ $json.response.form_approval_date }}",
            "HOSPITALIZATION TO": "={{ $json.response.hospitalization_to }}",
            "OTHER INSURED NAME": "={{ $json.response.other_insured_name }}",
            "PATIENT ACCOUNT NO": "={{ $json.response.patient_account_number }}",
            "PATIENT BIRTH DATE": "={{ $json.response.patient_birth_date }}",
            "UNABLE TO WORK FROM": "={{ $json.response.unable_to_work_from }}",
            "CURRENT ILLNESS DATE": "={{ $json.response.current_illness_date }}",
            "HOSPITALIZATION FROM": "={{ $json.response.hospitalization_from }}",
            "INSURED POLICY GROUP": "={{ $json.response.insured_policy_group }}",
            "PATIENT RELATIONSHIP": "={{ $json.response.patient_relationship }}",
            "SIMILLAR ILLNESS DATE": "={{ $json.response.similar_illness_date }}",
            "INSURED INSURANCE PLAN": "={{ $json.response.insured_insurance_plan }}",
            "OTHER INSURED EMPLOYER": "={{ $json.response.other_insured_employer }}",
            "REFERRING PHYSICIAN NAME": "={{ $json.response.referring_physician_name }}",
            "OTHER INSURED POLICY GROUP": "={{ $json.response.other_insured_policy_group }}",
            "OTHER INSURED INSURANCE PLAN": "={{ $json.response.other_insured_insurance_plan }}"
          },
          "schema": [
            {
              "id": "FORM TYPE",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "FORM TYPE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "FORM VERSION",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "FORM VERSION",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "FORM APPROVAL DATE",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "FORM APPROVAL DATE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CARRIER NAME",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "CARRIER NAME",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PATIENT NAME",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "PATIENT NAME",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PATIENT BIRTH DATE",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "PATIENT BIRTH DATE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PATIENT SEX",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "PATIENT SEX",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PATIENT ADDRESS",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "PATIENT ADDRESS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PATIENT RELATIONSHIP",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "PATIENT RELATIONSHIP",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PATIENT PHONE NO",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "PATIENT PHONE NO",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "MARTIAL STATUS",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "MARTIAL STATUS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "EMPLOYMENT STATUS",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "EMPLOYMENT STATUS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "EMPLOYMENT RELATED",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "EMPLOYMENT RELATED",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "AUTO ACCIDENT",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "AUTO ACCIDENT",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "OTHER ACCIDENT",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "OTHER ACCIDENT",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CURRENT ILLNESS DATE",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "CURRENT ILLNESS DATE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "SIMILLAR ILLNESS DATE",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "SIMILLAR ILLNESS DATE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "UNABLE TO WORK FROM",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "UNABLE TO WORK FROM",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "UNABLE TO WORK TO",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "UNABLE TO WORK TO",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "HOSPITALIZATION FROM",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "HOSPITALIZATION FROM",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "HOSPITALIZATION TO",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "HOSPITALIZATION TO",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PATIENT ACCOUNT NO",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "PATIENT ACCOUNT NO",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "TOTAL CHARGE",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "TOTAL CHARGE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "AMOUNT DUE",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "AMOUNT DUE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "AMOUNT PAID",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "AMOUNT PAID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PROCESSING NOTES",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "PROCESSING NOTES",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "INSURANCE TYPE",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "INSURANCE TYPE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "INSURANCE ID",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "INSURANCE ID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "INSURED NAME",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "INSURED NAME",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "INSURED ADDRESS",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "INSURED ADDRESS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "INSURED PHONE NO",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "INSURED PHONE NO",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "INSURED POLICY GROUP",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "INSURED POLICY GROUP",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "INSURED DOB",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "INSURED DOB",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "INSURED SEX",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "INSURED SEX",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "INSURED EMPLOYER",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "INSURED EMPLOYER",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "INSURED INSURANCE PLAN",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "INSURED INSURANCE PLAN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "OTHER INSURED NAME",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "OTHER INSURED NAME",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "OTHER INSURED POLICY GROUP",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "OTHER INSURED POLICY GROUP",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "OTHER INSURED DOB",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "OTHER INSURED DOB",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "OTHER INSURED SEX",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "OTHER INSURED SEX",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "OTHER INSURED EMPLOYER",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "OTHER INSURED EMPLOYER",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "OTHER INSURED INSURANCE PLAN",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "OTHER INSURED INSURANCE PLAN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "REFERRING PHYSICIAN NAME",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "REFERRING PHYSICIAN NAME",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1wZQDu7Hd0iV8dqiLbfUzAwUqKnn8J0ZQFO1weZ_ShxQ/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1wZQDu7Hd0iV8dqiLbfUzAwUqKnn8J0ZQFO1weZ_ShxQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1wZQDu7Hd0iV8dqiLbfUzAwUqKnn8J0ZQFO1weZ_ShxQ/edit?usp=drivesdk",
          "cachedResultName": "healthcare claim"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "aUPujCcLeYbPycay",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "987c7ffd-585d-4085-b0bf-b63eac78101c",
      "name": "下载文件",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        688,
        496
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.id }}"
        },
        "options": {},
        "operation": "download"
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "DtDkJCU9nVKysM6o",
          "name": "Google Drive account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "3701588b-56b9-46f1-8c31-313db03fb822",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -368,
        -64
      ],
      "parameters": {
        "color": 7,
        "width": 416,
        "height": 816,
        "content": "# 使用 VLM Run 处理医疗保健索赔"
      },
      "typeVersion": 1
    },
    {
      "id": "8a66280c-ff0d-44c5-ae9e-7a39410778ca",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        -64
      ],
      "parameters": {
        "color": 7,
        "width": 416,
        "height": 816,
        "content": "# Google Drive 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "53a10d19-f9c0-4fc6-8c0e-a4c78c3909be",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1424,
        -64
      ],
      "parameters": {
        "color": 7,
        "width": 416,
        "height": 816,
        "content": "# 在表格中附加行"
      },
      "typeVersion": 1
    },
    {
      "id": "2dc3bb38-d9ed-4400-ba6b-199223f172bf",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        -64
      ],
      "parameters": {
        "width": 416,
        "height": 816,
        "content": "# VLM Run(文档)"
      },
      "typeVersion": 1
    },
    {
      "id": "6e706843-c753-4115-b4af-0a6220f67256",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        528,
        -64
      ],
      "parameters": {
        "color": 7,
        "width": 416,
        "height": 816,
        "content": "# 下载文件"
      },
      "typeVersion": 1
    },
    {
      "id": "192f8b59-502c-40c8-8ef2-9a38e67095fb",
      "name": "Google Drive 触发器",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        224,
        496
      ],
      "parameters": {
        "event": "fileCreated",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "triggerOn": "specificFolder",
        "folderToWatch": {
          "__rl": true,
          "mode": "list",
          "value": "1E8rvLEWKguorMT36yCD1jY78G0u8g6g7",
          "cachedResultUrl": "https://drive.google.com/drive/folders/1E8rvLEWKguorMT36yCD1jY78G0u8g6g7",
          "cachedResultName": "test_data"
        }
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "DtDkJCU9nVKysM6o",
          "name": "Google Drive account"
        }
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "eb07b3aa-8a8d-416f-b2ae-59c1347f0837",
  "connections": {
    "VLM Run": {
      "main": [
        [
          {
            "node": "Append row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download file": {
      "main": [
        [
          {
            "node": "VLM Run",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Drive Trigger": {
      "main": [
        [
          {
            "node": "Download file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景?

中级 - AI 摘要总结, 多模态 AI

需要付费吗?

本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。

工作流信息
难度等级
中级
节点数量9
分类2
节点类型5
难度说明

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

作者
Shahrear

Shahrear

@shahrear

I’m Shahrear, a Software Engineer with over 5 years of experience in full-stack development and workflow automation. I specialize in building intelligent automations using n8n, helping teams streamline operations and boost productivity. I’m also an expert in developing custom n8n nodes, with published work on npm - including the @vlm-run/n8n-nodes-vlmrun package. Linkedin - https://www.linkedin.com/in/shahrear-amin/ Email - shahrearbinamin33@gmail.com

外部链接
在 n8n.io 查看

分享此工作流