Delayed visibility
Decision-makers had to wait for reports or ask for updates.
Back to case studies
Case study
Automated SMS Sales Report
Key people needed timely visibility into daily sales performance without waiting for manual reports. I built an AWS-scheduled Lambda workflow that pulls sales totals, formats a concise executive SMS, and sends it to a controlled list of decision-makers.
IndustryRetail and operations
Company sizeGrowing SME
DepartmentLeadership and finance
Overview
Manual sales updates became scheduled executive visibility.
The system helped key people receive same-day sales performance updates without waiting for staff to log in, calculate totals, format messages, and send numbers manually.
The business problem
Sales performance updates were too dependent on manual reporting.
Leadership and shareholders needed regular visibility into today's total sales, gross, and margin percentage. Manual updates created delay, repeated admin work, and inconsistent timing.
Repeated manual work
Staff had to calculate, format, and send recurring performance summaries.
Inconsistent communication
Different people could receive updates at different times or in different formats.
Login dependency
Reporting required system access, authentication, and manual retrieval before the message could be sent.
Recipient risk
Sales updates needed to go only to selected leaders, not a broad customer list.
Mobile-first updates
Executives needed the numbers in a format they could read quickly without opening a dashboard.
Challenges
The report needed to be timely, accurate, and simple to read.
- Reliable calculationsTotal sales, gross, net, and margin percentage needed consistent business logic.
- Recipient controlThe right people needed the right updates without exposing unnecessary information.
- TimingReports needed to run on schedule without staff intervention.
- Short formatSMS messages needed to be concise enough for quick leadership review.
- Authentication flowThe workflow needed to obtain system access before requesting reporting data and sending SMS.
- Timezone accuracyThe message needed a clear Manila timestamp so recipients knew exactly when the numbers were taken.
- Send safetyThe SMS step needed a guardrail to prevent accidental sending to unintended recipients.
Solution
A scheduled Lambda workflow for executive sales visibility.
I created an AWS-scheduled automation that authenticates with the internal system, requests today's sales computation, extracts the key figures, formats the values in Philippine peso, and prepares a short SMS summary.
The message includes the Manila timestamp, total sales, gross, and margin percentage so leaders can understand the current sales picture at a glance.
The SMS send step uses a controlled recipient list and includes a safety check that stops execution if there are no intended recipients, reducing the risk of sending sensitive business data to the wrong audience.
System architecture
From scheduled Lambda run to executive SMS visibility.
The workflow connects AWS scheduling, authentication, sales computation, message formatting, recipient guardrails, and SMS delivery.
AWS Scheduler
Lambda function
System auth
Sales computation
SMS format
Recipient guardrail
SMS delivery
Business results
Leadership received clearer recurring performance updates.
- Faster visibilityKey people received sales performance updates without waiting for manual reports.
- Reduced reporting adminStaff spent less time preparing and sending repeated summaries.
- Consistent formatRecipients received the same core numbers in a repeatable structure.
- Better operating rhythmSales, gross, and margin updates became part of a dependable reporting cadence.
- Mobile executive accessDecision-makers could see the numbers through SMS without opening a dashboard.
- Safer distributionThe automation used an explicit recipient list and send guardrail for sensitive reporting.
Technologies
Automation delivered the numbers where leaders already pay attention.
AWS LambdaAWS SchedulerNode.jsSales APISMS APIOAuth flowReporting logicTimezone formatting
Gallery
Real workflow proof from the automation.
The screenshots show the scheduled trigger, Lambda function, reporting flow, and sanitized SMS output received by decision-makers.
Scheduled reporting trigger
The report runs on a defined schedule in the Manila timezone, so leadership updates do not depend on someone remembering to prepare and send them manually.
Lambda function
The Lambda function handles the scheduled execution path that authenticates, retrieves sales numbers, formats the message, and sends the SMS update.
Reporting flow
The workflow follows a simple operating path: authenticate, retrieve the current sales data, format the executive summary, then send the SMS.
Sanitized SMS report
The final message gives decision-makers a fast mobile summary with timestamp, total sales, gross, and margin values while keeping sensitive numbers hidden in the public case study.
Why this matters
Decision-makers should not have to chase core business numbers.
The workflow turned recurring sales reporting into a dependable communication system for people who need quick visibility, without requiring staff to manually gather and send the numbers.
Have a workflow that feels too manual?
Book a free discovery call and we will identify whether automation can reduce repetitive work in your business.
Book My Free Discovery Call