E-commerce & Dropshipping · n8n

Shopify Daily Sales Report: yesterday's revenue, orders, and best-sellers in your Telegram every morning

An n8n workflow that pulls yesterday's orders from Shopify every morning at 8:00, calculates revenue, order count, average order value, and the top 3 products, then sends a tight one-message report to your Telegram — no dashboard login needed.

difficulty Beginnersetup 25 minresult A daily P&L snapshot in your pocket before your first coffee
  1. 1

    Wake up at 8:00 every morning

    Add a Schedule Trigger node set to 08:00 in your store's timezone. The report covers the previous calendar day, so 8:00 gives Shopify plenty of time to settle late-night orders.

  2. 2

    Pull yesterday's orders from Shopify

    Add a Shopify node with operation Get Many Orders, filtered by created_at_min = yesterday 00:00 and created_at_max = yesterday 23:59. Connect your store with a custom app access token (Admin API, read_orders scope only — never grant more than you need).

  3. 3

    Crunch the numbers

    Add a Code node that sums net revenue (total minus refunds), counts orders, computes average order value, and tallies quantity per product title to find the top 3 sellers. Everything is plain arithmetic on the order array — no external calls.

  4. 4

    Send the report to Telegram

    Add a Telegram node sending to your private chat. The message reads like: 📊 Mon Jun 1 — Revenue: $1,284 (18 orders, AOV $71) — Top: Phone Case x9, Charger x6, Cable x5. Create the bot once with @BotFather and paste the token as an n8n credential.

Frequently asked questions

Does this need any paid tools?

No. Shopify's Admin API is included in every plan, Telegram bots are free, and the whole flow runs on a self-hosted n8n for free (or n8n cloud from $24/mo). There are no AI calls in this recipe, so the running cost is zero.

Can I get the report in Slack or WhatsApp instead?

Yes. Swap the final Telegram node for n8n's Slack node (2 minutes) or a Twilio WhatsApp node. The message text is built in the Code step, so the formatting carries over unchanged.

What about refunds and cancelled orders?

The Shopify node fetches orders with status 'any', and the Code step subtracts refunded totals so your revenue number is net, not gross. Cancelled orders are excluded from the order count.

Related recipes

TikTok Trend Product Radar: spot winning dropshipping products twice a week, automatically

An n8n workflow that scrapes trending TikTok product videos twice a week, has Claude score each product for saturation and audience fit, then logs everything to Google Sheets and pings your Telegram with the top 5.

Intermediate · 45 min setup

Product Review Summarizer: 500 competitor reviews distilled into what buyers actually want

An n8n workflow that scrapes the reviews of any Amazon or AliExpress product with an Apify actor, has Claude cluster them into top praises, top complaints, and unmet wishes, and writes a one-page product-improvement brief to Google Sheets — market research that used to take a weekend, done in minutes.

Intermediate · 40 min setup

Low-Stock Alert: never oversell again — a ping before inventory hits zero

An n8n workflow that checks your Shopify inventory levels twice a day, flags every variant below its reorder threshold, and sends one consolidated Telegram message listing exactly what to reorder — instead of you discovering stockouts from angry customer emails.

Beginner · 20 min setup
About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.