Skip to content
FlowHub
FluxonLab
Google Sheets
Ecommerce & Ordersfree

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

by Samir SaciUpdated Aug 2026
RequiresGoogle SheetsGoogle Sheets
Share Post Share
MaWhen clicking ‘Execute workflow’When clicking ‘…Get row(s) in sheetGet row(s) in s…FiFilter Out Zero SalesFilter Out Zero…CoTransposeCoDaily Sales per StoreDaily Sales per…IfIfSales Store 1Sales Store 2CoPareto AnalysisCoTO, QTY GroupBy ITEMTO, QTY GroupBy…CoTO GroupBy (STORE, ITEM)TO GroupBy (STO…Multi-Store SalesMulti-Store Sal…CoDemand Variability x Sales %Demand Variabil…ABC XYZ AnalysisUpdate Pareto SheetUpdate Pareto S…CoABC Class MappingABC Class Mappi…123456789101112131415
1/5
STEPS · 15
Run manually by an operator

On manual run, reads inventory from Google Sheets and computes ABC and Pareto classifications to rank items by value for supply-chain prioritization.

Tags

manualcomplexGoogle SheetsMarket Researchdiscoveredpending-review
Connects
sheetsGoogle Sheets
CategoryEcommerce & Orders
Triggermanual
Complexitycomplex
Nodes16
AddedJun 27, 2026