Monthly Supplier Scorecard
On the first of each month, reads last month's deliveries from Google Sheets and scores every supplier on on-time delivery and accepted quantity. Saves the scores to a Scorecards tab and emails the supplier report.
Steps in this flow
- First of the month 8:00
- Google Sheets: read deliveries
- Score each supplier
- Google Sheets: save the scores
- Email the supplier report