{
  "name": "Sync Shopify and WooCommerce sales into a Google Sheets accounting ledger",
  "nodes": [
    {
      "id": "0625b8c1-aa39-44df-959f-4e652e70b392",
      "name": "Shopify Order Events",
      "type": "n8n-nodes-base.shopifyTrigger",
      "position": [
        176,
        144
      ]
    },
    {
      "id": "432ce392-47d6-4a21-bc58-77b19242b3ea",
      "name": "WooCommerce Order Events",
      "type": "n8n-nodes-base.wooCommerceTrigger",
      "position": [
        176,
        320
      ]
    },
    {
      "id": "4dc27308-6725-44ae-8e4d-26a750a48ad5",
      "name": "Merge Platform Data",
      "type": "n8n-nodes-base.merge",
      "position": [
        992,
        240
      ]
    },
    {
      "id": "2c82cdfb-f175-45c1-a3b3-e9bb3dcd79c6",
      "name": "Format Transaction Data",
      "type": "n8n-nodes-base.set",
      "position": [
        1216,
        240
      ]
    },
    {
      "id": "43368cd4-2fd7-4033-9d4b-20c43d9a2143",
      "name": "Format Sale Entry",
      "type": "n8n-nodes-base.set",
      "position": [
        2016,
        176
      ]
    },
    {
      "id": "ed1edb0c-6b5e-43b7-a41f-960db674a722",
      "name": "Format Refund Entry",
      "type": "n8n-nodes-base.set",
      "position": [
        2016,
        320
      ]
    },
    {
      "id": "fb63da36-e07b-4e9f-a089-38de69e29432",
      "name": "Log to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2464,
        256
      ]
    },
    {
      "id": "c9c81ef1-c594-47e7-b1ae-eaef11f5c19f",
      "name": "Check Transaction Type",
      "type": "n8n-nodes-base.if",
      "position": [
        1424,
        240
      ]
    },
    {
      "id": "3719b8e9-1394-470b-95ee-38800e5a9865",
      "name": "Shopify Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        432,
        144
      ]
    },
    {
      "id": "a0bb07c1-d143-4651-9e72-5f56c07a9d19",
      "name": "WooCommerce Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        432,
        320
      ]
    },
    {
      "id": "d43057a0-4775-46db-ad17-5559cac3c269",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        -448
      ],
      "parameters": {
        "width": 544,
        "height": 992,
        "content": "# How It Works\nThis workflow serves as an automated Retail Transaction Sync system, capturing sales and refund data from multiple e-commerce platforms to maintain a centralized financial ledger. It is"
      }
    },
    {
      "id": "f5ad9d00-e81f-4423-a451-d9d56941a9c5",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -96
      ],
      "parameters": {
        "width": 816,
        "height": 640,
        "content": "## Webhook Trigger and Set Configuration\nThe Shopify and WooCommerce Order Events nodes serve as the workflow's entry points, listening for orders/create and order.created webhooks to capture transact"
      }
    },
    {
      "id": "129e1e95-dcde-408e-b75e-3a3490cd728e",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        -96
      ],
      "parameters": {
        "width": 816,
        "height": 640,
        "content": "## Merge, Format & Route Transaction Data \nThe Merge Platform Data node consolidates incoming streams from different e-commerce sources into a single workflow path. The subsequent Format Transaction D"
      }
    },
    {
      "id": "ecb03981-ba4e-4a7b-93e4-b0180ec55840",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1776,
        -96
      ],
      "parameters": {
        "width": 1088,
        "height": 640,
        "content": "## Transaction Formatting & Accounting Sync \nThe Format Sale and Format Refund Entry nodes prepare the normalized data for accounting by structuring it into financial records. They calculate absolute "
      }
    }
  ],
  "connections": {
    "Format Sale Entry": {
      "main": [
        [
          {
            "node": "Log to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Refund Entry": {
      "main": [
        [
          {
            "node": "Log to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Platform Data": {
      "main": [
        [
          {
            "node": "Format Transaction Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Shopify Order Events": {
      "main": [
        [
          {
            "node": "Shopify Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Shopify Configuration": {
      "main": [
        [
          {
            "node": "Merge Platform Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Transaction Type": {
      "main": [
        [
          {
            "node": "Format Sale Entry",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Format Refund Entry",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Transaction Data": {
      "main": [
        [
          {
            "node": "Check Transaction Type",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "WooCommerce Order Events": {
      "main": [
        [
          {
            "node": "WooCommerce Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "WooCommerce Configuration": {
      "main": [
        [
          {
            "node": "Merge Platform Data",
            "type": "main",
            "index": 1
          }
        ]
      ]
    }
  }
}