{"product_id":"n8n-teamretro-to-google-sheets-slack-weekly-reports","title":"n8n TeamRetro to Google Sheets: Slack Weekly Reports","description":"\u003ch3\u003eTurn TeamRetro standup notes into weekly Slack reports (and track trends in Google Sheets)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures completed \u003cstrong\u003eTeamRetro\u003c\/strong\u003e standup updates, stores them in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and every Monday automatically summarizes the past week’s participation and blockers per team—posting the formatted report to \u003cstrong\u003eSlack\u003c\/strong\u003e and appending weekly metrics to a separate sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIngests standup data via TeamRetro webhook:\u003c\/strong\u003e Triggers on the “Standup Completed” event using the \u003cstrong\u003eTeamRetro webhook trigger\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate writes:\u003c\/strong\u003e Deduplicates incoming webhook deliveries using the \u003cstrong\u003eTeamRetro delivery ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTransforms updates into sheet-ready rows:\u003c\/strong\u003e Converts each participant’s topic updates into one plain-text row per update (with an option to exclude carried-over items) and flags \u003cstrong\u003eblocker-topic\u003c\/strong\u003e entries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts into Google Sheets:\u003c\/strong\u003e Writes to the \u003cstrong\u003eGoogle Sheets “Log”\u003c\/strong\u003e sheet and matches on \u003cstrong\u003eUpdate ID\u003c\/strong\u003e to avoid duplicate records.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules weekly reporting:\u003c\/strong\u003e Runs every \u003cstrong\u003eMonday at 9 AM\u003c\/strong\u003e, reads the logged standups from Google Sheets, and builds per-team summaries for the last \u003cem\u003eN\u003c\/em\u003e days.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates and distributes the report:\u003c\/strong\u003e Includes standups held, posting frequency, new blockers, and the longest-running blocker; then posts the report to a \u003cstrong\u003eSlack channel\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks weekly metrics over time:\u003c\/strong\u003e Appends the week’s metrics to the \u003cstrong\u003eGoogle Sheets “Weekly”\u003c\/strong\u003e sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily team leads who want a single weekly \u003cstrong\u003eSlack\u003c\/strong\u003e summary of \u003cstrong\u003eTeamRetro\u003c\/strong\u003e standups and blockers.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators tracking engineering participation and blocker trends across teams.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers maintaining a reliable audit log of standup updates in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers:\u003c\/strong\u003e TeamRetro webhook trigger (Standup Completed), plus a schedule trigger for Monday 9 AM.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e \u003cstrong\u003eTeamRetro\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore logic:\u003c\/strong\u003e Deduplication on TeamRetro delivery ID, optional exclusion of carried-over items, upsert matching on Update ID, and blocker detection.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExpected sheets:\u003c\/strong\u003e “Log” and “Weekly” tabs with columns for fields such as Date, Team, Standup, Person, and Question.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46228896350387,"sku":"N8N-20960","price":15.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/UJDBpbGU03f73t5rx9Km8_DcBcTAGj.png?v=1792055853","url":"https:\/\/buyflowscripts.com\/products\/n8n-teamretro-to-google-sheets-slack-weekly-reports","provider":"N8N Commerce","version":"1.0","type":"link"}