Templates / Log TeamRetro standups to Google Sheets and send weekly Slack reports

Log TeamRetro standups to Google Sheets and send weekly Slack reports

Unknown

by TeamRetro ✓ · 0 views · created 2026-10-14 · Project Management

Unknown. 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 workflow has 11 nodes and runs on Team Retro events (standup.completed) (plus 1 other trigger). Along the way it connects Google Sheets, Slack and Teamretro (community).

How it runs

Trigger: On Team Retro events (standup.completed) (plus 1 other trigger).

  1. Skip Repeat Deliveries (Remove Duplicates): removes duplicate items
  2. Report Settings (Edit Fields (Set)): sets 2 fields: days, slackChannel
  3. Settings (Edit Fields (Set)): sets 2 fields: includeCarriedOver, blockerTopic
  4. Read the Log (Google Sheets): uses Google Sheets
  5. One Row per Update (Code): runs custom JavaScript code
  6. Build the Weekly Report (Code): runs custom JavaScript code
  7. Upsert into the Log (Google Sheets): append or update
  8. Post the Report (Slack): uses Slack
  9. Append to the Weekly Sheet (Google Sheets): append

Services it uses

Google SheetsSlackTeamretro (community)

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 (7)

From the author

Quick overview This workflow logs completed TeamRetro standup updates into Google Sheets and, every Monday, summarizes the past week’s participation and blockers per team, posting the report to Slack and appending weekly metrics to a separate Google Sheets…

Excerpt from TeamRetro's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.