Overview
Support signals arrive across multiple channels: Slack threads, Asana form submissions, and WhatsApp group chats. Without aggregation, patterns get lost and the QA team spends time manually triaging volume rather than acting on it.
This tool runs every Monday at 04:00 UTC via GitHub Actions, pulling the past seven days of data, deduplicating issues across sources, and using GPT-4o to synthesise a structured summary. The report covers issue volume, software vs hardware breakdowns, service requests, and recommended QA actions for the week. Severity-1 issues trigger an immediate alert to the team channel.
Key Capabilities
- Aggregates support data from Slack (#product-support), Asana (Product Support form), and WhatsApp exports.
- Deduplicates issues across sources to avoid double-counting.
- Uses GPT-4o to synthesise a structured summary with volume stats, issue categorisation, and actionable QA recommendations.
- Posts the weekly digest to #team-qa automatically every Monday at 04:00 UTC.
- Triggers severity-1 alerts when critical issues are detected in the aggregated data.
- Fully automated via GitHub Actions with zero manual intervention required.
Stack
- Python 3.11
- OpenAI GPT-4o
- Slack API
- Asana API
- GitHub Actions (scheduled workflow)