Yassin Zehar This workflow corresponds to n8n.io template #10523 — we link there as the canonical source.
This workflow follows the Gmail → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "nNugT3L8zhi7EJ0G",
"name": "Urgent Task Alert from Google Sheet with Telegram reminder",
"tags": [
{
"id": "h2TBJOs7feXDIfbL",
"name": "google sheet",
"createdAt": "2025-08-14T09:57:22.041Z",
"updatedAt": "2025-08-14T09:57:22.041Z"
},
{
"id": "IUTR4oS3KHYPxOqH",
"name": "Jira",
"createdAt": "2025-11-14T09:45:17.977Z",
"updatedAt": "2025-11-14T09:45:17.977Z"
},
{
"id": "DW3QCDhQZ9ZpSunz",
"name": "Bot",
"createdAt": "2025-08-02T17:37:06.011Z",
"updatedAt": "2025-08-02T17:37:06.011Z"
},
{
"id": "rYuINsb3Y1XjrgNv",
"name": "Productivity",
"createdAt": "2025-08-02T17:36:49.812Z",
"updatedAt": "2025-08-02T17:36:49.812Z"
},
{
"id": "yfpCFhbNZGRtYKc0",
"name": "Telegram",
"createdAt": "2025-08-02T17:36:35.592Z",
"updatedAt": "2025-08-02T17:36:35.592Z"
},
{
"id": "S94PaeZJiPKn5Ei9",
"name": "gmail",
"createdAt": "2025-08-14T09:57:18.678Z",
"updatedAt": "2025-08-14T09:57:18.678Z"
}
],
"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\u2019s priority becomes \u201cUrgent\u201d, the workflow sends an immediate email alert to the task owner, updates the sheet to mark the task as notified, waits for a defined amount of time, and then checks whether the issue has been resolved. If the task is still open, it sends a Telegram escalation message and automatically creates a Jira ticket with highest priority, followed by a final Telegram message with the ticket details. This ensures critical tasks always enter a formal resolution workflow and are not forgotten.\n\n### How it works\n1. Google Sheets trigger detects when a task\u2019s priority changes to **Urgent**. \n2. An email alert is sent with key task details. \n3. The Google Sheet is updated to mark the task as **Notified**. \n4. After a delay (e.g. 2 hours), the workflow checks if the task has been updated or resolved. \n5. If it is still unresolved, a Telegram message is sent and a Jira ticket is created automatically.\n\n### Setup steps\n- Connect Google Sheets, Gmail, Telegram and Jira credentials. \n- Match your Sheet\u2019s column names with the fields used in the workflow. \n- Adjust the wait time in the **Wait** node to fit your process. \n- Test by changing a task\u2019s priority to **Urgent** in your Sheet.\n\n### Requirements\n- Google Sheets credential \n- Gmail credential \n- Telegram account \n- Jira credentials \n\n@[youtube](2iFMqQSjq7U)"
},
"typeVersion": 1
},
{
"id": "07f5f14e-a152-48bb-8aef-6d4c9640f078",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
848,
352
],
"parameters": {
"color": 7,
"width": 1040,
"height": 528,
"content": "## Trigger, Filtering, Emailing & Notification\n\nTriggers when a task's priority becomes \u201cUrgent\u201d, sends an email alert, then marks it as notified in the Google Sheet to prevent duplicates.\n"
},
"typeVersion": 1
},
{
"id": "347eecce-1d94-4994-bee2-d82824a21894",
"name": "Email alert",
"type": "n8n-nodes-base.gmail",
"position": [
1440,
560
],
"parameters": {
"sendTo": "user@example.com",
"message": "=Hi,<br><br>\nA task has been marked as <b>Urgent</b> in the project tracking sheet.<br><br>\n\ud83d\udccc <b>Task:</b> {{$json[\"Task\"]}}<br>\n\ud83d\udc64 <b>Owner:</b> {{$json[\"Owner\"]}}<br>\n\ud83d\udcc5 <b>Deadline:</b> {{$json[\"Deadline\"]}}<br>\n\ud83d\udccb <b>Status:</b> {{$json[\"Status\"]}}<br>\n\ud83e\udded <b>Next Step:</b> {{$json[\"Next step\"]}}<br><br>\nPlease review this task as soon as possible.<br><br>\n\u2014<br>",
"options": {},
"subject": "A critical task has been flagged in the project sheet"
},
"typeVersion": 2.1
},
{
"id": "7af3d12b-6a83-45c4-a044-a53e41876b8a",
"name": "Condition to send the email",
"type": "n8n-nodes-base.if",
"position": [
1088,
576
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bd3dbdbd-84b2-4a29-bc65-a0475de280bf",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{$json[\"Priority\"]}}",
"rightValue": "Urgent"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b842538d-acfb-454d-9ffd-375df98d8b44",
"name": "Trigger when Urgent status",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
896,
576
],
"parameters": {
"options": {
"columnsToWatch": [
"Priority"
]
},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "yoururl",
"cachedResultName": "Feuille 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "yourdocid",
"cachedResultUrl": "yoururl",
"cachedResultName": "Reporting"
}
},
"typeVersion": 1
},
{
"id": "8bf4323f-87d2-41b8-930f-a6b7071cfad3",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1904,
352
],
"parameters": {
"color": 7,
"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"
},
"typeVersion": 1
},
{
"id": "67fa4f37-452e-4681-b2ab-5e8b8c5a8ea2",
"name": "Notified update",
"type": "n8n-nodes-base.googleSheets",
"position": [
1760,
560
],
"parameters": {
"columns": {
"value": {
"Notified": "Yes",
"Priority": "={{ $('Trigger when Urgent status').item.json.Priority }}",
"row_number": "=\n"
},
"schema": [
{
"id": "Task",
"type": "string",
"display": true,
"required": false,
"displayName": "Task",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Owner",
"type": "string",
"display": true,
"required": false,
"displayName": "Owner",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Deadline",
"type": "string",
"display": true,
"required": false,
"displayName": "Deadline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next step",
"type": "string",
"display": true,
"required": false,
"displayName": "Next step",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Priority",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Priority",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notified",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Notified",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Priority"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "yoururl",
"cachedResultName": "Feuille 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "yourdocid",
"cachedResultUrl": "yoururl",
"cachedResultName": "Reporting"
}
},
"typeVersion": 4.7
},
{
"id": "e9258c99-f669-422f-8b33-0a82f468fd22",
"name": "Waiting before check",
"type": "n8n-nodes-base.wait",
"position": [
1968,
560
],
"parameters": {
"unit": "hours",
"amount": 2
},
"typeVersion": 1.1,
"alwaysOutputData": true
},
{
"id": "b4778d5a-0109-41ce-b6f4-1ada4370e6cb",
"name": "Check if task is dealt with",
"type": "n8n-nodes-base.if",
"position": [
2208,
560
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "33799756-717a-4b03-8694-77f46be10988",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "Priority",
"rightValue": "=Urgent"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "96672fd3-25f7-4c9d-9cb2-aaf7150bf79d",
"name": "Send the escalation message",
"type": "n8n-nodes-base.telegram",
"position": [
2448,
576
],
"parameters": {
"text": "=\ud83d\udea8 Task still open after 2h:\n\ud83d\udccc {{ $('Trigger when Urgent status').item.json.Task }}\n\ud83d\udc64 {{ $('Trigger when Urgent status').item.json.Owner }}\n\ud83d\udcc5 {{ $('Trigger when Urgent status').item.json.Deadline }}\nStatus:{{ $('Trigger when Urgent status').item.json.Status }}\nNext step: {{ $('Trigger when Urgent status').item.json[\"Next step\"] }}\n\nPlease review this task in Google Sheets.\n",
"chatId": "yourchatID",
"additionalFields": {}
},
"typeVersion": 1.2
},
{
"id": "019a429f-2cb5-41cf-a106-7792d8d5d5d7",
"name": "Jira ticket creation",
"type": "n8n-nodes-base.jira",
"position": [
2624,
576
],
"parameters": {
"project": {
"__rl": true,
"mode": "list",
"value": "10002",
"cachedResultName": "test2"
},
"summary": "={{ $('Trigger when Urgent status').item.json.Task }}",
"issueType": {
"__rl": true,
"mode": "list",
"value": "10013",
"cachedResultName": "Bug"
},
"additionalFields": {
"priority": {
"__rl": true,
"mode": "list",
"value": "1",
"cachedResultName": "Highest"
},
"description": "={{ $('Trigger when Urgent status').item.json.Task }}\n\nDeadline: {{ $('Trigger when Urgent status').item.json.Deadline }}\n\n{{ $('Trigger when Urgent status').item.json.Priority }}\n\n"
}
},
"typeVersion": 1
},
{
"id": "7e00b1b6-9db5-4fd3-b8e3-d416d0a1d493",
"name": "Send notification of the escalation",
"type": "n8n-nodes-base.telegram",
"position": [
2848,
576
],
"parameters": {
"text": "=Now a ticket has been created in Jira.\n\nKey: {{ $json.key }}\nPlease check the ticket:{{ $json.self }}",
"chatId": "yourchatid",
"additionalFields": {}
},
"typeVersion": 1.2
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "b3aa34a4-6a2d-4e6d-9da3-d6a13f5893ca",
"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
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow sends an instant email alert when a task in a Google Sheet is marked as Urgent, and then sends a Telegram reminder notification after 2 hours if the task still hasn’t been updated. Then a Jira ticket is created so the task enters in the formal workflow and another…
Source: https://n8n.io/workflows/10523/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Stay ahead in your trading game with this powerful n8n automation workflow. Designed for real-time efficiency, this setup continuously scans your Gmail inbox for trading alerts from TradingView and en
Gmail, Telegram, Google Sheets +1
This workflow automatically classifies and routes incoming Outlook emails into smart categories using n8n + OpenAI GPT-4.1-mini. It helps professionals and teams stay organized by intelligently sortin
Google Sheets, Gmail, Microsoft Outlook Trigger +3
Transform your Google Form into an intelligent customer support system that automatically analyzes, prioritizes, and responds to every inquiry with AI-powered personalization.
Google Sheets Trigger, OpenAI, Gmail +2
This workflow runs every Monday at 8 AM and automatically monitors your Jira project, measures progress against the active sprint, and delivers a structured report to stakeholders — with zero manual e
Postgres, Jira, N8N Nodes Htmlcsstopdf +1
Fetches all open sprint tickets daily from your Jira project Analyzes each ticket for overdue days and blocked status Routes to the right escalation level: assignee email → team Google Chat alert → ma
Gmail, Jira, HTTP Request