{"product_id":"n8n-teamretro-weekly-standup-reports-with-gpt-gmail","title":"n8n TeamRetro Weekly Standup Reports with GPT \u0026 Gmail","description":"\u003ch3\u003eTurn weekly TeamRetro standups into polished GPT-powered reports—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures every completed \u003cstrong\u003eTeamRetro\u003c\/strong\u003e standup, stores it in an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e, and every \u003cstrong\u003eFriday at 4 PM\u003c\/strong\u003e uses \u003cstrong\u003eOpenAI (GPT)\u003c\/strong\u003e to generate a per-team weekly standup report and sends it as a formatted \u003cstrong\u003eHTML email\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eListens for \u003cstrong\u003eTeamRetro Trigger\u003c\/strong\u003e webhook events when a standup is marked as \u003cstrong\u003eStandup Completed\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003ePrevents duplicates and ignores standups that have \u003cstrong\u003eno participant updates\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eBuilds a plain-text transcript for the day and saves the standup summary into a Data Table named \u003cstrong\u003estandup_days\u003c\/strong\u003e (with fields like \u003cstrong\u003edate, day, team, standup, people, transcript\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003eEvery Friday at \u003cstrong\u003e4 PM\u003c\/strong\u003e, loads the last \u003cstrong\u003eN days\u003c\/strong\u003e (default \u003cstrong\u003e7\u003c\/strong\u003e) from \u003cstrong\u003estandup_days\u003c\/strong\u003e, groups entries by \u003cstrong\u003eteam\u003c\/strong\u003e, and sends each team’s collected standup text to \u003cstrong\u003eOpenAI (GPT-5 Mini)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eConverts the returned \u003cstrong\u003eMarkdown\u003c\/strong\u003e into \u003cstrong\u003eHTML\u003c\/strong\u003e and emails it to your configured recipients using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003ePrunes the Data Table by deleting rows older than \u003cstrong\u003efour weeks\u003c\/strong\u003e to keep stored data small.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams that want consistent weekly standup reporting without manual copying.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who need an auditable workflow combining TeamRetro + OpenAI + Gmail.\u003c\/li\u003e\n  \u003cli\u003eOps and engineering leads who want team-by-team weekly progress, lingering blockers, and next-week risks in one email.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTeamRetro Trigger\u003c\/strong\u003e webhook (Standup Completed), including webhook signing secret validation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Data Table\u003c\/strong\u003e usage for \u003cstrong\u003estandup_days\u003c\/strong\u003e storage and retention (4-week pruning).\u003c\/li\u003e\n  \u003cli\u003eNodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003emarkdown\u003c\/strong\u003e, and the Data Table workflow logic.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e integration to produce Markdown reports with sections for progress, lingering blockers, and next-week risks.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eTip:\u003c\/strong\u003e In the workflow settings, configure your Gmail recipients and adjust the reporting window via the \u003cstrong\u003edays\u003c\/strong\u003e value.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217884172467,"sku":"N8N-20865","price":7.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/saVd9zc2NQyE7JLdcDUQs_aZU5jxIq.png?v=1791882118","url":"https:\/\/buyflowscripts.com\/products\/n8n-teamretro-weekly-standup-reports-with-gpt-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}