{
  "name": "Send weekly WooCommerce finance KPIs to Slack using HTTP APIs",
  "nodes": [
    {
      "id": "3f54a9aa-e7a6-4a84-bd75-b9d4ce1826ff",
      "name": "Weekly KPI Scheduler",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        256,
        416
      ]
    },
    {
      "id": "2bf5cde8-0168-4bb7-8072-850d8fbdbaa2",
      "name": "Configure WooCommerce Store",
      "type": "n8n-nodes-base.set",
      "position": [
        448,
        416
      ]
    },
    {
      "id": "29bb5e64-1f35-410c-bd7e-947b157a0985",
      "name": "Fetch WooCommerce Orders",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        832,
        208
      ]
    },
    {
      "id": "9c533720-39af-4356-bde2-15beea052073",
      "name": "Filter Completed Orders",
      "type": "n8n-nodes-base.filter",
      "position": [
        1040,
        208
      ]
    },
    {
      "id": "8c61be2c-2990-40e5-ac02-77200fb0bc1d",
      "name": "Normalize Order Data",
      "type": "n8n-nodes-base.set",
      "position": [
        1232,
        208
      ]
    },
    {
      "id": "0152d7b7-5e0d-4f26-8b13-df64570cd99a",
      "name": "Fetch WooCommerce Refunds",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        912,
        560
      ]
    },
    {
      "id": "df2a22ab-ce71-4b11-89a6-fde6a627be9c",
      "name": "Normalize Refund Data",
      "type": "n8n-nodes-base.set",
      "position": [
        1120,
        560
      ]
    },
    {
      "id": "3f851e5d-a896-4adb-9718-dd85de31b4b7",
      "name": "Combine Orders & Refunds",
      "type": "n8n-nodes-base.merge",
      "position": [
        1680,
        384
      ]
    },
    {
      "id": "5672e8f5-04d6-4783-b20d-bec7fce37b1a",
      "name": "Calculate Finance KPIs",
      "type": "n8n-nodes-base.code",
      "position": [
        1872,
        384
      ]
    },
    {
      "id": "e616ddbe-2de2-4e70-9e82-dbab66b71619",
      "name": "Send Weekly KPI Digest to Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        2080,
        384
      ]
    },
    {
      "id": "f70ac891-a5b2-42af-b4b3-754ee12e4ccd",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        176,
        256
      ],
      "parameters": {
        "width": 464,
        "height": 368,
        "content": "## Schedule & Store Setup\nThis section controls when the workflow runs and which WooCommerce store it connects to. The scheduler triggers the automation on a weekly basis, while the store configuratio"
      }
    },
    {
      "id": "d6fac5fa-9707-4c4d-8619-91c6a058e896",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        768,
        48
      ],
      "parameters": {
        "width": 704,
        "height": 336,
        "content": "## Order Data Collection & Preparation\nThis section fetches order data from WooCommerce and prepares it for financial analysis. Only completed or paid orders are considered as valid sales. The data is"
      }
    },
    {
      "id": "6d398e77-8a73-4a25-bc98-38d798b93862",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        768,
        432
      ],
      "parameters": {
        "width": 704,
        "height": 304,
        "content": "## Refund Data Collection & Preparation\nThis section retrieves refund information from WooCommerce and formats it for analysis. Refund records are cleaned and standardized so refund amounts and counts"
      }
    },
    {
      "id": "42c83350-9e59-43f2-bf4f-cca80528858a",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1568,
        240
      ],
      "parameters": {
        "width": 784,
        "height": 352,
        "content": "## KPI Calculation & Executive Reporting\nThis final section combines sales and refund data to calculate key financial KPIs such as refund ratios and risk indicators. A concise, CFO-ready summary is th"
      }
    },
    {
      "id": "9e901f1a-488d-45d8-b742-024f69476e86",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -416,
        -544
      ],
      "parameters": {
        "width": 480,
        "height": 1008,
        "content": "## How It Works\nThe workflow runs automatically on a weekly schedule using a Cron trigger.\n\nIt connects to your WooCommerce store and fetches all completed orders within the selected time period.\n\nOrd"
      }
    }
  ],
  "connections": {
    "Normalize Order Data": {
      "main": [
        [
          {
            "node": "Combine Orders & Refunds",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Weekly KPI Scheduler": {
      "main": [
        [
          {
            "node": "Configure WooCommerce Store",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Refund Data": {
      "main": [
        [
          {
            "node": "Combine Orders & Refunds",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Calculate Finance KPIs": {
      "main": [
        [
          {
            "node": "Send Weekly KPI Digest to Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Completed Orders": {
      "main": [
        [
          {
            "node": "Normalize Order Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine Orders & Refunds": {
      "main": [
        [
          {
            "node": "Calculate Finance KPIs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch WooCommerce Orders": {
      "main": [
        [
          {
            "node": "Filter Completed Orders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch WooCommerce Refunds": {
      "main": [
        [
          {
            "node": "Normalize Refund Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Configure WooCommerce Store": {
      "main": [
        [
          {
            "node": "Fetch WooCommerce Orders",
            "type": "main",
            "index": 0
          },
          {
            "node": "Fetch WooCommerce Refunds",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}