{
  "name": "Monitoring team capacity in Jira and sending alerts for over-allocation",
  "nodes": [
    {
      "id": "73e34959-f752-4bb0-a55a-73282abadde5",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -560,
        -16
      ]
    },
    {
      "id": "13f023dd-3654-4e19-9e68-f6be0d8aec06",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1152,
        64
      ],
      "parameters": {
        "width": 352,
        "height": 480,
        "content": "## 📧 Send Over-Allocation Alert to Manager\n**Action:**  \n- Delivers urgent capacity alert email to project manager/team lead.  \n**Description:**  \n- Sends formatted alert to manager with full report d"
      }
    },
    {
      "id": "08cb35a9-0612-494b-bf9d-c3436b845d10",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        -688
      ],
      "parameters": {
        "width": 288,
        "height": 560,
        "content": "## 📢 Generate Over-Allocation Alert Report\n**Action:**  \n- Creates comprehensive alert message for over-allocated team members.  \n**Description:**  \n- Aggregates all over-allocation cases into single "
      }
    },
    {
      "id": "79868a06-b2cf-4e68-b4ab-8b49fd6c5983",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        624,
        128
      ],
      "parameters": {
        "width": null,
        "height": 496,
        "content": "## ⚠️ Detect Over-Allocated Team Members\n**Action:**  \n- Filters team members whose utilization exceeds 100% capacity.  \n**Description:**  \n- Evaluates status field to identify \"Overallocated\" team me"
      }
    },
    {
      "id": "1fb0b12d-4aee-4ad0-80d5-90470013b097",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        384,
        -816
      ],
      "parameters": {
        "width": null,
        "height": 592,
        "content": "## 📈 Log Capacity Data to Tracking Sheet\n**Action:**  \n- Records team member utilization metrics to Google Sheets for historical tracking.  \n**Description:**  \n- Appends each team member's capacity da"
      }
    },
    {
      "id": "60bcfb26-5e75-4f78-96c6-4ce964030bfe",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        128,
        -704
      ],
      "parameters": {
        "width": null,
        "height": 656,
        "content": "## 📊 Calculate Team Member Utilization\n**Action:**  \n- Aggregates time logged per team member and calculates capacity utilization.  \n**Description:**  \n- Processes all Jira issues to extract time spen"
      }
    },
    {
      "id": "ea3a99a2-8388-400a-8835-e879e3952a84",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        32,
        448
      ],
      "parameters": {
        "width": null,
        "height": 576,
        "content": "## 📊 Log Query Failures to Error Sheet\n**Action:**  \n- Records Jira query failures or data retrieval errors to tracking spreadsheet.  \n**Description:**  \n- Appends error details to \"error log sheet\" w"
      }
    },
    {
      "id": "ece752c2-40d2-4e9b-b21c-62c6d3ddfb51",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -528
      ],
      "parameters": {
        "width": null,
        "height": 480,
        "content": "## ✅ Validate Issues Retrieved Successfully\n**Action:**  \n- Checks if Jira returned any active issues for processing.  \n**Description:**  \n- Verifies that the query successfully retrieved issue data. "
      }
    },
    {
      "id": "a44b5a35-d244-466c-8ef9-6ce5c155e655",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -352,
        192
      ],
      "parameters": {
        "width": null,
        "height": 464,
        "content": "## 📋 Fetch Active Jira Issues\n**Action:**  \n- Retrieves all in-progress Jira issues from the project.  \n**Description:**  \n- Queries Jira using JQL: \"statusCategory != Done AND status = 'In Progress'\""
      }
    },
    {
      "id": "da294676-ddf2-4411-82d1-cdfa2b64cb5b",
      "name": "Jira Get Issues Node",
      "type": "n8n-nodes-base.jira",
      "position": [
        -304,
        -16
      ]
    },
    {
      "id": "5fdb6740-8798-43a0-bd92-bfe826ef6595",
      "name": "Data Validation",
      "type": "n8n-nodes-base.if",
      "position": [
        -80,
        -16
      ]
    },
    {
      "id": "2b109593-2b1e-4fb3-a4c4-b6bf9c228842",
      "name": "Capacity Calculator",
      "type": "n8n-nodes-base.code",
      "position": [
        224,
        -32
      ]
    },
    {
      "id": "30b80dd9-8b7e-4c08-adc7-4437a1119a18",
      "name": "Log Capacity Data to Tracking Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        464,
        -208
      ]
    },
    {
      "id": "4303fbf4-2489-47d3-82d1-ce0633da1364",
      "name": "Over-Allocation Check",
      "type": "n8n-nodes-base.if",
      "position": [
        688,
        -32
      ]
    },
    {
      "id": "a915efc1-9f5f-4a28-b7c5-273737ce07fb",
      "name": "Alert Report Generator",
      "type": "n8n-nodes-base.code",
      "position": [
        1008,
        -112
      ]
    },
    {
      "id": "4624c013-7758-4fdf-b879-a90d86a706e0",
      "name": "Send Over-Allocation Alert to Manager",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1264,
        -112
      ]
    },
    {
      "id": "cd15b637-c0c3-4024-ae2c-55bd2262ea9e",
      "name": "Log Query Failures to Error Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        96,
        272
      ]
    }
  ],
  "connections": {
    "Data Validation": {
      "main": [
        [
          {
            "node": "Capacity Calculator",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Log Query Failures to Error Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Capacity Calculator": {
      "main": [
        [
          {
            "node": "Over-Allocation Check",
            "type": "main",
            "index": 0
          },
          {
            "node": "Log Capacity Data to Tracking Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Jira Get Issues Node": {
      "main": [
        [
          {
            "node": "Data Validation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Over-Allocation Check": {
      "main": [
        [
          {
            "node": "Alert Report Generator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Alert Report Generator": {
      "main": [
        [
          {
            "node": "Send Over-Allocation Alert to Manager",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log Capacity Data to Tracking Sheet": {
      "main": [
        [
          {
            "node": "Over-Allocation Check",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Jira Get Issues Node",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}