Daily KPI Digest (SQL to WhatsApp)
Every workday morning, runs a read-only SQL query on your Postgres or MySQL database for yesterday's orders, revenue and customers, and sends the numbers to a manager on WhatsApp with an email copy.
Steps in this flow
- Every workday 7:00
- Query yesterday's numbers
- Format the numbers
- WhatsApp digest to the manager
- Email copy