{
  "name": "Task escalation system with Google Sheets, Gmail, Telegram & Jira automation",
  "nodes": [
    {
      "id": "e0f449a9-fd91-472f-a644-6d45e2198388",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        528,
        160
      ],
      "parameters": {
        "width": 304,
        "height": 1200,
        "content": "## Workflow Overview\nThis workflow creates a complete multi-step escalation system for urgent tasks stored in Google Sheets. When a task’s priority becomes “Urgent”, the workflow sends an immediate em"
      }
    },
    {
      "id": "07f5f14e-a152-48bb-8aef-6d4c9640f078",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        848,
        352
      ],
      "parameters": {
        "width": 1040,
        "height": 528,
        "content": "## Trigger, Filtering, Emailing & Notification\n\nTriggers when a task's priority becomes “Urgent”, sends an email alert, then marks it as notified in the Google Sheet to prevent duplicates.\n"
      }
    },
    {
      "id": "347eecce-1d94-4994-bee2-d82824a21894",
      "name": "Email alert",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1440,
        560
      ]
    },
    {
      "id": "7af3d12b-6a83-45c4-a044-a53e41876b8a",
      "name": "Condition to send the email",
      "type": "n8n-nodes-base.if",
      "position": [
        1088,
        576
      ]
    },
    {
      "id": "b842538d-acfb-454d-9ffd-375df98d8b44",
      "name": "Trigger when Urgent status",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        896,
        576
      ]
    },
    {
      "id": "8bf4323f-87d2-41b8-930f-a6b7071cfad3",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1904,
        352
      ],
      "parameters": {
        "width": 1120,
        "height": 528,
        "content": "## Escalation, Jira Creation ticket and Telegram notification \n\nAfter a 2-hour delay, if the task is still unresolved, creates a Jira issue and a Telegram escalation message is sent.\n"
      }
    },
    {
      "id": "67fa4f37-452e-4681-b2ab-5e8b8c5a8ea2",
      "name": "Notified update",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1760,
        560
      ]
    },
    {
      "id": "e9258c99-f669-422f-8b33-0a82f468fd22",
      "name": "Waiting before check",
      "type": "n8n-nodes-base.wait",
      "position": [
        1968,
        560
      ]
    },
    {
      "id": "b4778d5a-0109-41ce-b6f4-1ada4370e6cb",
      "name": "Check if task is dealt with",
      "type": "n8n-nodes-base.if",
      "position": [
        2208,
        560
      ]
    },
    {
      "id": "96672fd3-25f7-4c9d-9cb2-aaf7150bf79d",
      "name": "Send the escalation message",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2448,
        576
      ]
    },
    {
      "id": "019a429f-2cb5-41cf-a106-7792d8d5d5d7",
      "name": "Jira ticket creation",
      "type": "n8n-nodes-base.jira",
      "position": [
        2624,
        576
      ]
    },
    {
      "id": "7e00b1b6-9db5-4fd3-b8e3-d416d0a1d493",
      "name": "Send notification of the escalation",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2848,
        576
      ]
    }
  ],
  "connections": {
    "Email alert": {
      "main": [
        [
          {
            "node": "Notified update",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Notified update": {
      "main": [
        [
          {
            "node": "Waiting before check",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Jira ticket creation": {
      "main": [
        [
          {
            "node": "Send notification of the escalation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Waiting before check": {
      "main": [
        [
          {
            "node": "Check if task is dealt with",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Trigger when Urgent status": {
      "main": [
        [
          {
            "node": "Condition to send the email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check if task is dealt with": {
      "main": [
        [],
        [
          {
            "node": "Send the escalation message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Condition to send the email": {
      "main": [
        [
          {
            "node": "Email alert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send the escalation message": {
      "main": [
        [
          {
            "node": "Jira ticket creation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}