Библиотека / Отчёты, аналитика и дашборды
Отчёты, аналитика и дашборды
Логируйте стендапы 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.
Шаги
- When Standup Closes
- Skip Repeat Deliveries
- Settings
- One Row per Update
- Upsert into the Log
- Every Monday at 9 AM
- Report Settings
- Read the Log
- Build the Weekly Report
- Post the Report
- Append to the Weekly Sheet
Похожие автоматизации
Задачи и управление проектамиПревращайте блокеры со стендапов TeamRetro в задачи Jira с помощью OpenAI и SlackШагов: 18ИИ-агенты и ассистентыРетро-консоль для Gmail, X и новостейШагов: 12Задачи и управление проектамиСоздание проектной команды в NotionШагов: 23Отчёты, аналитика и дашбордыЭкспорт тикетов команды из GraphQL в Google SheetsШагов: 11