{
  "name": "🔤 Inventory ABC & Pareto analysis with Google Sheets for supply chain",
  "nodes": [
    {
      "id": "dd09796e-b4c4-43df-8401-bba895d330b3",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1056,
        -400
      ]
    },
    {
      "id": "5f502423-b87c-4322-aac6-10d07e685087",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -832,
        -400
      ]
    },
    {
      "id": "15e8b11a-83d9-41cb-84e4-dbfe0ddf970f",
      "name": "Filter Out Zero Sales",
      "type": "n8n-nodes-base.filter",
      "position": [
        -608,
        -400
      ]
    },
    {
      "id": "2cd9b9a0-dc4f-4d99-b4c4-43f6d165cad8",
      "name": "Transpose",
      "type": "n8n-nodes-base.code",
      "position": [
        -160,
        -592
      ]
    },
    {
      "id": "7bedeb08-f47e-4809-9936-7cdc8a9236d1",
      "name": "Daily Sales per Store",
      "type": "n8n-nodes-base.code",
      "position": [
        -384,
        -304
      ]
    },
    {
      "id": "b0134581-ef21-4485-bd75-8a5d7f865ad4",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        -160,
        -304
      ]
    },
    {
      "id": "95a2efc7-9c7b-4263-aab4-c00bbe902714",
      "name": "Sales Store 1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        64,
        -400
      ]
    },
    {
      "id": "fdffd98a-36ac-425b-861c-b3f738828fe2",
      "name": "Sales Store 2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        64,
        -208
      ]
    },
    {
      "id": "8a3afe9e-d873-4a02-9fb1-45fc9c380601",
      "name": "Pareto Analysis",
      "type": "n8n-nodes-base.code",
      "position": [
        -160,
        -784
      ]
    },
    {
      "id": "e8e1409d-b571-43b8-ae9e-bb8da228cefd",
      "name": "TO, QTY GroupBy ITEM",
      "type": "n8n-nodes-base.code",
      "position": [
        -384,
        -784
      ]
    },
    {
      "id": "9e02d5cb-701d-4a40-b2bf-c2fae43af8ef",
      "name": "TO GroupBy (STORE, ITEM)",
      "type": "n8n-nodes-base.code",
      "position": [
        -384,
        -592
      ]
    },
    {
      "id": "efe6f052-ff5d-4755-ae07-4a7bc480ddbb",
      "name": "Multi-Store Sales",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        64,
        -592
      ]
    },
    {
      "id": "5bd88834-9c20-4d9e-bd31-146dc31e2c18",
      "name": "Demand Variability x Sales %",
      "type": "n8n-nodes-base.code",
      "position": [
        -384,
        -16
      ]
    },
    {
      "id": "805e6a80-bb24-446e-ab9c-a0e0c68f555a",
      "name": "ABC XYZ Analysis",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        64,
        -16
      ]
    },
    {
      "id": "fb1b23cb-cad9-4a75-bb41-5d87209b51c5",
      "name": "Update Pareto Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        64,
        -784
      ]
    },
    {
      "id": "82773b29-a1dc-445c-a8ea-d9c393d36eb4",
      "name": "ABC Class Mapping",
      "type": "n8n-nodes-base.code",
      "position": [
        -160,
        -16
      ]
    },
    {
      "id": "21867671-78aa-4580-b51f-53c34f6a1dfa",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1166,
        -784
      ],
      "parameters": {
        "width": 540,
        "height": 544,
        "content": "### Trigger the workflow\nThis starts by collecting the transactional sales from the spreadsheet `Input Data` from the Google Sheet.\n\n#### How to setup?\n\n- **Load records in the Google Sheet Node**:\n  "
      }
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Sales Store 1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Sales Store 2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Transpose": {
      "main": [
        [
          {
            "node": "Multi-Store Sales",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Pareto Analysis": {
      "main": [
        [
          {
            "node": "Update Pareto Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ABC Class Mapping": {
      "main": [
        [
          {
            "node": "ABC XYZ Analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Filter Out Zero Sales",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "TO, QTY GroupBy ITEM": {
      "main": [
        [
          {
            "node": "Pareto Analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Sales per Store": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Out Zero Sales": {
      "main": [
        [
          {
            "node": "Demand Variability x Sales %",
            "type": "main",
            "index": 0
          },
          {
            "node": "TO, QTY GroupBy ITEM",
            "type": "main",
            "index": 0
          },
          {
            "node": "TO GroupBy (STORE, ITEM)",
            "type": "main",
            "index": 0
          },
          {
            "node": "Daily Sales per Store",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "TO GroupBy (STORE, ITEM)": {
      "main": [
        [
          {
            "node": "Transpose",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Demand Variability x Sales %": {
      "main": [
        [
          {
            "node": "ABC Class Mapping",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}