{
  "name": "Fetch live ETF metrics from JustETF to Excel with one-click updates",
  "nodes": [
    {
      "id": "049e7023-75e0-4876-922f-66bfa05fb5ff",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1616,
        368
      ]
    },
    {
      "id": "f1e2c483-0df8-434a-bad2-2729015f5f6c",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -288,
        16
      ],
      "parameters": {
        "width": 678,
        "height": 584,
        "content": "# 📊 Automate Your ETF Comparison: Real-Time Data & Analysis 📈\n\nThis workflow automates ETF research by pulling fresh profile data into Excel whenever you click “Update Table.” It fetches rows from you"
      }
    },
    {
      "id": "316c8627-3a85-44cb-8d5c-6d43c5c9a758",
      "name": "Logs the date & time",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        656,
        368
      ]
    },
    {
      "id": "2315871a-c18a-4613-888a-8bc1d4f42d6e",
      "name": "Gets rows from table",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        864,
        368
      ]
    },
    {
      "id": "31537a0b-6337-43ca-904b-17cf0a493ac7",
      "name": "Forge a Get request with ISIN Values",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1040,
        368
      ]
    },
    {
      "id": "5e4cfc3a-a97b-4e0d-951d-583b8e9989f5",
      "name": "Extracts defined values with css selector",
      "type": "n8n-nodes-base.html",
      "position": [
        1456,
        368
      ]
    },
    {
      "id": "bd550ef8-3972-42e2-9b0c-e830c2d0ddad",
      "name": "Extracts defined values in better format",
      "type": "n8n-nodes-base.code",
      "position": [
        1872,
        464
      ]
    },
    {
      "id": "3ba51c71-d731-4437-9de6-9360f8a522dd",
      "name": "Updates my table",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        2016,
        240
      ]
    },
    {
      "id": "4178bc4c-2857-41c4-bf82-abd0c63bca0e",
      "name": "When called by Excel Macro",
      "type": "n8n-nodes-base.webhook",
      "position": [
        464,
        464
      ]
    },
    {
      "id": "d04f100f-c2b9-4ef8-9764-f23f6a371f92",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        1824,
        240
      ]
    },
    {
      "id": "6d583f3c-29d7-4319-a55a-799d078be58f",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        448,
        288
      ]
    },
    {
      "id": "8598a279-94b6-4b9d-a2d4-9996ebbb391a",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        144
      ],
      "parameters": {
        "width": 230,
        "height": 456,
        "content": "### Trigger \n- Trigger manually \nor \n- Trigger using a web hook (called with a macro in excel for my part)"
      }
    },
    {
      "id": "d42707bf-2a97-4d60-a765-77089dd25abd",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        144
      ],
      "parameters": {
        "width": 758,
        "height": 456,
        "content": "### Excel data\n- start by logging the date and time of execution\n- Retrieve the rows of the table with the ETF ISIN\n- Forge a GET request to have data from https://justetf.com\n"
      }
    },
    {
      "id": "e102eba7-4207-42c5-8739-2f215cd41737",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1408,
        144
      ],
      "parameters": {
        "width": 742,
        "height": 456,
        "content": "### Html content extraction\n- Extract html content into human readable text from the css selectors on just etf website\n- append or update data to your table"
      }
    }
  ],
  "connections": {
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Updates my table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Extracts defined values in better format",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gets rows from table": {
      "main": [
        [
          {
            "node": "Forge a Get request with ISIN Values",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Logs the date & time": {
      "main": [
        [
          {
            "node": "Gets rows from table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When called by Excel Macro": {
      "main": [
        [
          {
            "node": "Logs the date & time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Logs the date & time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Forge a Get request with ISIN Values": {
      "main": [
        [
          {
            "node": "Extracts defined values with css selector",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extracts defined values in better format": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extracts defined values with css selector": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}