Quick overview
Get a Telegram message the moment a Shopify order comes in, log every order to an n8n Data Table, flag big orders with a 🔥 alert, and receive a short sales summary every evening. No Shopify app or API token needed.
How it works
- Shopify sends an Order creation webhook to n8n. The workflow replies 200 right away, then parses the order into a readable message with order number, customer, items with SKU, total, discount, shipping country and a direct link to the order in Shopify admin.
- Every order is saved as a row in an n8n Data Table (order, customer, country, items, total, currency, big order flag, date). An IF node checks the total against your threshold and sends either a 🔥 Big order alert or a normal 🛒 New order alert to Telegram.
- A schedule runs every evening, reads today's rows from the Data Table and sends one sales summary: number of orders, items sold, revenue and top countries. Shopify's test order #9999 is ignored so tests don't change your numbers.
Setup
- Create a Data Table with the columns order_name, customer, country, items, total, currency, big_order and ordered_at, and select it in Log order and Get logged orders.
- Create a Telegram bot with @BotFather, add the Telegram credential to the three Telegram nodes and set your chat ID (send the bot a message, then open api.telegram.org/bot<TOKEN>/getUpdates).
- In the Parse order Code node set STORE_HANDLE (the part after /store/ in your Shopify admin URL) and the BIG_ORDER threshold. Set your timezone in Workflow settings.
- Activate the workflow and copy the Webhook Production URL. In Shopify admin open Settings → Notifications → Webhooks → Create webhook, choose Order creation, JSON format, paste the URL, then click Send test and check Telegram.
Requirements
- A Shopify store (any plan), a Telegram bot token and an n8n instance with Data Tables.
Customization
- Change the summary time in the Every evening node, send alerts to a team group, or add more fields (payment status, tags) in Parse order.