Sales Drop Alert
Every workday evening, compares today's sales with the same weekday last week from your database. If sales fell by more than your limit, the sales manager gets an alert. Each check is logged in Google Sheets.
Steps in this flow
- Every workday 21:00
- Query today and last week
- Work out the change
- Drop above the limit?
- Alert the sales manager
- Google Sheets: log the check