Automated Restroworks Outlet Scorecard
Every Monday, WebRun opens Restroworks, pulls each outlet's sales, food cost percentage, labor cost percentage, and wastage for the past week, combines them into one ranked scorecard, logs it to a shared Google Sheet, and posts the ranked list to Microsoft Teams so leadership sees the whole chain at a glance.
How do I rank every restaurant outlet's weekly performance automatically?
Every Monday, WebRun opens Restroworks, pulls each outlet's sales, food cost percentage, labor cost percentage, and wastage for the past week, and scores every outlet against the chain average. It logs the ranked scorecard to Google Sheets with 4 weeks of trend, and posts the ranked list to Microsoft Teams for leadership.
- Leadership sees every outlet ranked on the same measures every Monday
- The top and bottom 3 outlets are named, not buried in a spreadsheet
- 4 weeks of trend ride along, so a slipping outlet is caught early
Built for restaurant chain leadership · multi-outlet operations directors · regional restaurant managers · F&B operations teams
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
app.restroworks.comin a real browser with your saved login - no setup, no API keys. -
1
Restroworks - pull each outlet's weekly performance numbers
restroworks.com
WebRun opens Restroworks to pull each outlet's weekly performance numbers. - Open Restroworks and pull each outlet's sales, food cost percentage, labor cost percentage, and wastage for the past 7 days
- Score each outlet against the chain average on every measure
- Rank outlets from best to worst on the combined score
Done when Every outlet is scored and ranked on the week's core numbers.
-
2
Google Sheets - log the ranked scorecard
google.com
WebRun opens Google Sheets to log the ranked scorecard. - Open the shared outlet scorecard in Google Sheets
- Log this week's rank and every underlying number per outlet
- Keep the prior 4 weeks visible so a trend, not just one week, is easy to see
Done when This week's scorecard is logged with the trailing weeks still visible.
-
3
Microsoft Teams - post the scorecard to leadership
microsoft.com
WebRun opens Microsoft Teams to post the scorecard to leadership. - Post the ranked scorecard to the leadership channel in Microsoft Teams
- Call out the top and bottom 3 outlets by name
- This is an internal leadership report, so post it straight through
Done when Leadership has this week's ranked outlet scorecard in Microsoft Teams.
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
What numbers make up the score?
Each outlet's sales, food cost percentage, labor cost percentage, and wastage for the past 7 days, all pulled straight from Restroworks and measured against the chain average, so the score reflects your own chain's numbers, not an external benchmark.
Does it penalize a smaller outlet for lower total sales?
No. Outlets are scored on percentages and ratios such as food cost and labor cost, not raw sales totals, so a smaller outlet running tight numbers can still rank above a bigger one running loose.
Can leadership see more than just this week?
Yes. The Google Sheet keeps the prior 4 weeks visible alongside the current one, so a slipping outlet shows up as a trend, not just a single bad week.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.