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 wor

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
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.