Task Escalation System with Google Sheets, Gmail, Telegram & Jira Automation

Description

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 Telegram message is sent with the details of the issue created.

It helps teams avoid missed deadlines and ensures urgent tasks get attention — without requiring anyone to refresh or monitor the sheet manually.

Context

In shared task lists, urgent items can be overlooked if team members aren't actively checking the spreadsheet. This workflow solves that by:

Sending an email as soon as a task becomes Urgent

Waiting 2 hours

Checking if the task is still open

Sending a Telegram reminder only if action has not been taken

Creating a Jira issue

Sending a Telegram message with the details of the issue created

This prevents both silence and spam, creating a smart and reliable alert system.

Target Users Project Managers using Google Sheets

Team leads managing shared task boards

Remote teams needing lightweight coordination

Anyone who wants escalation notifications without complex systems

Technical Requirements Google Sheets credential Gmail credential Telegram Bot + Chat ID Google Sheet with a column named Priority Jira credential

Workflow Steps

Trigger: Google Sheets Trigger (on update in the “Priority” column) IF Node – Checks if Priority = Urgent Send Email – Sends alert email with task name, owner, status, deadline Mark Notified = Yes in the sheet Wait 2 hours IF Status is still not resolved Send Telegram reminder create an Issue on Jira based on the information provided Send Telegram message with the details of the ticket

Key Features

Real-time alerts on critical tasks Simple logic (no code required) Custom email body with dynamic fields Works on any Google Sheet with a “Priority” column Telegram notification ensures the task doesn’t get forgotten

Expected Output

Personalized email alert when a task is marked as "Urgent" Email includes task info: title, owner, deadline, status, next step Telegram message after 2 hours if the task is still open Automatic creation of a Jira issue with the higgest priority Telegram message to notify about the new Jira ticket

How it works

Trigger: Watches for “Priority” updates 🔍 Check: If Priority = Urgent AND Notified is empty 📧 Email: Sends a personalized alert ✏️ Sheet Update: Marks the task as already notified ⏳ Wait: 2-hour delay 🤖 Check Again: If Status hasn’t changed → send Telegram reminder, create Jira ticket and send the details.

Tutorial video: Watch the Youtube Tutorial video

About me : I'm Yassin, IT Project Manager, Agile & Data specialist. Scaling tech products with data-driven project management. 📬 Feel free to connect with me on Linkedin