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

⚡ 1,746 views · 📈 Crypto Trading & Stock Market

💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.

View All Scrapers

Description

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 updates your “Div study” sheet instantly — all triggered by a button in Excel.

Perfect for dividend investors, ETF screeners, or portfolio trackers who want fresh, accurate data without manual copy-paste.

How it works

  1. Trigger: Click “Update Table” in Excel → calls n8n via webhook
  2. Excel: Logs current time (GMT-2) and reads all rows from “DivComp” table
  3. HTTP Request: Fetches ETF profile page from justetf.com using ISIN
  4. HTML Extraction: Parses page with CSS selectors to grab dividends, fees, 5Y performance
  5. Code Node: Cleans & structures data (e.g., last 5 years of dividends, yield, growth)
  6. Update Excel: Writes clean values back to your table (fees, yield, performance, name)

Setup steps

  1. In Excel:

    • Add a button → assign macro that calls your n8n webhook URL (path: /ETF)
    • Ensure table “DivComp” has: ISIN, Dernière mise à jour, Frais, Performance depuis 5 ans, etc.

  2. In n8n:

    • Connect Microsoft Excel (OneDrive) credential
    • Update workbook/worksheet/table references if needed
    • Test with 1–2 ISINs first

  3. Click “Update Table” → watch data refresh in real time!

Tags: ETF, Excel, Web Scraping, Investing, Finance, Automation, justetf, Dividend Tracking

🔗 Nodes Used

HTTP Request, Webhook, Microsoft Excel 365

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup