{
  "name": "Send a daily WooCommerce sales snapshot to Slack with Google Sheets logging",
  "nodes": [
    {
      "id": "76bb2c69-3f36-4bb3-bea1-b259c6995488",
      "name": "Daily Schedule",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        32,
        352
      ]
    },
    {
      "id": "d97ab0ad-59bd-40c7-9c00-ad4cd7d90cab",
      "name": "Fetch WooCommerce Orders",
      "type": "n8n-nodes-base.wooCommerce",
      "position": [
        368,
        224
      ]
    },
    {
      "id": "6f674f94-af6f-44b5-88b1-cd7a86716cf0",
      "name": "Filter Paid Orders",
      "type": "n8n-nodes-base.filter",
      "position": [
        544,
        224
      ]
    },
    {
      "id": "3cdf966f-4f5e-42e9-a2b5-c57bbbcedb8c",
      "name": "Last 24h Orders",
      "type": "n8n-nodes-base.code",
      "position": [
        720,
        224
      ]
    },
    {
      "id": "f4274439-a7f5-4301-b61f-cc46cbad7cfa",
      "name": "Calculate Revenue + AOV",
      "type": "n8n-nodes-base.code",
      "position": [
        1056,
        368
      ]
    },
    {
      "id": "a7f0c8e1-380a-4bf2-9e02-a1e5d4ceec9e",
      "name": "Calculate Top Products",
      "type": "n8n-nodes-base.code",
      "position": [
        1056,
        80
      ]
    },
    {
      "id": "daf871ef-d441-4de3-971a-1a111c8092ca",
      "name": "Merge Metrics",
      "type": "n8n-nodes-base.merge",
      "position": [
        1264,
        224
      ]
    },
    {
      "id": "36d98d38-5e6b-45eb-81cb-2821db5a950a",
      "name": "Finalize Data",
      "type": "n8n-nodes-base.code",
      "position": [
        1536,
        240
      ]
    },
    {
      "id": "765c05d9-2998-4942-9e78-d9066129cee9",
      "name": "Send Slack Summary",
      "type": "n8n-nodes-base.slack",
      "position": [
        1776,
        336
      ]
    },
    {
      "id": "a7f2d14e-842b-45e5-8cda-dc539d260ecc",
      "name": "Append or update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1760,
        112
      ]
    },
    {
      "id": "55e17d5d-f6be-438c-954b-9da5be78f927",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -32,
        48
      ],
      "parameters": {
        "width": 304,
        "height": 480,
        "content": "## Daily Workflow Trigger\n\nStarts the workflow automatically each day using a Schedule Trigger.\nIt ensures daily sales data is collected, processed and reported\nconsistently without any manual interve"
      }
    },
    {
      "id": "eb621894-23ea-479a-b891-5bf0ea41c154",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        48
      ],
      "parameters": {
        "width": 544,
        "height": 480,
        "content": "## Fetch & Filter Orders\nThis section fetches orders from WooCommerce, keeps only paid orders and filters them to include orders from the last 24 hours. This helps ensure that only valid and recent sa"
      }
    },
    {
      "id": "a80064d1-b88c-44aa-92fd-653631eacda7",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        928,
        -160
      ],
      "parameters": {
        "width": 528,
        "height": 720,
        "content": "## Sales Metrics Calculation & Merge\n\nHere the workflow calculates key metrics using separate Code nodes:\n• Total Revenue\n• Order Count\n• Average Order Value (AOV)\n• Top Selling Products\n\nAll results "
      }
    },
    {
      "id": "d3f2b0de-7c53-45cd-917d-8ec9902a9ac9",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1536,
        -208
      ],
      "parameters": {
        "width": 528,
        "height": 768,
        "content": "## Sales Summary & Logging\n\nThis section sends a clean, human-readable sales summary to Slack\nand records the same data in Google Sheets.\n\nIncludes:\n• Total revenue\n• Number of orders\n• Average order "
      }
    },
    {
      "id": "9f7a66c5-67a8-4823-a9f1-a1faebfb4b80",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -688,
        -288
      ],
      "parameters": {
        "width": 560,
        "height": 1040,
        "content": "## How This Workflow Works\n\n1. The workflow runs automatically once every day using a Schedule Trigger (Cron).\n\n2. It fetches recent orders from WooCommerce as the source sales data.\n\n3. Only paid ord"
      }
    }
  ],
  "connections": {
    "Finalize Data": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send Slack Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Metrics": {
      "main": [
        [
          {
            "node": "Finalize Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Schedule": {
      "main": [
        [
          {
            "node": "Fetch WooCommerce Orders",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge Metrics",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Last 24h Orders": {
      "main": [
        [
          {
            "node": "Calculate Revenue + AOV",
            "type": "main",
            "index": 0
          },
          {
            "node": "Calculate Top Products",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Paid Orders": {
      "main": [
        [
          {
            "node": "Last 24h Orders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Top Products": {
      "main": [
        [
          {
            "node": "Merge Metrics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Revenue + AOV": {
      "main": [
        [
          {
            "node": "Merge Metrics",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Fetch WooCommerce Orders": {
      "main": [
        [
          {
            "node": "Filter Paid Orders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append or update row in sheet": {
      "main": [
        []
      ]
    }
  }
}