{
  "name": "Read XML file and store content in Google Sheets",
  "nodes": [
    {
      "id": "d0c92688-14fc-4393-a1d6-926eb867b81e",
      "name": "On clicking 'execute'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        180,
        240
      ]
    },
    {
      "id": "0edbad78-249b-441c-877d-bac57fb44a91",
      "name": "Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        31
      ],
      "parameters": {
        "width": 436,
        "height": 169,
        "content": "## n8n version\n\nThis workflow was created using n8n version 0.197.1 and uses a new [expression syntax](https://docs.n8n.io/code-examples/methods-variables-reference/) as well as a new version of the M"
      }
    },
    {
      "id": "251d893c-11cb-4702-a289-44f198581722",
      "name": "Download XML File",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        400,
        240
      ]
    },
    {
      "id": "0973b302-1ba9-4faf-9d6c-2caca1b301f5",
      "name": "Parse XML content",
      "type": "n8n-nodes-base.xml",
      "position": [
        620,
        240
      ]
    },
    {
      "id": "01854111-27cb-40c1-b95e-14f91f89e9f1",
      "name": "Create new spreadsheet file",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1060,
        140
      ]
    },
    {
      "id": "affbcb81-5873-406e-a51d-cd6fee682992",
      "name": "Define header row",
      "type": "n8n-nodes-base.set",
      "position": [
        1280,
        140
      ]
    },
    {
      "id": "537aff03-ae08-4712-bfae-15f0e3a5e69a",
      "name": "Split out food items",
      "type": "n8n-nodes-base.itemLists",
      "position": [
        840,
        240
      ]
    },
    {
      "id": "b247f984-6ed2-4de0-8877-a61571863ff8",
      "name": "Write header row",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1500,
        140
      ]
    },
    {
      "id": "fc9e2c32-30b1-4162-a686-2d049e52e111",
      "name": "Wait for spreadsheet creation",
      "type": "n8n-nodes-base.merge",
      "position": [
        1720,
        240
      ]
    },
    {
      "id": "fdc6d5d9-e08d-4086-a233-0edb3c11bc86",
      "name": "Write data to sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1940,
        240
      ]
    }
  ],
  "connections": {
    "Write header row": {
      "main": [
        [
          {
            "node": "Wait for spreadsheet creation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Define header row": {
      "main": [
        [
          {
            "node": "Write header row",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download XML File": {
      "main": [
        [
          {
            "node": "Parse XML content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse XML content": {
      "main": [
        [
          {
            "node": "Split out food items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split out food items": {
      "main": [
        [
          {
            "node": "Create new spreadsheet file",
            "type": "main",
            "index": 0
          },
          {
            "node": "Wait for spreadsheet creation",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "On clicking 'execute'": {
      "main": [
        [
          {
            "node": "Download XML File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create new spreadsheet file": {
      "main": [
        [
          {
            "node": "Define header row",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait for spreadsheet creation": {
      "main": [
        [
          {
            "node": "Write data to sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}