Send weekly TeamRetro standup reports with OpenAI GPT-5 Mini and Gmail
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs on Team Retro events (standup.completed) (plus 1 other trigger). Along the way it connects OpenAI Chat Model, Gmail and Teamretro (community).
How it runs
Trigger: On Team Retro events (standup.completed) (plus 1 other trigger).
- Skip Repeat Deliveries (Remove Duplicates): removes duplicate items
- Report Settings (Edit Fields (Set)): sets 2 fields: recipients, days
- Anyone Posted? (If): checks a condition and branches into true / false
- Load the Week (Data table): get
- Prepare the Day (Code): runs custom JavaScript code
- Group by Team (Code): runs custom JavaScript code
- Store the Day (Data table): uses Data table
- Write the Weekly Report (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI GPT-5 Mini
- Format as HTML (Markdown): converts between Markdown and HTML
- Email Stakeholders (Gmail): uses Gmail
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-teamretro is verified or supports 3.0 (used in When Standup Closes).
Nodes used (11)
- Team Retro Trigger
n8n-nodes-teamretro.teamRetroTrigger - Remove Duplicates
n8n-nodes-base.removeDuplicates - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Data table
n8n-nodes-base.dataTable - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Markdown
n8n-nodes-base.markdown - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow stores closed TeamRetro standups in an n8n Data Table, then every Friday uses OpenAI to generate a per-team weekly standup report and sends it as an HTML email via Gmail, while pruning older standup entries. How it works 1.…