Daily Sales Target Tracker on WhatsApp
Every workday evening, reads each sales rep's target and achieved amount from a Google Sheet and sends them their progress, percentage and the amount left, on WhatsApp.
Steps in this flow
- Every workday 17:00
- Google Sheets: read targets
- For each rep
- Target above zero?
- Achieved ÷ target
- Convert to percent
- Round the percent
- Amount left
- WhatsApp progress to the rep