{
  "name": "Automate incident response with Jira, Slack, Google Sheets & Drive",
  "nodes": [
    {
      "id": "70b38182-4e4c-4f33-9955-18712a2734ef",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1008,
        -48
      ]
    },
    {
      "id": "c5e9b101-a3bb-4095-9931-10cb47abf60c",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1760,
        176
      ],
      "parameters": {
        "width": null,
        "height": 560,
        "content": "## ☁️ Archive Incident Timeline to Drive\n**Action:** Saves incident timeline report to Google Drive for permanent storage.\n\n**Description:**\n- Uploads to designated folder (rename to \"Incident Reports"
      }
    },
    {
      "id": "1701890b-1a58-4f8e-8d96-94bb3d717d1d",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1440,
        160
      ],
      "parameters": {
        "width": null,
        "height": 496,
        "content": "## 📄 Convert Timeline to Text File\n**Action:** Transforms incident timeline report into downloadable .txt file.\n\n**Description:**\n- Creates properly formatted text file from timeline string\n- Filename"
      }
    },
    {
      "id": "eb3eeb1a-0b12-46d3-8272-47ae01ab3185",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1120,
        144
      ],
      "parameters": {
        "width": null,
        "height": 608,
        "content": "## 📋 Generate Incident Timeline Report\n**Action:** Creates comprehensive incident timeline from Slack message data.\n\n**Description:**\n- Parses Slack message blocks to extract incident details\n- Handle"
      }
    },
    {
      "id": "1d0f80e7-e631-4054-9159-3c4db04f7d37",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        864,
        -544
      ],
      "parameters": {
        "width": 256,
        "height": 464,
        "content": "## 📢 Alert On-Call Team in Slack\n**Action:** Posts incident notification to #oncall Slack channel.\n\n**Description:**\n- Delivers formatted alert to dedicated incident response channel\n- Includes: Jira "
      }
    },
    {
      "id": "0e077e72-3423-4e55-b44d-592152210bdc",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        672,
        144
      ],
      "parameters": {
        "width": null,
        "height": 544,
        "content": "## 💬 Format Incident Alert for Slack\n**Action:** Generates rich, formatted Slack message with incident details.\n\n**Description:**\n- Safely extracts data from merged incident and Jira objects\n- Builds "
      }
    },
    {
      "id": "1d072007-08da-468c-8588-673d4b714502",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        -640
      ],
      "parameters": {
        "width": null,
        "height": 528,
        "content": "## 🔗 Combine Incident & Jira Data\n**Action:** Merges incident metadata with Jira ticket information.\n\n**Description:**\n- Combines two data streams:\n  1. Incident details from Define Metadata node\n  2."
      }
    },
    {
      "id": "13809897-974f-4371-b18c-fcbc03a4fe4c",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -528,
        240
      ],
      "parameters": {
        "width": null,
        "height": 480,
        "content": "## 🎫 Create Jira Incident Ticket\n**Action:** Automatically creates Jira task in incident management project.\n\n**Description:**\n- Creates ticket with formatted summary: \"[Severity] Service - Descriptio"
      }
    },
    {
      "id": "1585af90-5926-46c1-8682-3c3f61682271",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -848,
        128
      ],
      "parameters": {
        "width": null,
        "height": 480,
        "content": "## 🏷️ Define Incident Metadata\n**Action:** Structures incident data with service, severity, and description.\n\n**Description:**\n- Sets standardized attributes: Service (API/Database/Frontend), Severity"
      }
    },
    {
      "id": "ad55acbf-bd89-435c-b2f1-568749a416be",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1408,
        -1024
      ],
      "parameters": {
        "width": null,
        "height": 608,
        "content": "## 📊 Log Incident to Status Tracking Sheet\n**Action:** Records incident details to centralized Google Sheets dashboard.\n\n**Description:**\n- Appends incident record to \"status update\" sheet with:\n  - J"
      }
    },
    {
      "id": "9b152b91-f8f5-472d-bb7f-115b89417238",
      "name": "Define Incident Metadata",
      "type": "n8n-nodes-base.set",
      "position": [
        -768,
        -48
      ]
    },
    {
      "id": "492cf3b1-9ad6-4521-b7f5-b5a220174c01",
      "name": "Create Jira Incident Ticket",
      "type": "n8n-nodes-base.jira",
      "position": [
        -448,
        80
      ]
    },
    {
      "id": "b6953fcb-1d76-4736-96c4-ff69fc4a815b",
      "name": "Combine Incident & Jira Data",
      "type": "n8n-nodes-base.merge",
      "position": [
        496,
        -32
      ]
    },
    {
      "id": "203c7131-85a6-4fee-8475-8ef86e7414d4",
      "name": "Format Incident Alert for Slack",
      "type": "n8n-nodes-base.code",
      "position": [
        720,
        -32
      ]
    },
    {
      "id": "9ddd6d0a-4d12-4782-bae8-a7a86c75b339",
      "name": "Alert On-Call Team in Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        944,
        -32
      ]
    },
    {
      "id": "1ddfdaca-339e-4c1c-b556-0642547e605d",
      "name": "Generate Incident Timeline Report",
      "type": "n8n-nodes-base.code",
      "position": [
        1184,
        -32
      ]
    },
    {
      "id": "a397d4ed-a764-4a5c-947c-a35846d12bf1",
      "name": "Convert Timeline to Text File",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        1504,
        -32
      ]
    },
    {
      "id": "89bff2d5-0927-41bf-a959-4f65ace76fa3",
      "name": "Log Incident to Status Tracking Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1488,
        -384
      ]
    },
    {
      "id": "a73f4bf6-4196-472c-8351-51a19f017f2f",
      "name": "Archive Incident Timeline to Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1792,
        -32
      ]
    },
    {
      "id": "744d9530-fe3e-4620-bbe1-8f38fd44a879",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        496
      ],
      "parameters": {
        "width": 304,
        "height": 416,
        "content": "## 📊 Log Jira Creation Failures to Error Sheet\n**Action:** Records Jira ticket creation failures to error tracking spreadsheet.\n\n**Description:**\n- Appends error details to \"error log sheet\" when Jira"
      }
    },
    {
      "id": "ab12294c-05b5-4143-939a-242f0a432fd5",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        240
      ],
      "parameters": {
        "width": null,
        "height": 528,
        "content": "## ✅ Validate Jira Ticket Creation Success\n**Action:** Verifies Jira ticket was created successfully before proceeding.\n\n**Description:**\n- Checks if Jira response contains valid ticket key\n- **True P"
      }
    },
    {
      "id": "dd851020-a962-46ac-89d6-85d873479b32",
      "name": "Validate Jira Ticket Creation Success",
      "type": "n8n-nodes-base.if",
      "position": [
        -176,
        80
      ]
    },
    {
      "id": "e48b4e31-981b-49fc-a395-fd23827aae5a",
      "name": "Log Jira Creation Failures to Error Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        192,
        320
      ]
    }
  ],
  "connections": {
    "Define Incident Metadata": {
      "main": [
        [
          {
            "node": "Combine Incident & Jira Data",
            "type": "main",
            "index": 0
          },
          {
            "node": "Create Jira Incident Ticket",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Alert On-Call Team in Slack": {
      "main": [
        [
          {
            "node": "Generate Incident Timeline Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Jira Incident Ticket": {
      "main": [
        [
          {
            "node": "Validate Jira Ticket Creation Success",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine Incident & Jira Data": {
      "main": [
        [
          {
            "node": "Format Incident Alert for Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert Timeline to Text File": {
      "main": [
        [
          {
            "node": "Archive Incident Timeline to Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Incident Alert for Slack": {
      "main": [
        [
          {
            "node": "Alert On-Call Team in Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Incident Timeline Report": {
      "main": [
        [
          {
            "node": "Convert Timeline to Text File",
            "type": "main",
            "index": 0
          },
          {
            "node": "Log Incident to Status Tracking Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Define Incident Metadata",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Validate Jira Ticket Creation Success": {
      "main": [
        [
          {
            "node": "Combine Incident & Jira Data",
            "type": "main",
            "index": 1
          }
        ],
        [
          {
            "node": "Log Jira Creation Failures to Error Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}