{
  "name": "Sync Shopify customers to Google Sheets + Squarespace compatible csv",
  "nodes": [
    {
      "id": "ff5634c3-349b-4181-a03a-97b310e5232b",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        120,
        60
      ]
    },
    {
      "id": "66e204fb-3e00-45e0-b1b2-341836476b95",
      "name": "Extract page_info ",
      "type": "n8n-nodes-base.code",
      "position": [
        900,
        120
      ]
    },
    {
      "id": "5b0086ce-f09b-4d55-86b6-9a14574506ab",
      "name": "Merge Loop items",
      "type": "n8n-nodes-base.code",
      "position": [
        1120,
        -100
      ]
    },
    {
      "id": "2302257c-51c0-42d7-8745-ecc0b4fc9faf",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        440,
        -160
      ],
      "parameters": {
        "width": 232,
        "height": 346,
        "content": "## Edit this node 👇\n\nGet your store URL and replace in the GET url: https://{your-store}.myshopify.com/admin/api/2025-01/customers.json\n"
      }
    },
    {
      "id": "d857962a-6599-44b2-acb0-3eb8165e93ce",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1560,
        -440
      ],
      "parameters": {
        "width": 272,
        "height": 506,
        "content": "## Clone this spreadsheet\n\nhttps://docs.google.com/spreadsheets/d/1E8i98hwiFW7XG9HuxIZrOWfuLxGFaDm3EOAGQBZjhfk/edit?usp=sharing\n\nYour spreadsheet can have up to three columns, and need to be arranged "
      }
    },
    {
      "id": "be7cf143-893a-44f8-ace9-8ad581bddb68",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        120,
        -120
      ]
    },
    {
      "id": "58097363-29ec-4067-a439-717d355df91f",
      "name": "Assign page_info parameter",
      "type": "n8n-nodes-base.set",
      "position": [
        1120,
        120
      ]
    },
    {
      "id": "0676abce-4405-42a1-87d3-ba75355fe264",
      "name": "Check page_info existence",
      "type": "n8n-nodes-base.if",
      "position": [
        720,
        0
      ]
    },
    {
      "id": "1cc63979-b2f8-4678-b40b-f3f0ad63d377",
      "name": "Get Customers",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        500,
        0
      ]
    },
    {
      "id": "ce91af42-1634-4773-944a-2b24dcaf812b",
      "name": "List Customers",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1380,
        -100
      ]
    },
    {
      "id": "19a0f6a7-b86a-43bd-8504-62e3bd37af89",
      "name": "Customers Spreadsheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1620,
        -100
      ]
    },
    {
      "id": "48ec5e3b-9bb5-451c-9495-b03080c9211e",
      "name": "Convert to Squarespace contacts csv",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        1920,
        160
      ]
    },
    {
      "id": "8de9174a-af87-4602-a9aa-a5c35a3f0ed4",
      "name": "Extract customers data",
      "type": "n8n-nodes-base.set",
      "position": [
        1620,
        160
      ]
    }
  ],
  "connections": {
    "Get Customers": {
      "main": [
        [
          {
            "node": "Check page_info existence",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "List Customers": {
      "main": [
        [
          {
            "node": "Customers Spreadsheet",
            "type": "main",
            "index": 0
          },
          {
            "node": "Extract customers data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Loop items": {
      "main": [
        [
          {
            "node": "List Customers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Customers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract page_info ": {
      "main": [
        [
          {
            "node": "Assign page_info parameter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Customers Spreadsheet": {
      "main": [
        []
      ]
    },
    "Extract customers data": {
      "main": [
        [
          {
            "node": "Convert to Squarespace contacts csv",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check page_info existence": {
      "main": [
        [
          {
            "node": "Merge Loop items",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Extract page_info ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Assign page_info parameter": {
      "main": [
        [
          {
            "node": "Get Customers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Get Customers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to Squarespace contacts csv": {
      "main": [
        []
      ]
    }
  }
}