Monitor and report OKR variance from Monday.com and Jira via Slack and Email

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 linked Jira epic keys from the OKR board. 🔗 - Step 3: Fetches corresponding Jira epic details such as status, assignee, and last updated date. 🧩 - Step 4: Merges Monday.com KR data with Jira epic progress through SQL-style joins. 📋 - Step 5: Calculates real-time progress and variance against target goals. 📊 - Step 6: Updates Monday.com KR items with actual progress, variance percentage, and status (“On Track”, “At Risk”, or “Ahead”). 🔄 - Step 7: Aggregates all KR data into a consolidated report for communication. 📦 - Step 8: Sends formatted variance reports to Slack and Outlook, with summaries of owner, progress, and variance metrics. 📢 Key Benefits ✅ Automates end-to-end OKR and Jira synchronization ✅ Eliminates manual progress tracking errors ✅ Provides daily visibility on team and project health ✅ Enables proactive risk detection via variance thresholds ✅ Keeps all stakeholders updated via Slack and Outlook ✅ Centralizes OKR performance metrics for reporting Features - Daily scheduled trigger for automatic OKR sync - Monday.com → Jira data integration via API - Real-time variance computation logic - Automatic updates of OKR fields in Monday.com - SQL-style data merging and aggregation - Slack notification with variance summaries - Outlook email digest with formatted HTML tables Requirements - Monday.com API credentials with board access - Jira API credentials with permission to view epics - Slack Bot token with chat:write permissions - Microsoft Outlook OAuth2 credentials for sending emails - Environment variables for board, channel, and recipient configuration Target Audience - Product and engineering teams managing OKRs across platforms 🎯 - Project managers tracking cross-tool performance metrics 📋 - Leadership teams needing automated OKR reporting 💼 - Operations and strategy teams monitoring execution health 🧭 Step-by-Step Setup Instructions - Connect your Monday.com, Jira, Slack, and Outlook credentials in n8n. 🔑 - Replace MONDAYBOARDID, GROUPID, and column identifiers with your own. 🧩 - Set environment variables for SLACKCHANNELID and REPORTRECIPIENTEMAIL. 💬 - Adjust the cron expression to define your sync frequency (e.g., daily at 9 AM). ⏰ - Test the workflow with a single OKR item to confirm successful synchronization. 🧠 - Enable the workflow to automate daily OKR variance tracking and reporting. ✅