PICKED FROM N8N.IO · ONLINE STORE
Every week this workflow gets your Shopify orders and works out their sales value. It saves the figures in Google Sheets and posts a notification in a Slack channel. Despite the title, the nodes calculate sales totals, not stock levels.
Template by Lorena · 5.5k views on n8n.io · listed there as “Run weekly inventories on Shopify sales”
- DIFFICULTY
- Intermediate
- NODES
- 9
- USES AI
- No
- PUBLISHED
- August 2021
001 / WHAT HAPPENS
- 01
A Cron node starts the workflow every week on the day you choose.
- 02
The Shopify node fetches your orders for the past week as a list.
- 03
A function step and a set-price step calculate each order's sales value.
- 04
A date check and IF step decide which orders to count.
- 05
Google Sheets stores the result and Slack posts a message to your channel.
WHO IT SUITS
Suits a small online store owner who wants a simple weekly sales record and a Slack nudge without opening Shopify reports.
CONNECTS
- Shopify
- Google Sheets
- Slack
002 / BEFORE YOU USE IT HERE
- !It uses older Cron, Function and Date and Time nodes that are deprecated. They may need replacing with Schedule Trigger and Code nodes when you import it.
- !Set the workflow timezone to Australia/Sydney (or your city) so the weekly cut-off matches your trading week.
- !Shopify reports in your store currency, so check the totals are in AUD and whether GST is included before using them.
LOCAL SWAP
Swap Slack for Microsoft Teams or an email node if your team does not use Slack.
Need n8n and the AI hosted in Australia? →003 / MORE FOR ONLINE STORE
- 31 NODESAI
ONLINE STORE
Answer WooCommerce order and DHL tracking questions with AI chat
WooCommerceDHLOpenAIAdvancedby Jan Oberhauser20.7k views - 9 NODESAI
ONLINE STORE
Write WooCommerce SEO titles and descriptions with AI and Sheets
WooCommerceGoogle SheetsOpenRouterYoast SEOIntermediateby Davide Boizza7.5k views - 8 NODES
ONLINE STORE
Mark digital Shopify orders as fulfilled automatically on a schedule
ShopifyShopify Admin APIBeginnerby bangank366.1k views
004 / QUESTIONS
Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.
Yes. Every template on this list is free on n8n.io. You need an n8n account (n8n Cloud or self-hosted) and accounts for the apps it connects to, some of which charge for API use.
We adapt templates to your systems, add approval steps where customers are involved, host n8n in Australia when the data calls for it and hand it over documented.
Book a free call→