Shopify daily sales report in Slack
Every morning: yesterday's revenue, orders and best sellers, summarised by AI in Slack.
Level: Beginner · Time: about 10 minutes · Category: Sales, e-commerce & CRM
Watch the workflow being built in BeeGentic (no sound).
What it does
Every morning at 8:00 BeeGentic reads yesterday's Shopify orders. The AI summarises revenue, order count, best sellers and anything unusual, and posts it to your team's Slack.
You'll need
- A Shopify store (your admin must have Shopify configured) and Slack
Build it step by step
Schedule it
New workflow, delete Start, add Schedule: Daily at 08:00.
List yesterday's orders
Integrations → Shopify.
- Shopify Account: Connect
- Operation: List Orders
- Order Status: Any
- Search Query:
created_at:>=<yesterday>
Summarise with the Agent
User: Summarise yesterday's orders for the team: total revenue, number of orders, top 3 products, anything unusual. Orders: <shopify.orders>
Post to Slack
Slack → Send Message to #sales. Message: <agent.content>
The finished workflow
Example result
We ran the AI step of this recipe in BeeGentic (model gpt-5-mini) with a sample input. The text below is the actual output, unedited.
Sample input:
Summarise yesterday's orders for the team: total revenue, number of orders, top 3 products, anything unusual. Orders: [{"id":1001,"total":42.50,"items":["Honey Jar 500g","Beeswax Candle"]},{"id":1002,"total":18.00,"items":["Honey Jar 500g"]},{"id":1003,"total":129.90,"items":["Gift Box Deluxe","Honey Jar 500g"],"note":"shipping to Canada"},{"id":1004,"total":18.00,"items":["Honey Jar 500g"],"refunded":true}]What BeeGentic produced:
Summary — Yesterday's orders
- Revenue
- Net revenue (excluding refunded order): $190.40
- Gross revenue (including refunded order): $208.40
- Average order value (net, 3 non-refunded orders): $63.47
- Orders
- Total orders placed: 4
- Completed (non-refunded): 3
- Refunded: 1 (id: 1004)
- Top 3 products (by quantity sold, excluding refunded order)
1. Honey Jar 500g — 3 units
2. Beeswax Candle — 1 unit
3. Gift Box Deluxe — 1 unit
- Anything unusual / action items
- Refunded order 1004: needs follow-up to confirm reason and restock if applicable.
- Order 1003 is higher value ($129.90) and marked "shipping to Canada" — check international shipping/cross-border handling and customs paperwork.
- Honey Jar 500g is the best-seller yesterday — consider inventory check/replenishment.
If you want, I can produce a short email draft to follow up on the refund and the Canada shipment.
AI output varies from run to run. Change the wording of your prompt to change the style, length or tone.
Test it and switch it on
Click Run to get today's summary right away, then Deploy.
Make it yours
- Low stock alert: add Shopify List Inventory Items and a Condition.
- Weekly trends: run it weekly and append totals to a Google Sheet.
Something not working? See Troubleshooting or get help.