Automation library · Customer support

Escalate overdue and blocked Jira tickets with Gmail

Started by a clock, and works across Gmail and Jira. 33 steps, 3 branches, 5 loops or waits: large, and worth reading before you trust it with anything live.

Large

Download free
33 stepsLarge: read it before trusting it with anything live
3Branches: places the flow splits
5Loops or waits
2Services it connects to

The flow

Starts it 2Logic 22Service 9

The steps in the order they run, from what starts it.

  1. 1When clicking ‘Execute workflow’Manual triggerStarts it
  2. 2Schedule TriggerSchedule triggerStarts it
  3. 3⚙️ CONFIGSetLogic
  4. 4GET_JIRA_ISSUESJiraService
  5. 5GET_ISSUES_LISTCodeLogic
  6. 6Loop Over ItemsSplit In BatchesLogic
  7. 7END PROCESSNo OpLogic
  8. 8ISSUE_DATE_INSIGHTSCodeLogic
  9. 9ROUTESSwitchLogic
  10. 10SEND_DUEDATE_REMINDERGmailService
  11. 11IS_OVERDUE_BETWEENIfLogic
  12. 12MANAGER_ESCALATIONGmailService
  13. 13GET_ISSUE_CHANGELOGJiraService
  14. 14DATA_FLOWCodeLogic
  15. 15CONTINUE_LOOPCodeLogic
  16. 16Wait - Rate Limit (Reminder)WaitLogic
  17. 17SEND_DUEDATE_WARNINGGmailService
  18. 18NOTIFY_TEAMHttp RequestService
  19. 19Wait - Rate Limit (Escalation)WaitLogic
  20. 20AGGREGATE_ITEMSAggregateLogic
  21. 21MERGE_DATAMergeLogic
  22. 22CONTINUE_LOOP_OVERDUE_WARNINGCodeLogic
  23. 23Wait - Rate Limit (Warning)WaitLogic
  24. 24CONTINUE_LOOP_BLOCKED_WARNINGCodeLogic
  25. 25GET_BLOCKED_ITEMCodeLogic
  26. 26CONTINUE_LOOP_ESCALATIONCodeLogic
  27. 27COMPUTE_BLOCKED_DAYSCodeLogic
  28. 28SwitchSwitchLogic
  29. 29SEND_BLOCKED_WARNINGGmailService
  30. 30NOTIFY_TEAM_BLOCKEDHttp RequestService
  31. 31MANAGER_ESCALATION_BLOCKEDGmailService
  32. 32Wait - Rate Limit (Blocked Escalation)WaitLogic
  33. 33CONTINUE_LOOP_BLOCKED_ESCALATIONCodeLogic

How it's built

Starts on
A clock
Steps
33, with 3 branches, 5 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Jira
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Gmail and Jira accounts. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

No. Every step is fixed logic or a call to a service, so it does the same thing every time.

How long does it take to set up?

Take your time. At 33 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 33 steps before you point it at anything that matters.