Generate low stock alerts from Shopify and export results to Sheets or CSV

by Stallkit Studio · 7 views · created 2026-10-13 · CRM

What this workflow does

This workflow has 20 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Config (Code): runs custom JavaScript code
2. Mode = mock? (If): checks a condition and branches into true / false
3. Mock inventory (fake data) (Code): runs custom JavaScript code
4. Build products query (Code): runs custom JavaScript code
5. Compute alerts (Code): runs custom JavaScript code
6. Shopify products (GraphQL) (HTTP Request): calls an HTTP API (POST)
7. Rows: Alerts (Code): runs custom JavaScript code
8. Rows: Summary (Code): runs custom JavaScript code
9. Build orders query (Code): runs custom JavaScript code
10. Alerts to sheet? (If): checks a condition and branches into true / false

…plus 9 more steps. See the full node list below.

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nodes used (7)

• Manual Triggern8n-nodes-base.manualTrigger
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest
• Google Sheetsn8n-nodes-base.googleSheets
• Convert to Filen8n-nodes-base.convertToFile
• Read/Write Files from Diskn8n-nodes-base.readWriteFile

From the author

Quick overview Free n8n workflow that flags OUT / LOW variants and suggests a reorder point from your last 30 days of unit sales. Demo mode uses built-in fake data; no LLM required. How it works 1. Runs manually and loads configuration such as data source…

View the original on n8n.io → Check your own copy