中文网

医院外联自动化系统：通过Google表格和Gmail发送个性化邮件

中级

这是一个Content Creation、Multimodal AI领域的自动化工作流，包含 11 个节点。主要使用 Code、Gmail、Switch、GoogleSheets、SplitInBatches 等节点。 医院外联自动化系统：通过Google表格和Gmail发送个性化邮件

前置要求
  • •Google 账号和 Gmail API 凭证
  • •Google Sheets API 凭证

使用的节点 (11 个)

Code
Gmail
Switch
StickyNote
GoogleSheets
SplitInBatches
ChatTrigger

分类

Content Creation
Multimodal AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "meta": {
    "instanceId": "5d8ded8ed85f32cb4dbffdc338bf9f00b9b1ab189dbbed41f77a5c21e99276af",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "96056900-7870-4d4e-91a6-2f64177c7109",
      "name": "棉兰老岛",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -144,
        240
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1968569642,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1dNEKLvwSBgUvMJd1ekxz-R5_RN3ewlJTCOIHW4-bhIQ/edit#gid=1968569642",
          "cachedResultName": "Mindanao"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1dNEKLvwSBgUvMJd1ekxz-R5_RN3ewlJTCOIHW4-bhIQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1dNEKLvwSBgUvMJd1ekxz-R5_RN3ewlJTCOIHW4-bhIQ/edit?usp=drivesdk",
          "cachedResultName": "PH HOSPITALs"
        }
      },
      "credentials": {},
      "typeVersion": 4.7
    },
    {
      "id": "e78171fa-2463-478c-a9f4-03eebbda963d",
      "name": "维萨亚斯文件",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -144,
        48
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ $json.hospital }}",
              "lookupColumn": "Hospital Name"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 822141156,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1dNEKLvwSBgUvMJd1ekxz-R5_RN3ewlJTCOIHW4-bhIQ/edit#gid=822141156",
          "cachedResultName": "Visayas"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1dNEKLvwSBgUvMJd1ekxz-R5_RN3ewlJTCOIHW4-bhIQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1dNEKLvwSBgUvMJd1ekxz-R5_RN3ewlJTCOIHW4-bhIQ/edit?usp=drivesdk",
          "cachedResultName": "PH HOSPITALs"
        }
      },
      "credentials": {},
      "typeVersion": 4.7
    },
    {
      "id": "d9705318-8318-46f9-bff3-2bdb2f0ca121",
      "name": "吕宋文件",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -144,
        -144
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ $json.hospital }}",
              "lookupColumn": "Hospital Name"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 678847961,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1dNEKLvwSBgUvMJd1ekxz-R5_RN3ewlJTCOIHW4-bhIQ/edit#gid=678847961",
          "cachedResultName": "Luzon"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1dNEKLvwSBgUvMJd1ekxz-R5_RN3ewlJTCOIHW4-bhIQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1dNEKLvwSBgUvMJd1ekxz-R5_RN3ewlJTCOIHW4-bhIQ/edit?usp=drivesdk",
          "cachedResultName": "PH HOSPITALs"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "b19960c1-5e4b-4a81-adc3-be75854ef747",
      "name": "当收到聊天消息时",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -1040,
        216
      ],
      "webhookId": "7c234d39-d75e-4791-94cc-b5aa633df171",
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.3
    },
    {
      "id": "3821c377-95eb-42ca-8d97-e6c4d7379016",
      "name": "医院解析器",
      "type": "n8n-nodes-base.code",
      "position": [
        -816,
        216
      ],
      "parameters": {
        "jsCode": "const rawText = $input.first().json.chatInput;\nconst lines = rawText.split('\\n').filter(line => line.trim() !== '');\nconst region = lines[0] || 'Unknown';\nconst hospitals = lines.slice(1);\n\n// Return one item per hospital\nreturn hospitals.map(h => ({\n  json: {\n    region: region,\n    hospital: h\n  }\n}));\n"
      },
      "typeVersion": 2
    },
    {
      "id": "f13b30e3-2df2-4dc9-86b3-e0bd7012ecc9",
      "name": "批量发送器",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -592,
        216
      ],
      "parameters": {
        "options": {
          "reset": false
        }
      },
      "typeVersion": 3
    },
    {
      "id": "d3c1de1b-d9e8-467a-ab7a-e8f2478b6c9a",
      "name": "区域切换器",
      "type": "n8n-nodes-base.switch",
      "position": [
        -368,
        32
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": false,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "89b82ead-f3b3-49dc-bdd8-f4099fdb59cf",
                    "operator": {
                      "type": "string",
                      "operation": "contains"
                    },
                    "leftValue": "={{ $json.region }}",
                    "rightValue": "=LUZON"
                  }
                ]
              }
            },
            {
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": false,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "3930e266-a3c8-4c92-82f2-93d4cf6e840c",
                    "operator": {
                      "type": "string",
                      "operation": "contains"
                    },
                    "leftValue": "={{ $json.region }}",
                    "rightValue": "=VISAYAS"
                  }
                ]
              }
            },
            {
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": false,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "8048a6d6-54c1-4fe9-80e6-c56cd5392c53",
                    "operator": {
                      "type": "string",
                      "operation": "contains"
                    },
                    "leftValue": "={{ $json.region }}",
                    "rightValue": "=MINDANAO"
                  }
                ]
              }
            }
          ]
        },
        "options": {
          "ignoreCase": true,
          "allMatchingOutputs": false
        }
      },
      "typeVersion": 3.2
    },
    {
      "id": "2119f413-e8cb-40a6-af1f-fddfd0b56700",
      "name": "发送Gmail消息",
      "type": "n8n-nodes-base.gmail",
      "position": [
        80,
        136
      ],
      "webhookId": "9b7e7cd3-4959-4e16-be0a-f51fb53929be",
      "parameters": {
        "sendTo": "={{ $json['Main Email'] }}",
        "message": "=<p>Dear {{ $json[\"Hospital Name\"] }},</p>\n\n<p>My name is {{ $json[\"Your Name\"] }}, a {{ $json[\"Your Credentials\"] }}.</p>\n\n<p>During a recent hospital admission, I personally experienced the challenges of paper-based real-time billing—waiting for updated estimates, relying on manual printouts, and facing delays when clarity was needed most. This inspired me to build a working demo system tailored for hospitals like {{ $json[\"Sample Hospitals\"] }}.</p>\n\n<p><b>Here’s a quick overview of what I built:</b></p>\n\n<p>📹 Video 1: {{ $json[\"Video Link 1\"] }}</p>\n<p>📹 Video 2: {{ $json[\"Video Link 2\"] }}</p>\n<p>📹 Video 3: {{ $json[\"Video Link 3\"] }}</p>\n\n<p>✅ Patients can receive secure login credentials by email and check their real-time running bill anytime.<br>\n✅ The hospital can save costs by reducing paper use while improving transparency.<br>\n✅ Admin staff can manage patients and services from a centralized panel.</p>\n\n<p>Would you be available this week for a quick discussion?</p>\n\n<p>--<br>\nBest regards,<br>\n{{ $json[\"Your Name\"] }}<br>\n{{ $json[\"Your Contact\"] }}</p>\n",
        "options": {},
        "subject": "=Letter of Intent: {{ $json['Hospital Name'] }}"
      },
      "typeVersion": 2.1
    },
    {
      "id": "e93525d1-ab66-47f7-ab98-77594a58b622",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1416,
        -368
      ],
      "parameters": {
        "width": 1728,
        "height": 768,
        "content": "### **对于主黄色便签（放在工作流顶部）：**"
      },
      "typeVersion": 1
    },
    {
      "id": "6545ccf7-b4a2-4f59-829a-d637479776ff",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1392,
        -176
      ],
      "parameters": {
        "color": 4,
        "width": 464,
        "height": 304,
        "content": "**需要设置：**"
      },
      "typeVersion": 1
    },
    {
      "id": "8652c245-c942-436a-b037-051efecba80a",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        -176
      ],
      "parameters": {
        "color": 4,
        "width": 352,
        "height": 80,
        "content": "YouTube教程：https://www.youtube.com/embed/5u9W-Iegq6k"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "MINDANAO": {
      "main": [
        [
          {
            "node": "Send Gmail Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "LUZON FILES": {
      "main": [
        [
          {
            "node": "Send Gmail Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Batch Sender": {
      "main": [
        [],
        [
          {
            "node": "Region Switcher",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "VISAYAS FILES": {
      "main": [
        [
          {
            "node": "Send Gmail Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Hospital Parser": {
      "main": [
        [
          {
            "node": "Batch Sender",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Region Switcher": {
      "main": [
        [
          {
            "node": "LUZON FILES",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "VISAYAS FILES",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "MINDANAO",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Gmail Message": {
      "main": [
        [
          {
            "node": "Batch Sender",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When chat message received": {
      "main": [
        [
          {
            "node": "Hospital Parser",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

这是一个中级难度的工作流，适用于Content Creation、Multimodal AI等场景。适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

需要付费吗？

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

相关工作流推荐

使用Replicate和OpenAI制作无面孔恐怖短片
通过OpenAI TTS、Replicate视频生成和YouTube上传制作无面孔恐怖短片
If
Code
Wait
+13
50 节点Deb Mukherjee
Content Creation
基于AI的潜在客户资格评定与个性化触达（使用Relevance AI）
基于AI的潜在客户资格评定与个性化触达：使用Relevance AI
Set
Code
Gmail
+11
34 节点Diptamoy Barman
Content Creation
✨🩷自动化社交媒体内容发布工厂 + 系统提示组合
基于动态系统提示和GPT-4o的AI驱动多平台社交媒体内容工厂
If
Set
Code
+20
100 节点Amit Mehta
Content Creation
已验证产品退货指南生成器
使用邮件验证、PDF/图片生成和二维码自动化电商退货指南
Set
Code
Gmail
+10
23 节点Jitesh Dugar
Content Creation
自动化网红营销活动管理系统
使用Instagram/YouTube API自动化网红评估与活动管理
If
Code
Gmail
+8
24 节点Jitesh Dugar
Content Creation
Apollo 数据抓取与触达流程 1 ✅
使用 Apollo、AI 解析和定时邮件跟进自动生成潜在客户
If
Code
Wait
+13
39 节点Deniz
Content Creation
工作流信息
难度等级
中级
节点数量11
分类2
节点类型7
难度说明

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

作者
Hans Wilhelm Radam

Hans Wilhelm Radam

@hwmr
外部链接
在 n8n.io 上查看 →

分享此工作流