{
  "name": "Log e-commerce orders in Google Sheets with monthly tabs & status tracking",
  "nodes": [
    {
      "id": "eb4915cc-2cbc-43cb-a1ee-0714066b19a7",
      "name": "Config (set spreadsheetId)",
      "type": "n8n-nodes-base.set",
      "position": [
        -208,
        160
      ]
    },
    {
      "id": "56cfe15b-f599-4998-99e4-575c16511885",
      "name": "Create Month Sheet",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        912,
        256
      ]
    },
    {
      "id": "f866f538-850a-403f-8b94-dc46b6e4b27f",
      "name": "Write Headers (A1:I1)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1136,
        256
      ]
    },
    {
      "id": "ad5a0bd0-81d8-46e8-8e2a-3e2cce0a8be1",
      "name": "Order created",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -432,
        160
      ]
    },
    {
      "id": "4e47467b-2dcf-4837-bb83-557ceae7e58f",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        464,
        160
      ]
    },
    {
      "id": "7289baf5-cd38-48b2-923e-b98b48f95468",
      "name": "Google Sheets Row values",
      "type": "n8n-nodes-base.set",
      "position": [
        1360,
        256
      ]
    },
    {
      "id": "6f268d17-bfe3-4ac6-a18a-ecff9d258733",
      "name": "Generate Sheet Name",
      "type": "n8n-nodes-base.set",
      "position": [
        240,
        160
      ]
    },
    {
      "id": "8e2059e0-3412-4fba-a629-b627d90814f2",
      "name": "Google Sheets Row values existing",
      "type": "n8n-nodes-base.set",
      "position": [
        688,
        64
      ]
    },
    {
      "id": "d068bf77-aecd-4a12-a969-b880d9912b7d",
      "name": "Set Sheet Starting row col",
      "type": "n8n-nodes-base.set",
      "position": [
        688,
        256
      ]
    },
    {
      "id": "cdbf4821-1a28-410b-8811-3cf94aec8acc",
      "name": "Get Order Sheets metadata",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        16,
        160
      ]
    },
    {
      "id": "4dcf159b-4292-462d-9df9-2c7b27a2beae",
      "name": "Append to Existing Orders Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        912,
        64
      ]
    },
    {
      "id": "5a05849a-d37c-4411-8146-6213bdd78210",
      "name": "Append to Orders Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1584,
        256
      ]
    },
    {
      "id": "aaca5f17-a1cf-449d-b322-7af562087bd1",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -960,
        64
      ],
      "parameters": {
        "width": 460,
        "height": 328,
        "content": "## Input\n- Shopify → Webhook URL (add in Settings → Notifications → Webhooks)\n- Events: Order creation, update, fulfillment\n\n![](https://ik.imagekit.io/tscnqj8zf/shopify_ordersample.png?updatedAt=1756"
      }
    },
    {
      "id": "80d21450-be10-426a-a5e9-12a93473cec8",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -304,
        0
      ],
      "parameters": {
        "width": 272,
        "height": 144,
        "content": "### Update your google spreedsheet Id\nGoogle Sheet → spreadsheetId (docs.google.com/spreadsheets/d/<id>/)"
      }
    },
    {
      "id": "b9fe7e61-3f90-404c-9a07-661bdbb83f9a",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        336
      ],
      "parameters": {
        "width": 352,
        "height": 240,
        "content": "### Fetch the existing sheet details\n\n![](https://ik.imagekit.io/tscnqj8zf/Excel%20sheet.png?updatedAt=1756974906066)"
      }
    },
    {
      "id": "4f0222b4-b959-458c-ae58-82e204eb451e",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1808,
        0
      ],
      "parameters": {
        "width": 672,
        "height": 560,
        "content": "## Output \n- Auto-create monthly sub-sheet (name = current month)\n- Append order rows into month tab\n- Status column with options:\nNot Shipped, Pickup Scheduled, Shipped, InTransit, Delivered, Cancell"
      }
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Google Sheets Row values existing",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Set Sheet Starting row col",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Order created": {
      "main": [
        [
          {
            "node": "Config (set spreadsheetId)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Month Sheet": {
      "main": [
        [
          {
            "node": "Write Headers (A1:I1)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Sheet Name": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Write Headers (A1:I1)": {
      "main": [
        [
          {
            "node": "Google Sheets Row values",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Row values": {
      "main": [
        [
          {
            "node": "Append to Orders Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Order Sheets metadata": {
      "main": [
        [
          {
            "node": "Generate Sheet Name",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Config (set spreadsheetId)": {
      "main": [
        [
          {
            "node": "Get Order Sheets metadata",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Sheet Starting row col": {
      "main": [
        [
          {
            "node": "Create Month Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Row values existing": {
      "main": [
        [
          {
            "node": "Append to Existing Orders Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}