Перейти к содержанию
НОВОЕМаркетплейс и ваша команда: продавайте то, что создали, и получайте планы и изменения, проверенные до того, как вы их увидите. Что нового

Библиотека / Отчёты, аналитика и дашборды

Отчёты, аналитика и дашборды

Логируйте стендапы TeamRetro в Google Sheets и публикуйте еженедельные отчёты в Slack

Добавляет или обновляет каждый завершённый стендап TeamRetro строкой в Google Sheets, а затем каждый понедельник публикует в Slack данные об участии, новые блокеры и самый долгий блокер.

Что делает

## TeamRetro: Log standups to Google Sheets and post a weekly participation report For scrum masters who want standup history they can search and trend. Every update from a closed TeamRetro standup is upserted into Google Sheets as its own row. Each Monday a second flow reads the log, posts who posted, new blockers and the longest-running blocker to Slack, and appends the week's numbers to a trends tab. ### How it works 1. Daily: the TeamRetro Trigger fires on Standup Completed. A delivery TeamRetro retries is skipped, so nothing happens twice. Each update becomes a plain-text row, upserted on Update ID so a row is never written twice. 2. Mondays at 9 AM: the schedule reads the log and keeps the days days before today. 3. A Code node counts standups held, who posted on how many, and new and long-running blockers, per team. 4. Slack gets the report, and the week's numbers are appended to the trends tab. ### Setup - [ ] Create a sheet "Log" with columns: Date, Team, Standup, Person, Question, Blocker, Update, Carried over, Update ID - [ ] Create a sheet "Weekly" with columns: Week ending, Team, Standups, People posting, Updates, New blockers, Longest blocker (standups) - [ ] Copy the Production URL from "When Standup Closes" into TeamRetro under Settings → Integrations → Webhooks, tick Standup Completed, and paste the signing secret back into the trigger - [ ] Connect Google Sheets and Slack, pick the document and sheets, and set slackChannel Both flows have pinned samples. Running the pinned sample a second time stops at "Skip Repeat Deliveries": that is the duplicate guard. ### Customization Set includeCarriedOver to false to log only new items.

Шаги

  1. When Standup Closes
  2. Skip Repeat Deliveries
  3. Settings
  4. One Row per Update
  5. Upsert into the Log
  6. Every Monday at 9 AM
  7. Report Settings
  8. Read the Log
  9. Build the Weekly Report
  10. Post the Report
  11. Append to the Weekly Sheet

Похожие автоматизации