SparkTestX: Case Study
A cross platform mobile app that replaces WhatsApp based testing workflows with a real time, role based management system. Built with Flutter and Supabase featuring push notifications, offline first architecture, and rich analytics.
Real time app testing management system for Google Play closed testing
The Challenge
SparkTestX is a mobile app testing agency specializing in Google Play Console closed testing, managing a team of 12 device testers across 14 day testing cycles. The entire workflow was managed through WhatsApp groups and manual communication. There was no centralized system so managers were sending testing links, APKs, and instructions through WhatsApp messages that were easily lost. Zero tracking visibility meant no way to know which testers received apps or what progress was made. The 14 day testing window was tracked mentally or on spreadsheets causing frequently missed deadlines. Apps had no formal lifecycle, notes and reviews were scattered across random chat threads, and three managers had no shared visibility across their portfolios. The agency was scaling its client base but the WhatsApp workflow was creating bottlenecks, missed deadlines, and frustrated testers.
The Solution
I built SparkTestX, a cross platform mobile app for iOS, Android, and macOS using Flutter with MVVM architecture and Riverpod state management. The backend runs on Supabase with PostgreSQL, Auth, Realtime subscriptions, Storage, and Row Level Security on every table. The app features a dual panel architecture with separate Admin and Tester interfaces. Managers can create apps with full metadata, manage them by package tier, update status through a complete pipeline from Testing to Approved to Delivered, pin high priority apps, attach Play Store review texts, and view a rich analytics dashboard with 8 plus chart widgets. Testers get an organized workspace with apps grouped by manager, an 18 step progress checklist covering Initial, Daily Testing, Review, and Final phases, priority alerts when 3 or fewer days remain, and one tap testing links. Supabase Realtime channels deliver instant updates across all devices. Firebase Cloud Messaging handles push notifications for new apps, status changes, deadline alerts at 3 day and 1 day marks, and daily 9 AM testing reminders. The app is fully offline first with SQLite caching, unsynced progress queuing, and sync on reconnect.
The Result
SparkTestX completely transformed the agency workflow. Task assignment went from WhatsApp broadcasts to one tap app creation with instant push notifications to all 12 testers. Progress visibility went from zero tracking to a real time 18 step checklist with percentage tracking per app per tester. Deadline tracking is now automated with smart countdown display and push alerts replacing mental tracking and spreadsheets. Three managers now have unified visibility across all portfolios through the analytics dashboard with delivery rates, overdue apps, and weekly trends at a glance. Testing throughput increased significantly as the structured workflow with daily checkmarks and review phases means testers complete cycles faster and more consistently. The app is production ready and actively used by the entire team daily.
Key Features
- Secure role based authentication with Supabase RLS
- Dual panel architecture for admins and testers
- Real time data sync via Supabase Realtime channels
- Firebase push notifications with deadline alerts
- 18 step test progress tracker with 4 phases
- Play Store review management system
- Interactive analytics dashboard with 8 plus charts
- Offline first architecture with SQLite and sync queue
- Smart deadline intelligence with countdown display
- Responsive multi platform UI with adaptive layout
- App logo management with auto crop and storage
- Smart trash and soft delete with tester notifications
