Kütüphane / Raporlar, Analitik ve Panolar
Raporlar, Analitik ve Panolar
TeamRetro standup'larını Google Sheets'e kaydet ve haftalık Slack raporları gönder
Tamamlanan her TeamRetro standup güncellemesini Google Sheets'e satır olarak ekler veya günceller, ardından her Pazartesi katılımı, yeni engelleri ve en uzun süredir devam eden engeli Slack'e gönderir.
Ne yapar
## 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.
Adımlar
- 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
Benzer otomasyonlar
Görevler ve Proje YönetimiOpenAI ve Slack ile TeamRetro günlük toplantı engellerini Jira sorunlarına dönüştürün18 adımGörevler ve Proje YönetimiMattermost Standup Botu Çalıştırma30 adımGörevler ve Proje YönetimiMattermost Günlük Standup Botu Çalıştırma29 adımYapay Zekâ Ajanları ve AsistanlarGmail, X ve Haberler için Retro Konsol Çalıştırma12 adım