Run Your Weekly Vendor Scorecard
Every Monday, WebRun pulls delivery, invoice, and PO data from NetSuite, calculates a performance score for each active supplier, updates your scorecard spreadsheet, and posts the weekly vendor ranking to Slack.
How can I automatically score and rank my vendors each week?
Every Monday, WebRun pulls delivery, invoice accuracy, and PO data from NetSuite, calculates a performance score for each active supplier, updates your scorecard spreadsheet in Google Sheets, and posts the weekly vendor ranking to Slack - giving you an objective basis for supplier reviews and renegotiations.
- Every supplier scored on objective data every week
- Performance trends visible before contract renewals or renegotiations
- Underperforming vendors identified without manual data pulling
Built for procurement managers · supply chain teams · operations directors · vendor relationship managers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
system.netsuite.comin a real browser with your saved login - no setup, no API keys. -
1
NetSuite - pull delivery and invoice data per vendor
netsuite.com
WebRun opens NetSuite to pull delivery and invoice data per vendor. - Open Vendors and pull all POs received in the past 7 days with their promised vs. actual delivery dates
- Pull the associated vendor bills and flag any with price or quantity variances
- Note the average response time to PO acknowledgements for each supplier
Done when Delivery, invoice accuracy, and responsiveness data is captured for every active supplier.
-
2
Google Sheets - calculate and log scorecard
google.com
WebRun opens Google Sheets to calculate and log scorecard. - Open the Vendor Scorecard sheet and add this week's data row for each supplier
- Calculate the weighted score using your criteria: on-time delivery (50%), invoice accuracy (30%), responsiveness (20%)
- Update the rolling 12-week trend for each vendor
Done when This week's scores are logged and the running trend is updated for every supplier.
-
3
Slack - post weekly vendor ranking
slack.com
WebRun opens Slack to post weekly vendor ranking. - Post the weekly vendor ranking: top performers and any suppliers whose score dropped more than 10 points
- Flag vendors with three consecutive declining weeks for review
Done when The team has this week's vendor ranking digest with any at-risk suppliers clearly called out.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Can I change the scoring weights to match our priorities?
Yes - the weights in the Google Sheet formula are yours to adjust. Change them once and every future scorecard uses your criteria.
What happens with a vendor we only ordered from once this week?
It scores them on the data available and marks the sample size small so you weight the result accordingly.
Will it contact underperforming vendors?
No - it flags them for your attention in Slack. Any conversation with a vendor is always your decision to initiate.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.