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”

THE WORKFLOW9 NODES
CCronSShopifyFFunction▦Google Sheets#SlackDDate & Time⑂IF–NoOp≡Set price
DIFFICULTY
Intermediate
NODES
9
USES AI
No
PUBLISHED
August 2021

001 / WHAT HAPPENS

  1. 01

    A Cron node starts the workflow every week on the day you choose.

  2. 02

    The Shopify node fetches your orders for the past week as a list.

  3. 03

    A function step and a set-price step calculate each order's sales value.

  4. 04

    A date check and IF step decide which orders to count.

  5. 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? →

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→