Automate Shopify inventory reordering with predictive analytics and Google Sheets

by Țugui Dragoș ✓ · 520 views · created 2025-12-14 · CRM, AI Summarization

What this workflow does

This workflow has 45 nodes and runs on a schedule (every hour). Along the way it connects Shopify, Google Sheets, Gmail and Slack.

How it runs

Trigger: On a schedule (every hour).

1. Workflow Configuration (Edit Fields (Set)): sets 6 fields: shopifyStoreUrl, reorderPointMultiplier, safetyStockDays…
2. Get Inventory Levels (Shopify): work with inventory level
3. Get Product Details (Shopify): get many (product)
4. Get Last 30 Days Orders (Shopify): get many
5. Read Suppliers (Google Sheets): uses Google Sheets
6. Read Purchase Order Log (Google Sheets): uses Google Sheets
7. Read Inventory Master (Google Sheets): uses Google Sheets
8. Merge: merges the data from its input branches
9. Calculate Sales Velocity (Code): runs custom JavaScript code
10. Calculate Dynamic Reorder Point (Code): runs custom JavaScript code

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

Services it uses

ShopifyGoogle SheetsGmailSlack

Before you upgrade to n8n 3.0

Nodes used (11)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Shopifyn8n-nodes-base.shopify
• Google Sheetsn8n-nodes-base.googleSheets
• Mergen8n-nodes-base.merge
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Gmailn8n-nodes-base.gmail
• HTTP Requestn8n-nodes-base.httpRequest
• Waitn8n-nodes-base.wait
• Slackn8n-nodes-base.slack

From the author

This workflow automates inventory management and predictive reordering for Shopify stores. It integrates Shopify, Google Sheets, and Slack to monitor inventory levels, calculate dynamic reorder points based on sales velocity, and automate supplier…

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