8
n8n 中文网amn8n.com

事件报告管理

初级

这是一个Ticket Management, Multimodal AI领域的自动化工作流，包含 5 个节点。主要使用 Gmail, FormTrigger, GoogleSheets 等节点。 通过表单、Google Sheets和Gmail自动化事件报告与提醒

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

使用的节点 (5)

Gmail
StickyNote
FormTrigger
GoogleSheets

分类

工单管理
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "mlOnE7wm6wS6tn0M",
  "meta": {
    "instanceId": "14e4c77104722ab186539dfea5182e419aecc83d85963fe13f6de862c875ebfa",
    "templateCredsSetupCompleted": true
  },
  "name": "事件报告管理",
  "tags": [],
  "nodes": [
    {
      "id": "97daea45-1b4b-4e75-8857-6c6f749caa5d",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        220,
        120
      ],
      "webhookId": "b67a3892-6cdb-4417-8778-f80eb58f5d83",
      "parameters": {
        "sendTo": "=supportteam@mailinator.com",
        "message": "=Incident Reported: 🚨\n\nDate & Time: {{ $json[\"Date & Time of Incident\"] || $now }}\nReported By: {{ $json['Name of Reporter'] || \"Not provided\" }}\nEmail: {{ $json[\"Contact Email\"] || \"Not provided\" }}\nLocation: {{ $json[\"Location\"] }}\nCategory/Type: {{ $json[\"Incident Category/Type\"] || \"Not provided\" }}\nSeverity: {{ $json.Severity }}\n\nDescription:\n{{ $json['Detailed Description'] || \"Not provided\"}}\n\nActions Taken:\n{{ $json[\"actions\"] || \"Not provided\" }}\n\nAttachments: \n{{ $json[\"Attach Photos\"] }}\n\n----\nThis is an automated notification sent on {{ $now.format(\"HH 'hours and' mm 'minutes'\") }}.",
        "options": {
          "appendAttribution": false
        },
        "subject": "=Incident Alert: {{ $json.Severity}} - {{ $json[\"Detailed Description\"]?.substring(0, 50) }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "Kb30iigFce7pjkMZ",
          "name": "Gmail account 5"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "c9ca02cf-abee-4988-948c-e2d4aaf435e1",
      "name": "表单提交时",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        0,
        0
      ],
      "webhookId": "f287d0e4-56a2-48ba-b5ab-3a6625c98c19",
      "parameters": {
        "options": {},
        "formTitle": "Incident Report",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Name of Reporter",
              "placeholder": "Name of Reporter",
              "requiredField": true
            },
            {
              "fieldLabel": "Contact Email",
              "placeholder": "Email",
              "requiredField": true
            },
            {
              "fieldType": "date",
              "fieldLabel": "Date & Time of Incident",
              "requiredField": true
            },
            {
              "fieldLabel": "Location",
              "placeholder": "Location",
              "requiredField": true
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "Incident Category/Type",
              "fieldOptions": {
                "values": [
                  {
                    "option": "Equipment Failure"
                  },
                  {
                    "option": "Safety"
                  },
                  {
                    "option": "Security"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "Severity",
              "fieldOptions": {
                "values": [
                  {
                    "option": "Low"
                  },
                  {
                    "option": "Medium"
                  },
                  {
                    "option": "High"
                  },
                  {
                    "option": "Critical"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldLabel": "Detailed Description",
              "placeholder": "Description",
              "requiredField": true
            },
            {
              "fieldLabel": "Actions Taken",
              "placeholder": "Actions Taken"
            },
            {
              "fieldType": "file",
              "fieldLabel": "Attach Photos",
              "multipleFiles": false
            }
          ]
        },
        "formDescription": "Please use this form to report any incidents that require attention. Your report helps us quickly address issues and improve safety and operations. All information is confidential."
      },
      "typeVersion": 2.2
    },
    {
      "id": "8a9da50c-7742-44f0-ab47-c1ffaa802d4a",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        200,
        -112.46541527249559
      ],
      "parameters": {
        "columns": {
          "value": {
            "Location": "={{ $json.Location }}",
            "Severity": "={{ $json.Severity }}",
            "submitted_at": "={{ $json.submittedAt }}",
            "Actions Taken": "={{ $json[\"Actions Taken\"] }}",
            "Attach Photos": "={{ $json[\"Attach Photos\"] }}",
            "Contact Email": "={{ $json[\"Contact Email\"] }}",
            "Name of Reporter": "={{ $json[\"Name of Reporter\"] }}",
            "Detailed Description": "={{ $json[\"Detailed Description\"] }}",
            "Incident Category/Type": "={{ $json[\"Incident Category/Type\"] }}",
            "Date & Time of Incident": "={{ $json[\"Date & Time of Incident\"] }}"
          },
          "schema": [
            {
              "id": "Name of Reporter",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Name of Reporter",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Contact Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Contact Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Date & Time of Incident",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Date & Time of Incident",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Location",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Location",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Incident Category/Type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Incident Category/Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Severity",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Severity",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Detailed Description",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Detailed Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Actions Taken",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Actions Taken",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Attach Photos",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Attach Photos",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "submitted_at",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "submitted_at",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "DG43xmppQ7B2T3O7",
          "name": "Google Sheets account 2"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "67fdb422-0a14-434e-886f-c816834b565e",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -200,
        -200
      ],
      "parameters": {
        "width": 960,
        "height": 520,
        "content": "## 事件报告与管理工作流 (n8n + Webhook + Google Sheets + Email)"
      },
      "typeVersion": 1
    },
    {
      "id": "adb4e42a-d008-4c6a-965a-3186be80d97c",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -200,
        340
      ],
      "parameters": {
        "width": 960,
        "height": 640,
        "content": "## 描述"
      },
      "typeVersion": 1
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "672a4f78-8c29-49c3-83a2-55ddf7a0ef2a",
  "connections": {
    "On form submission": {
      "main": [
        [
          {
            "node": "Gmail",
            "type": "main",
            "index": 0
          },
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

初级 - 工单管理, 多模态 AI

需要付费吗？

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

相关工作流推荐

客户反馈循环分析器
使用AI、Google表格和Slack提醒自动分类客户反馈
Code
Gmail
Slack
+7
11 节点WeblineIndia
杂项
使用 HTTP Last-Modified 检查从 Google Sheets 获取职位发布过期和刷新提醒
通过 Google Sheets、HTTP 检查和 Gmail 实现职位发布过期提醒的自动化
If
Set
Code
+6
19 节点WeblineIndia
人力资源
从Google Sheets向Slack发送面试后反馈提醒（含邮件备用方案）
使用Google Sheets、Slack和Gmail自动化面试后反馈提醒
If
Gmail
Slack
+3
9 节点WeblineIndia
人力资源
BGV跟踪器
BGV状态每日摘要：使用Google表格跟踪验证状态并发送Gmail提醒
Code
Gmail
Google Sheets
+2
8 节点WeblineIndia
人力资源
太阳能发电监测预警工作流
监控太阳能发电并通过Gmail、Google表格和Slack发送警报
If
Code
Gmail
+5
9 节点WeblineIndia
工程
维护计划程序-通过ICS邮件
使用Google Sheets和Gmail ICS邀请发送预防性维护计划
Code
Gmail
Google Sheets
+3
7 节点WeblineIndia
项目管理
工作流信息
难度等级
初级
节点数量5
分类2
节点类型4
难度说明

适合 n8n 新手，包含 1-5 个节点的简单工作流

作者
WeblineIndia

WeblineIndia

@weblineindia

A Leading Software Engineering, Consulting & Outsourcing Services Company in USA & India serving Clients Globally since 1999.

外部链接
在 n8n.io 查看 →

分享此工作流