AutomationMart
Home/Browse/🔤 Inventory ABC & Pareto analysis with Google Sheets for supply chain
n8n

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

n8nn8n16 modulesv1.0
Google SheetsLinkedIn

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
🔤 Inventory ABC & Pareto analysis with Google Sheets for supply chain workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Every time there is a new order in Service Provider Pro, Make will automatically add this order to a Google Sheets spreadsheet as new row. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/10nODw2DmXjhhWH7Cgp1Swxrodxu5b_1dtr5KJWw2ZVs/edit?usp=sharing).

Free

Search for contacts in Apollo and add them to Google Sheets

Automatically search for contacts in Apollo and add them to Google Sheets for streamlined data management and easy access to contact information.

Free

Build a chatbot, voice and phone agent with Voiceflow, Google Calendar and RAG

Voiceflow is a no-code platform that allows you to design, prototype, and deploy conversational assistants across multiple channels—such as chat, voice, and phone—with advanced logic and natural language understanding. It supports integration with APIs, webhooks, and even tools like Twilio for phone agents. It's perfect for building customer support agents, voice bots, or intelligent assistants. This workflow connects n8n and Voiceflow with tools like Google Calendar

Free

[AI Tools 101] Restructuring data with Google Sheets and ChatGPT

Discover how to convert unstructured data into organized, structured information using Google Sheets and ChatGPT in this [AI Tools 101](https://www.youtube.com/watch?v=fNCy9tsp108&list=PLrED3I754LhmTtlldfGklaEMh-ZaCa3EK&index=8&ab_channel=Make) course template. Simplify your data management process and enhance accuracy with automated text-to-structure transformation.

Free

Generate personalized icebreakers

Overview Create hyper-personalized cold outreach messages at scale by combining Google Sheets, web scraping, and AI. This workflow is perfect for sales teams, SDRs, and agency owners looking to boost reply rates with icebreakers that actually feel personal. It takes lead info from a Google Sheet—including name, email, company, and website—then visits each site, pulls meaningful text, and crafts a tailored message using AI. The personalized message is then written back into your lead sheet

Free

Save new Printavo orders to a Google Sheets spreadsheet

Every time a new order is created in Printavo, Make will automatically add it to a new row in a Google Sheet spreadsheet. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1g2hkn6PSp-vji6Hnmzj6zaSTpBLZD_9GvRpEDDVn9ic/edit?usp=sharing).

Free

Send Telegram text and audio messages to Notion with DeepSeek summaries & OpenAI transcription

Streamline Your Communication and Task Management with the Telegram to Notion Automation This powerful automation effortlessly connects your Telegram messages with your Notion workspace, transforming how you capture information and manage tasks. What it does: Automatic Capture: Instantly captures messages, voice notes, and audio files sent to your designated Telegram chat. Intelligent Processing: Text messages are automatically summarized into clear, plain-text descriptions using advanced AI (De

Free

Automate blog-to-social media with GPT-4 for LinkedIn, X, and Reddit

Turn your blog into a set-and-forget content engine: every new article is instantly repurposed into channel-specific social posts with visuals, keeping your brand visible on LinkedIn, X, and Reddit without extra copywriting time. Perfect for lean marketing teams who want consistent, always-on distribution from a single source of content. How it works • Watches your blog RSS feed (or receives a single URL) and detects new articles. • Saves each post in Postgres so every article is only processed

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free