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

中 复杂度⏰ 定时10 个节点🏷️ Project Management作者：Rahul Joshi

概览

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

使用的节点

Google SheetsSlackJira SoftwareMonday.com

工作流预览

📊 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
⚡
T
Trigger Every 6 Hours
Fetch All Epics from Jira
S
Split Epics for Processing
Fetch Epic + Linked Issues
C
Calculate Health Score
I
Is Score > 0.6 (At Risk)?
Update Epic in Jira
Alert Slack Channel
Update Monday.com Pulse
Log to Google Sheets
10 nodes9 edges

工作原理

  1. 1

    触发器

    工作流由 定时 触发器启动，按预定计划运行。

  2. 2

    处理

    数据流经 10 个节点, connecting cron, function, googlesheets。

  3. 3

    输出

    工作流完成自动化并将结果发送到配置的目标。

节点详情 (10)

GO

Google Sheets

googleSheets

#1
SL

Slack

slack

#2
JI

Jira Software

jira

#3
MO

Monday.com

mondayCom

#4

如何导入此工作流

  1. 1点击右侧 下载 JSON 按钮保存工作流文件。
  2. 2打开你的 n8n 实例，依次点击 工作流 → 新建 → 从文件导入。
  3. 3选择下载的 track-jira-epic-health-with-automated-risk-alerts-via-slack-monday-sheets 文件并点击导入。
  4. 4为每个服务节点配置 凭证（API 密钥、OAuth 等）。
  5. 5点击 测试工作流 验证一切正常，然后激活它。

或直接在 n8n → 从 JSON 导入 中粘贴：

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

集成

cronfunctiongooglesheetsifjiramondaycomslack

获取此工作流

一键下载并导入

下载 JSON在 n8n.io 上查看
节点10
复杂度medium
触发器scheduled
分类Project Management

创建者

Rahul Joshi

Rahul Joshi

@rahul08

标签

cronfunctiongooglesheetsifjiramondaycomslack
⚡

n8n 新手？

n8n 是一款免费开源的工作流自动化工具，支持自托管或使用云版本。

免费获取 n8n →