Monitor and Report OKR Variance from Monday.com and Jira via Slack and Email — n8n 워크플로

보통 복잡도⏰ 예약12개의 노드🏷️ Project Management👁 2회 조회작성자: Rahul Joshi

개요

Description Synchronize OKRs (Objectives and Key Results) between Monday.com and Jira to automatically calculate progress variance, update dashboards, and share variance reports via Slack and Outlook. This workflow ensures teams have accurate, real-time visibility into performance metrics and project alignment — without manual reconciliation. 🎯📈💬

What This Template Does Step 1: Triggers daily at a scheduled time to fetch the latest OKRs from Monday.com. ⏰ Step 2: Extracts Key Results and their

사용된 노드

SlackJira SoftwareMonday.comMicrosoft OutlookCode

워크플로 미리보기

🎯 OKR Sync & Variance Tracking System
This workflow automates the synchronization of OKRs (Ob
⏰ Schedule Configuration
Setup Steps:
1. Click on this node
2. Set your desired interval (daily/weekly)
3. Choose optimal run time (e.g., 9 AM daily)
4. Consider timezone settings
📋 Monday.com Board Setup
Required Columns:
- Objective Name (text)
- Jira Epic Keys (text, comma-separated)
- Target Progress (number, %)
- Current Progress (number, %)
🔄 Field Mapping
This node extracts and standardizes Monday.com column d
What it does:
- Maps column indices to readable field names
- Prepares data for downstream
🔀 Epic Splitting Logic
Each KR can track multiple Jira epics (comma-separated)
Example:
- Input: KR-123 → EPIC-1, EPIC-2
- Output: 2 items (KR-12
🔗 Jira Integration
Setup:
1. Connect your Jira credentials
2. Ensure the Jira account has read access to all linke
3. Test with a single epic key first
Rate Limits: Jira Cloud allo
🧹 Response Normalization
Jira API returns nested complex objects. This node flat
- Issue key
- Summary (name)
- Status (for progr
🔗 SQL Merge Strategy
This node performs a LEFT JOIN to combine:
- Input 1: KR metadata (from Monday)
- Input 2: Epic details (from Jira)
Result: Each KR-Epic pair with complete context for va
📊 Progress Calculation Logic
Status Weights:
- To Do = 0%
- In Progress = 50%
- Done = 100%
Formula:
✍️ Monday.com Update
Configuration Needed:
1. Replace column IDs with your actual Monday board col
- MONDAY_COL_ACTUAL_PROGRESS → Actual Progress colum
- MONDAY_COL_VARIANCE → V
📦 Aggregation for Reporting
Combines all KR variance data into a single payload for
Output: Array of all KRs with their computed metrics, r
💬 Slack Notification
Setup:
1. Replace channelId with your Slack channel ID
2. Or use environment variable: SLACK_CHANNEL_ID
3. Customize message formatting as needed
Tip: Use Slack's Blo
📧 Email Notification
Setup:
1. Replace hardcoded email with: REPORT_RECIPIENT_EMAIL
2. Or use dynamic owner emails from data
3. Customize HTML template as needed
Note: Ensure
⚡
D
Daily OKR Sync Trigger
Fetch OKRs from Monday.com
M
Map Monday Fields → Stan…
Split KR → Epics Mapper
Fetch Jira Epic Details
Normalize Jira Response
J
Join KR + Epic Data (SQL…
Compute KR Progress & Va…
Update KR Status on Monday
A
Aggregate Final Results …
Post Slack Variance Report
Email Variance Digest (O…
12 nodes12 edges

작동 원리

  1. 1

    트리거

    워크플로는 예약 트리거로 시작합니다, 정해진 일정에 따라 실행.

  2. 2

    처리

    데이터가 12개의 노드를 통해 흐릅니다, connecting aggregate, code, jira.

  3. 3

    출력

    워크플로가 자동화를 완료하고 구성된 대상에 결과를 전달합니다.

노드 세부 정보 (12)

SL

Slack

slack

#1
JI

Jira Software

jira

#2
MO

Monday.com

mondayCom

#3
MI

Microsoft Outlook

microsoftOutlook

#4
CO

Code

code

#5

이 워크플로 가져오는 방법

  1. 1오른쪽의 JSON 다운로드 버튼을 클릭하여 워크플로 파일을 저장합니다.
  2. 2n8n 인스턴스를 열고 워크플로 → 새로 만들기 → 파일에서 가져오기로 이동합니다.
  3. 3다운로드된 monitor-and-report-okr-variance-from-mondaycom-and-jira-via-slack-and-email 파일을 선택하고 가져오기를 클릭합니다.
  4. 4각 서비스 노드에 대한 자격 증명（API 키, OAuth 등）을 설정합니다.
  5. 5워크플로 테스트를 클릭하여 모든 것이 작동하는지 확인한 후 활성화합니다.

또는 n8n → JSON에서 가져오기에 직접 붙여넣기:

{ "name": "Monitor and Report OKR Variance from Monday.com and Jira via Slack and Email", "nodes": [...], ...}

통합

aggregatecodejiramergemicrosoftoutlookmondaycomscheduletriggersetslack

이 워크플로 가져오기

한 번의 클릭으로 다운로드 및 가져오기

JSON 다운로드n8n.io에서 보기
노드12
복잡도medium
트리거scheduled
조회수2
카테고리Project Management

제작자

Rahul Joshi

Rahul Joshi

@rahul08

태그

aggregatecodejiramergemicrosoftoutlookmondaycomscheduletriggersetslack
⚡

n8n을 처음 사용하시나요?

n8n은 무료 오픈소스 워크플로 자동화 도구입니다. 자체 호스팅하거나 클라우드 버전을 사용하세요.

n8n 무료로 시작하기 →