Send engineering daily digest to Slack with Jira, GitHub, OpenAI, and Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: OpenAI (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 23 nodes and runs on a schedule (cron 0 9 * * 1-5). Along the way it connects Jira Software, Google Sheets, GitHub and Slack. It also calls api.github.com over HTTP.
How it runs
Trigger: On a schedule (cron 0 9 * * 1-5).
- Set Config Fields (Edit Fields (Set)): sets 11 fields: jiraBaseUrl, jiraProjectKey, staleTicketDays…
- Fetch Jira Recent Activity (Jira Software): get many
- Fetch Jira Stale Tasks (Jira Software): get many
- Split Repository List (Code): runs custom JavaScript code
- Normalize Jira Recent Data (Code): runs custom JavaScript code
- Normalize Jira Stale Data (Code): runs custom JavaScript code
- Fetch Stale GitHub PRs (HTTP Request): calls api.github.com
- Fetch GitHub PR Activity (GitHub): get pull requests (repository)
- Merge: merges the data from its input branches
- Flatten GitHub Stale PRs (Code): runs custom JavaScript code
…plus 11 more steps. See the full node list below.
Services it uses
HTTP calls to: api.github.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- OpenAI (legacy) in Summarize Digest with OpenAI: replace with OpenAI node (AI section).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| OpenAI (legacy) Summarize Digest with OpenAI | OpenAI node (AI section) |
Nodes used (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Jira Software
n8n-nodes-base.jira - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - No Operation, do nothing
n8n-nodes-base.noOp - GitHub
n8n-nodes-base.github - OpenAI
n8n-nodes-base.openAi - Slack
n8n-nodes-base.slack
From the author
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…