Skip to content

Daily Sales Summary

Example prompt: "Every morning at 8am, pull yesterday's Shopify orders, calculate total revenue and top-selling products, and post a summary to #sales on Slack."

How to automate daily sales reporting with GloriaMundo

The Problem

Knowing how yesterday went is a basic need for any shop owner, but getting that answer usually means logging into Shopify, navigating to the analytics page, mentally noting the numbers, and perhaps copying them into a spreadsheet or message for the team. It takes only a few minutes, but it is one of those tasks that falls through the cracks on busy days — and when it does, the team loses visibility into trends like a sudden drop in orders or an unexpected spike in a particular product category.

How GloriaMundo Solves It

We build a scheduled workflow that runs each morning. An integration step fetches all orders from Shopify for the previous day. A code step calculates the key metrics: total revenue, number of orders, average order value, and the top 5 best-selling products by quantity. A conditional step checks whether revenue was significantly above or below the trailing 7-day average (also tracked via a state step) and flags it if so. An LLM step composes a concise morning briefing with the numbers, any notable trends, and a plain-language note if something looks unusual. An integration step posts the summary to Slack and optionally sends it via email. Glass Box preview shows you the calculated metrics and the draft summary before the first run.

Example Workflow Steps

  1. Trigger (scheduled): Runs every morning at 8:00 AM.
  2. Step 1 (integration): Fetch all Shopify orders from the previous day.
  3. Step 2 (code): Calculate total revenue, order count, average order value, and top 5 products by units sold.
  4. Step 3 (state): Retrieve the trailing 7-day average revenue and update it with today's figure.
  5. Step 4 (conditional): Flag if yesterday's revenue was more than 20% above or below the 7-day average.
  6. Step 5 (llm): Write a concise morning sales briefing with key metrics, top products, and any anomaly notes.
  7. Step 6 (integration): Post the summary to #sales on Slack and optionally send a copy via Gmail.

Integrations Used

  • Shopify — source of order data for the previous day
  • Slack — receives the morning sales summary so the whole team starts the day informed
  • Gmail — optional email delivery for stakeholders who prefer inbox over Slack

Who This Is For

E-commerce shop owners, operations managers, and marketing leads who want a daily pulse on sales performance without manually checking dashboards. Especially valuable for teams of 2-10 people where not everyone has Shopify admin access but everyone benefits from knowing how the shop is performing.

Time & Cost Saved

The manual version of this task takes about 10 minutes per day — pulling up Shopify, scanning the numbers, and typing a summary for the team. That is nearly an hour per week of low-value work. More importantly, this workflow catches anomalies the moment they appear rather than when someone happens to check. A sudden drop in orders flagged at 8 AM gives you the whole day to investigate, rather than discovering it two days later. The workflow uses integration, code, state, conditional, and LLM steps, costing a few credits per daily run.