🔤 Inventory ABC & Pareto analysis with Google Sheets for supply chain
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 companies optimise inventory and logistics operations by combining data analytics and workflow automation. This workflow is part of our inventory optimisation toolkit, allowing businesses to perform ABC classification and Pareto analysis directly fr
At a glance
🔤 Inventory ABC & Pareto analysis with Google Sheets for supply chain is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets, LinkedIn
- Modules
- 16
- Price
- Free
- Version
- v1.0

About this workflow
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 companies optimise inventory and logistics operations by combining data analytics and workflow automation. This workflow is part of our inventory optimisation toolkit, allowing businesses to perform ABC classification and Pareto analysis directly from their transactional sales data. > Automate inventory segmentation with n8n! 📬 For business inquiries, feel free to connect with me on LinkedIn Who is this template for? This workflow is designed for supply chain analysts, demand planners, or inventory managers who want to: - Identify their top-performing items (Pareto 80/20 principle) - Classify products into ABC categories based on sales contribution - Evaluate demand variability (XYZ classification support) Imagine you have a Google Sheet where daily sales transactions are stored: []( The workflow aggregates sales by item, calculates cumulative contribution, and assigns A, B, or C classes. It also computes mean, standard deviation, and coefficient of variation (CV) to highlight demand volatility. []( How does it work? This workflow automates the process of ABC & Pareto analysis from raw sales data: - 📊 Google Sheets input provides daily transactional sales - 🧮 Aggregation & code nodes compute sales, turnover, and cumulative shares - 🧠 ABC class mapping assigns items into A/B/C buckets - 📈 Demand variability metrics (XYZ) are calculated - 📑 Results are appended into dedicated Google Sheets tabs for reporting []( 🎥 Watch My Tutorial Steps: 1. 📝 Load daily sales records from Google Sheets 2. 🔎 Filter out items with zero sales 3. 📊 Aggregate sales by store, item, and day 4. 📈 Perform Pareto analysis to calculate cumulative turnover share 5. 🧮 Compute demand variability (mean, stdev, CV) 6. 🧠 Assign ABC classes based on cumulative share thresholds 7. 📥 Append results into ABC XYZ and Pareto output sheets []( What do I need to get started? You’ll need: - A Google Sheet with sales transactions (date, item, quantity, turnover) that is available here: Test Sheet - A Google Sheets account connected in n8n - Basic knowledge of inventory analysis (ABC/XYZ) Next Steps 🗒️ Use the sticky notes in the n8n canvas to: - Add your Google Sheets credentials - Replace the Sheet ID with your own sales dataset - Run the workflow and check the output tabs: ABC XYZ, Pareto, and Store Sales This template was built using n8n v1.107.3 Submitted: September 15, 2025
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Add new Service Provider Pro orders to a Google Sheets spreadsheet
Search for contacts in Apollo and add them to Google Sheets
Build a chatbot, voice and phone agent with Voiceflow, Google Calendar and RAG
[AI Tools 101] Restructuring data with Google Sheets and ChatGPT
Generate personalized icebreakers
Save new Printavo orders to a Google Sheets spreadsheet
Send Telegram text and audio messages to Notion with DeepSeek summaries & OpenAI transcription
Automate blog-to-social media with GPT-4 for LinkedIn, X, and Reddit
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you