Shopify & WooCommerce inventory sync with Google Sheets alerts

by Cheng Siong Chin ✓ · 138 views · created 2025-10-30 · CRM

What this workflow does

This workflow has 20 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).

1. 📝 Parse Trigger Data (Edit Fields (Set)): sets 4 fields: triggerType, sku, platform…
2. 📝 Prepare Update Actions (Code): runs custom JavaScript code
3. 🛍️ Fetch Shopify Inventory (HTTP Request): calls an HTTP API
4. 🛒 Fetch WooCommerce Inventory (HTTP Request): calls an HTTP API
5. 🚨 Needs Manual Review? (If): checks a condition and branches into true / false
6. Merge: merges the data from its input branches
7. 📊 Log to Google Sheets Audit (Google Sheets): append or update
8. 🔀 Split Updates by Platform (Code): runs custom JavaScript code
9. 🔍 Compare & Identify Discrepancies (Code): runs custom JavaScript code
10. 📧 Send Notification? (If): checks a condition and branches into true / false

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

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nodes used (11)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Webhookn8n-nodes-base.webhook
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Mergen8n-nodes-base.merge
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Switchn8n-nodes-base.switch
• Google Sheetsn8n-nodes-base.googleSheets
• Gmailn8n-nodes-base.gmail
• Respond to Webhookn8n-nodes-base.respondToWebhook

From the author

How It Works A webhook or timer triggers the workflow to automatically fetch inventory data from multiple platforms. Stock levels are compared across stores to identify discrepancies, and any inconsistencies are updated on the respective platforms in real…

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