Escalate overdue and blocked Jira tickets with Gmail and Google Chat

How it works - 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 → manager escalation

Set up steps - Add your Jira Software Cloud credentials in n8n - Add your Gmail OAuth2 credentials in n8n - Open the ⚙️ CONFIG node and fill in your 4 values (Jira domain, project key, manager email, Google Chat webhook) - Test with the Manual Trigger, then enable the Schedule Trigger