🔤 Inventory ABC & Pareto analysis with Google Sheets for supply chain

by Samir Saci ✓ · 1,426 views · created 2025-09-15 · Market Research

What this workflow does

This workflow has 16 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. Get row(s) in sheet (Google Sheets): uses Google Sheets
2. Filter: keeps only the items that match a condition
3. Demand Variability x Sales % (Code): runs custom JavaScript code
4. TO, QTY GroupBy ITEM (Code): runs custom JavaScript code
5. TO GroupBy (STORE, ITEM) (Code): runs custom JavaScript code
6. Daily Sales per Store (Code): runs custom JavaScript code
7. ABC Class Mapping (Code): runs custom JavaScript code
8. Pareto Analysis (Code): runs custom JavaScript code
9. Transpose (Code): runs custom JavaScript code
10. If: checks a condition and branches into true / false

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

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nodes used (5)

• Manual Triggern8n-nodes-base.manualTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Filtern8n-nodes-base.filter
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if

From the author

Tags: Supply Chain, Inventory Management, ABC Analysis, Pareto Principle, Demand Variability, Automation, Google Sheets Context Hi! I’m Samir Saci, a Supply Chain Engineer and Data Scientist based in Paris, and founder of LogiGreen Consulting. I help…

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