Fetch live ETF metrics from JustETF to Excel with one-click updates
Ready for 3.0What this workflow does
This workflow has 10 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Microsoft Excel 365.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Logs the date & time (Microsoft Excel 365): work with table
- Gets rows from table (Microsoft Excel 365): get rows (table)
- Forge a Get request with ISIN Values (HTTP Request): calls an HTTP API
- Extracts defined values with css selector (HTML): parses or builds HTML
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Edit Fields (Edit Fields (Set)): sets 9 fields: Frais, Rendement de départ, Performance depuis 5 ans…
- Extracts defined values in better format (Code): runs custom JavaScript code
- Updates my table (Microsoft Excel 365): update (worksheet)
Services it uses
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - HTTP Request
n8n-nodes-base.httpRequest - HTML
n8n-nodes-base.html - Code
n8n-nodes-base.code - Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
Automate Your ETF Comparison: Real-Time Data & Analysis Automate ETF research in Excel with one click. This n8n workflow pulls live data from justetf.com using ISIN codes from your Excel table, extracts key metrics (dividends, fees, 5-year performance), and…