Ereignisbericht-Management

• •Google-Konto + Gmail API-Anmeldedaten
• •Google Sheets API-Anmeldedaten

{
  "id": "mlOnE7wm6wS6tn0M",
  "meta": {
    "instanceId": "14e4c77104722ab186539dfea5182e419aecc83d85963fe13f6de862c875ebfa",
    "templateCredsSetupCompleted": true
  },
  "name": "Incident_Reporting_Management",
  "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": "Bei Formularübermittlung",
      "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": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -200,
        -200
      ],
      "parameters": {
        "width": 960,
        "height": 520,
        "content": "## Incident Reporting & Management Workflow (n8n + Webhook + Google Sheets + Email)"
      },
      "typeVersion": 1
    },
    {
      "id": "adb4e42a-d008-4c6a-965a-3186be80d97c",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -200,
        340
      ],
      "parameters": {
        "width": 960,
        "height": 640,
        "content": "## Description\n\n**1. Node: On form submission**\nRecommended Name in n8n:\nForm Submission Webhook\n\nReceives incident report data from the Google Form (via webhook trigger).\nThis node starts the workflow every time a new form entry is submitted.\n\n**2. Node: Google Sheets (append: sheet)**\nRecommended Name in n8n:\nLog Incident to Google Sheet\n\nAppends each new incident report as a row in the specified Google Sheet.\nCreates a real-time, easily auditable log of all incident submissions.\n\n**3. Node: Gmail (send: message)**\nRecommended Name in n8n:\nSend Alert Email to Support Team\n\nSends an immediate notification email to the support/response team.\nIncludes key incident details (such as message, location, severity, and timestamp) to ensure rapid awareness and response.\n\n**Sample Workflow Description (For Workflow/Group Note)**\nIncident Reporting & Management Workflow (Google Forms → n8n Webhook → Google Sheets & Email)"
      },
      "typeVersion": 1
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "672a4f78-8c29-49c3-83a2-55ddf7a0ef2a",
  "connections": {
    "c9ca02cf-abee-4988-948c-e2d4aaf435e1": {
      "main": [
        [
          {
            "node": "97daea45-1b4b-4e75-8857-6c6f749caa5d",
            "type": "main",
            "index": 0
          },
          {
            "node": "8a9da50c-7742-44f0-ab47-c1ffaa802d4a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}