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