Daily Sales & Orders Digest
Every morning, WebRun opens Shopify Analytics for yesterday, captures revenue, order count, average order value, and top-selling SKUs, logs them in your sales sheet, and posts a one-page digest to your #ecom Slack channel.
Shopify
read yesterday's sales and orders
How can I automatically get a daily sales and orders digest from Shopify?
Every morning WebRun opens Shopify Analytics for yesterday, captures revenue, order count, average order value, and top-selling SKUs, logs the data in your sales sheet, and posts a one-page digest to your Slack channel - so you walk into your day knowing exactly where you stand.
- Yesterday's key metrics land in Slack before the workday starts
- Top and bottom performers visible every morning without logging in
- Sales data logged to a sheet for trend tracking over time
Built for Shopify store owners · ecommerce managers · retail founders · DTC brand 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
admin.shopify.comin a real browser with your saved login - no setup, no API keys. -
1
Shopify - read yesterday's sales and orders
WebRun opens Shopify to read yesterday's sales and orders. - Open Shopify Admin > Analytics > Overview and set the date range to yesterday
- Capture total revenue, order count, average order value, and units sold
- Open the Top Products report and note the top 5 SKUs by revenue
- Note any orders still unfulfilled from yesterday
Done when Yesterday's revenue, order count, AOV, and top 5 products are captured.
-
2
Google Sheets - log metrics to the sales tracker
google.com
WebRun opens Google Sheets to log metrics to the sales tracker. - Open the Daily Sales Tracker sheet
- Append a row with the date, revenue, order count, AOV, and top SKU
- Update the 7-day rolling average formulas in the summary row
Done when Yesterday's figures are logged and the rolling averages are updated.
-
3
Slack - post the morning digest
slack.com
WebRun opens Slack to post the morning digest. - Post the digest to #ecom: revenue vs prior day, order count, AOV, and the top 5 SKUs
- Add a trend arrow (up/down) based on the rolling average comparison
- Link to the full sheet for anyone who wants the detail
Done when The morning digest is posted to Slack.
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.
Shopify
Sign in once
Every action is checked against this policy before it runs.
Questions, answered
Can I change which metrics appear in the digest?
Yes - tell WebRun which Shopify Analytics panels to read (refunds, sessions, conversion rate, etc.) and it will include them in every report.
Will the sheet grow indefinitely?
It appends one row per day. A year of data is only 365 rows - Google Sheets handles that comfortably. You can set a retention limit in the plan if you prefer.
What if Shopify Analytics is slow to update overnight?
The run waits for the report to fully load before reading. If data is still missing after a timeout, it notes 'data pending' and skips that metric rather than logging zero.
Related templates
Shopify›Shopify›
Amazon Seller›Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.