Templates / Fetch live ETF metrics from JustETF to Excel with one-click updates

Fetch live ETF metrics from JustETF to Excel with one-click updates

Ready for 3.0

by Louis ✓ · 3,161 views · created 2024-11-01 · Crypto Trading

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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).

  1. Logs the date & time (Microsoft Excel 365): work with table
  2. Gets rows from table (Microsoft Excel 365): get rows (table)
  3. Forge a Get request with ISIN Values (HTTP Request): calls an HTTP API
  4. Extracts defined values with css selector (HTML): parses or builds HTML
  5. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  6. Edit Fields (Edit Fields (Set)): sets 9 fields: Frais, Rendement de départ, Performance depuis 5 ans…
  7. Extracts defined values in better format (Code): runs custom JavaScript code
  8. Updates my table (Microsoft Excel 365): update (worksheet)

Services it uses

Microsoft Excel 365

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)

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…

Excerpt from Louis's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.