Send engineering daily digest to Slack with Jira, GitHub, OpenAI, and Google Sheets

Description

Quick overview This workflow runs every weekday at 9 AM to collect the last 24 hours of Jira issue updates and GitHub pull request activity, uses OpenAI to summarize the results, posts a Block Kit digest to Slack, and optionally logs the digest outcome to Google Sheets. How it works Runs on a weekday 9:00 AM schedule trigger. Pulls Jira issues updated in the last 24 hours and finds “In Progress” Jira issues that have not been updated for the configured stale-day threshold. Splits the configured GitHub repository list and, for each repo, fetches recent pull requests and searches for open pull requests with no reviews. Normalizes and merges the Jira and GitHub results into a single digest payload. Sends the digest payload to OpenAI Chat Completions to generate a strict-JSON summary (what moved, what shipped, what’s blocked, needs review, and sprint health). Builds a Slack Block Kit message with ticket/PR links and optional @mentions based on a Jira/GitHub-to-Slack user map, then posts it to the configured Slack channel. If Google Sheets logging is enabled, appends a row with the posting result details to the configured spreadsheet tab. Setup Add credentials for Jira Software Cloud, GitHub, OpenAI, and Slack (and Google Sheets if you enable logging). Update the Config values for your Jira base URL and project key, GitHub repositories list, stale thresholds, Slack channel, and the OpenAI model. Invite the Slack app/bot to the target channel and ensure it has permission to post messages. If sheet logging is enabled, set the Google Sheets document and tab to use and ensure the sheet has columns that match the appended fields (ok, channel, message, message_timestamp). (Optional) Populate the user map in Config with Jira account IDs and GitHub logins mapped to Slack user IDs to enable @mentions in the digest. Requirements n8n credentials: Jira Cloud, GitHub, OpenAI, Slack; Google Sheets only if logging is on Access to the Jira project (e.g. PTN) and listed GitHub repos A Slack channel the bot can post in Fine-grained GitHub token needs repo + pull-request read (Search for review:none) Additional info Connect with us: Website: https://www.intuz.com/n8n-workflow-automation-templates/ Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz For Custom Workflow Automation Get Started: https://n8n.partnerlinks.io/intuz. An n8n automation workflow template by Intuz.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• github
• google-sheets
• http-request
• slack
• jira-software
• code
• openai

Capabilities

• 7 nodes
• 36 views

Information