Start every day knowing exactly how your store performed
Every morning, WebRun opens City Hive, pulls yesterday's sales totals broken down by category, identifies the top-selling products, and posts a concise daily digest to your Slack channel with a link to the running log in Google Sheets.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I get an automated daily sales report for my liquor store?
WebRun opens City Hive every morning, pulls yesterday's sales by category and top-selling products, logs the figures in Google Sheets, and posts a concise digest to your Slack channel. Your team starts the day with a clear picture of how the store performed without anyone pulling a report manually.
- Team starts every morning with yesterday's numbers in Slack
- No manual report pulling needed from City Hive
- Running log in Google Sheets tracks trends week over week
Built for liquor store owners · bottle shop managers · wine and spirits retailers · beverage retail 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
www.cityhive.netin a real browser with your saved login - no setup, no API keys. -
1
City Hive - pull yesterday's sales data
cityhive.net
WebRun opens City Hive to pull yesterday's sales data. - Open City Hive and navigate to the sales or reporting dashboard
- Set the date filter to yesterday
- Capture total revenue, transaction count, and revenue by category (beer, wine, spirits, other)
- Identify the top five selling products by revenue
Done when Yesterday's total revenue, category breakdown, and top sellers are captured.
-
2
Google Sheets - append to the running sales log
google.com How to Automate Google Sheets
WebRun opens Google Sheets to append to the running sales log. - Open the daily sales log sheet
- Append a new row with the date, total revenue, category totals, and transaction count
- Update any running weekly and monthly totals in the summary tab
Done when Yesterday's figures are logged and the running totals are updated in Google Sheets.
-
3
Slack - post the daily digest
slack.com How to Automate Slack
WebRun opens Slack to post the daily digest. - Post a short digest to the store channel: date, total revenue, top three categories, top seller
- Include a link to the Google Sheets log for full detail
- Note any category that is tracking below the prior seven-day average
Done when The team has yesterday's sales summary in Slack with a link to the full log.
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 include online and in-store sales in the same report?
Yes. City Hive consolidates both channels, so WebRun reports on the combined figure. The digest notes the split between channels if that data is available in your dashboard.
Can I change which categories or metrics are included?
Yes. Tell WebRun which categories and metrics matter to your store and it will focus the digest on those. You can also ask it to compare to a prior period.
Is any sales data shared outside the team?
No. The Slack post goes to your internal store channel and the Google Sheets log is private to your workspace. No data leaves your accounts.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.