Post latest Twitter mentions to Slack
This workflow will allow you to get the latest twitter mentions and send those mentions to Rocket.Chat. To ensure that we don't resend the same tweets as before, we use the Function Node and getWorkflowStaticData() to persist the ids of the tweets which have already been sent and filter those out. This leaves us with only the newest tweets.
By NisaragMonitor 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, GROUP_ID, 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. β
By Rahul Joshi