SpotOn Weekly Top-Sellers Report Automation
Every Monday morning, WebRun opens SpotOn's item sales report for the prior week, ranks items by revenue and by units sold, appends the weekly snapshot to a running Google Sheets tracker, and posts a top-10 summary to your Slack channel so the team can act on it before the week begins.
How do I automatically generate a weekly top-sellers report from SpotOn?
WebRun opens SpotOn's item sales report every Monday, ranks last week's items by revenue and by units sold, and logs the results in a rolling Google Sheets tracker. It then posts your top 10 to Slack with streak and drop-off signals, giving your team the data to make menu and inventory calls at the start of each week.
- Menu decisions backed by last week's actual SpotOn sales data
- Multi-week trends visible in Google Sheets without manual logging
- Team briefed on top performers every Monday before service begins
Built for restaurant owners · bar and nightclub operators · retail managers · food and beverage directors
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
spoton.comin a real browser with your saved login - no setup, no API keys. -
1
SpotOn - pull last week's item sales by revenue and units
spoton.com
WebRun opens SpotOn to pull last week's item sales by revenue and units. - Open SpotOn reporting and set the date range to the previous Monday through Sunday
- Export the item sales report showing item name, category, quantity sold, and net revenue
- Identify the top 10 items by revenue and the top 10 items by units sold
Done when Last week's top items are ranked by revenue and by units sold from SpotOn.
-
2
Google Sheets - append weekly snapshot to rolling tracker
google.com
WebRun opens Google Sheets to append weekly snapshot to rolling tracker. - Open the weekly top-sellers tracker and append a new dated row for each top-10 item
- Calculate which items have appeared in the top 10 for three or more consecutive weeks
- Flag any item that dropped out of the top 10 this week after appearing the previous week
Done when This week's data is logged and trend signals are calculated in Google Sheets.
-
3
Slack - post top-10 summary for the team
slack.com
WebRun opens Slack to post top-10 summary for the team. - Post the top 10 items by revenue to the menu or operations Slack channel
- Note any items on a consecutive-week streak and any that dropped off from last week
- Include a link to the Google Sheets tracker for the full ranked list
Done when The weekly top-sellers summary is posted to Slack for the team.
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
Does it rank by revenue, by units, or both?
Both. WebRun produces two rankings from SpotOn each week: top 10 items by net revenue and top 10 items by units sold, because a high-volume low-margin item and a premium seller tell different stories.
Can I see trends across multiple weeks, not just last week?
Yes. Every week's results are appended to a running Google Sheets tracker, so you can filter by item or date range to see how any item's rank has changed over time.
Does it cover all menu categories or just food?
It pulls all item categories from SpotOn's item sales report, including food, beverages, and retail. You can filter the Sheets tracker by category if you want a category-specific view.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.