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

  1. First of the month 8:00
  2. Google Sheets: read deliveries
  3. Score each supplier
  4. Google Sheets: save the scores
  5. Email the supplier report

All templates