FM
FlowMarket
General Automation Intermediate ⚡ 14 n8n Nodes

Fetch live ETF metrics from JustETF to Excel with one click upda

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 usi...

🔌 Nodes & Integrations Used (3)

Microsoft Excel HTTP Request Html

📖 Implementation & Setup Guide

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`

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Fetch_live_ETF_metrics_from_JustETF_to_Excel_with_one_click_upda.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related General Automation Workflows

View All in General Automation →