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)
📖 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:
- Click the Direct Download JSON button above to save
Fetch_live_ETF_metrics_from_JustETF_to_Excel_with_one_click_upda.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related General Automation Workflows
View All in General Automation →Generate Application Copy
Production-ready n8n automation template for Generate Application Copy built by AhiXLight. Seamlessly connects Execute Workflow Trigger, OpenAI with 4 configured nodes.
2-way sync Google Contacts and Notion
Sync your Google Contacts with your Notion database. You can filter contacts by label or sync all contacts. All contact information is kept in sync between G...
2D Image to 3D Model Automation
Production-ready n8n automation template for 2D Image to 3D Model Automation built by AhiXLight. Seamlessly connects HTTP Request, Google Sheets, Google Drive with 17 configured nodes.
2 way sync assignments completion between Canvas LMS and Notion
Syncs assignments and completion states to and fro between Canvas LMS and a Notion database. Automatically triggers every 2 hours during the schoolday by def...