Track Jira Epic Health with Automated Risk Alerts via Slack, Monday & Sheets — n8n Workflow

Gemiddeld complexiteit⏰ Gepland10 knooppunten🏷️ Project Managementdoor Rahul Joshi

Overzicht

Description: Transform your Jira project management workflow with this intelligent n8n automation template that continuously tracks, scores, and reports the health of Jira Epics.

The automation runs every 6 hours, fetches all active Epics, analyzes linked issues for performance, quality, and stability metrics, and automatically flags at-risk Epics. It updates Jira fields, sends alerts to Slack, logs trends in Google Sheets, and syncs visibility with Monday.com—ensuring teams stay proactive, not

Gebruikte knooppunten

Google SheetsSlackJira SoftwareMonday.com

Workflow-voorvertoning

📊 WORKFLOW START

This workflow monitors Jira Epics and calculates health

• Runs every 6 hours

• Fetches all Epics

• Analyzes linked issues

• Calculates health metrics

📥 EPIC RETRIEVAL

Fetches all Epics from Jira:

• Uses Jira REST API

• getAll operation

• Retrieves: Epic keys, names, fields

• Filters to Epics only

🔀 SPLIT EPICS

Transforms Epic batch into individual items:

• Iterates through each Epic

• Extracts Epic key

• Creates separate object per Epic

• Enables sequential processing

🔗 FETCH LINKED ISSUES

For each Epic, retrieves:

• Epic metadata

• All linked child issues

• Issue details:

✓ Status

📈 HEALTH SCORE ALGORITHM

Weighted formula (0-1 scale):

metrics calculated:

✓ avgCycleTime: Average days/hours

✓ bugRatio: Bugs / Total issues

✓ churnRatio: Reopened / Total

⚠️ RISK THRESHOLD

Condition: healthScore > 0.6

Interpretation:

• Score 0.0-0.6 = Healthy ✅

• Score > 0.6 = At Risk ⚠️

If AT RISK:

🔄 JIRA UPDATE

Updates at-risk Epic:

• Sets custom field:

customfield_10060 = Health Score

• Adds label: "At Risk"

• Creates audit trail

🚨 SLACK ALERT

Sends to: #project-alerts

Contains:

✓ Epic key

✓ Health score value

✓ Direct link to Epic in Jira

📋 MONDAY.COM PULSE

Updates Monday.com board with:

• Health score metric

• Risk status

• Last updated timestamp

Syncs data across platforms

📊 GOOGLE SHEETS LOG

Appends historical record:

Columns (A:C):

✓ Timestamp

✓ Epic Key

✓ Health Score

⚡

Trigger Every 6 Hours

Fetch All Epics from Jira

Split Epics for Processing

Fetch Epic + Linked Issues

Calculate Health Score

Is Score > 0.6 (At Risk)?

Update Epic in Jira

Alert Slack Channel

Update Monday.com Pulse

Log to Google Sheets

10 nodes9 edges

Hoe het werkt

1
Trigger
De workflow start met een gepland-trigger, uitgevoerd op een gedefinieerd schema.
2
Verwerking
Gegevens stromen door 10 knooppunten, connecting cron, function, googlesheets.
3
Uitvoer
De workflow voltooit zijn automatisering en levert het resultaat aan de geconfigureerde bestemming.

Knooppuntdetails (10)

Google Sheets

googleSheets

Slack

slack

Jira Software

jira

Monday.com

mondayCom

Hoe deze workflow te importeren

1Klik op de knop JSON downloaden rechts om het workflowbestand op te slaan.
2Open uw n8n-instantie. Ga naar Workflows → Nieuw → Importeren uit bestand.
3Selecteer het gedownloade bestand track-jira-epic-health-with-automated-risk-alerts-via-slack-monday-sheets en klik op Importeren.
4Stel inloggegevens in voor elk serviceknooppunt (API-sleutels, OAuth, enz.).
5Klik op Workflow testen om te controleren of alles werkt, activeer het vervolgens.

Of plak rechtstreeks in n8n → Importeren uit JSON:

{ "name": "Track Jira Epic Health with Automated Risk Alerts via Slack, Monday & Sheets", "nodes": [...], ...}

Integraties

cronfunctiongooglesheetsifjiramondaycomslack

Haal deze workflow op

Download en importeer met één klik

JSON downloaden Bekijken op n8n.io

Knooppunten10

Complexiteitmedium

Triggerscheduled

CategorieProject Management

Gemaakt door

Rahul Joshi

@rahul08

Nieuw bij n8n?

n8n is een gratis open-source workflow-automatiseringstool. Host het zelf of gebruik de cloudversie.

n8n gratis ophalen →