Context
The challenge
Delivering timely, AI-powered business insights to multiple clients while managing scheduled analysis and automated notifications is operationally challenging. Manually generating personalized reports, coordinating scheduled executions across time zones, and ensuring accurate delivery of email and SMS based on AI-generated content is complex, time-consuming, and error-prone.
How we worked
Our approach
We built the AI Snapshot system to automate scheduled business analysis and notification delivery. It executes business insights on selected dates and times, processes multiple businesses asynchronously, generates email and SMS templates from AI output, and sends notifications when snapshots are approved.
Delivery
The solution
Scheduled AI-powered analysis runs on recurring or one-time schedules, processes multiple businesses concurrently via AWS SQS, and builds prompts using business data with Summary and Count APIs. Automated content generation produces email and SMS from LLM responses, tracks approval workflow (PENDING, APPROVED, REJECTED), and sends batch notifications with delivery status. Dual APIs support admin operations and business-specific snapshot queries.
Results
Key metrics
- Async multi-business
- Processing
- PENDING/APPROVED/REJECTED
- Workflow
- Admin + business-specific
- APIs
- Email + SMS
- Delivery
Impact
Results & outcomes
- Eliminated manual data analysis with consistent, timely delivery of insights
- Scalable processing of multiple businesses via asynchronous execution
- Automated email and SMS delivery from AI-generated content
- Full visibility of snapshots per business with execution and notification status
- Approval workflow before sending ensures quality and compliance
Tech used
Technology stack
Tools and patterns from this engagement—your stack may differ.