Библиотека / Отчёты, аналитика и дашборды
Отчёты, аналитика и дашборды
Еженедельные ИИ-отчёты по стендапам из TeamRetro по email с помощью OpenAI и Gmail
Сохраняет каждый завершённый стендап TeamRetro в таблицу данных, затем каждую пятницу OpenAI пишет отчёт о прогрессе и блокерах, который Gmail отправляет заинтересованным сторонам — по одному письму на команду.
Что делает
## TeamRetro: Email a weekly AI standup report to stakeholders For product owners and managers who want the week's standups in one read. Every TeamRetro standup is stored in an n8n Data Table as it closes. Each Friday, OpenAI turns the week into a report on progress, blockers that lingered and risks for next week, and Gmail sends it, one email per team. ### How it works 1. Daily: the TeamRetro Trigger fires on Standup Completed. A delivery TeamRetro retries is skipped, so nothing happens twice. The day's updates become one plain-text row in the standup_days Data Table. 2. Fridays at 4 PM: the schedule loads the days days before today from the table and groups them by team. 3. OpenAI writes the report from only what the team said. 4. The report is converted to HTML and emailed to recipients. 5. Rows older than four weeks are pruned so the table stays small. ### Setup - [ ] Create a Data Table named standup_days with columns: date, team, standup, transcript (strings), day, people (numbers) - [ ] 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 - [ ] Set recipients in "Report Settings", and add OpenAI and Gmail credentials Both flows have pinned samples. Running the pinned sample a second time stops at "Skip Repeat Deliveries": that is the duplicate guard. Standup text is sent to OpenAI, so check that suits your team. ### Customization Change the schedule's day and time, or days for a fortnightly report.
Шаги
- When Standup Closes
- Skip Repeat Deliveries
- Anyone Posted?
- Prepare the Day
- Store the Day
- Every Friday at 4 PM
- Report Settings
- Load the Week
- Group by Team
- Write the Weekly Report
- OpenAI GPT-5 Mini
- Format as HTML
- Email Stakeholders
- Prune Old Days
Похожие автоматизации
Отчёты, аналитика и дашбордыЛогируйте стендапы TeamRetro в Google Sheets и публикуйте еженедельные отчёты в SlackШагов: 11Отчёты, аналитика и дашбордыПубликация дайджестов standup из TeamRetro в Slack и эскалация застрявших блокеров с OpenAIШагов: 13Задачи и управление проектамиПревращайте блокеры со стендапов TeamRetro в задачи Jira с помощью OpenAI и SlackШагов: 18ИИ-агенты и ассистентыРетро-консоль для Gmail, X и новостейШагов: 12