Fetch Live ETF Metrics from JustETF to Excel with One-Click Updates
VerifiedPulls live ETF metrics from JustETF into Excel via one-click updates.
What is the Fetch Live ETF Metrics from JustETF to Excel with One-Click Updates workflow?
The automation reads ISIN values from an Excel table, retrieves corresponding ETF profiles over HTTP, extracts key metrics with HTML parsing, and refreshes the target sheet with fresh values.
It is intended for dividend investors, ETF screeners, and portfolio trackers who need current justetf.com data inside Microsoft Excel 365 without manual copying.
What it automates
Personal ETF portfolio tracking
An individual investor keeps ISIN codes in the DivComp table and clicks Update Table in Excel to pull fresh dividends, fees, and performance numbers into the Div study sheet without manual copy-paste.
Quarterly dividend research
A retail investor maintains a watchlist of dividend ETFs and refreshes live metrics from justetf.com on demand to compare yields and costs before rebalancing.
Advisor client reporting
A financial advisor stores client ETF holdings in Excel and uses the one-click webhook to fetch updated performance data for quick report generation.
Apps & integrations used
How to set up Fetch Live ETF Metrics from JustETF to Excel with One-Click Updates
- 1Open the template in n8n
- 2Connect your Microsoft Excel 365 credentials
- 3Configure the webhook trigger called from the Excel button
- 4Add ISIN codes to the DivComp table in Excel
- 5Map HTTP Request nodes to justetf.com ETF pages
- 6Test HTML extraction and write results to the Div study sheet
Fetch Live ETF Metrics from JustETF to Excel with One-Click Updates: pros & cons
Pros
- +One-click refresh from inside Excel
- +Pulls live dividends, fees and performance via HTTP
- +Uses only native n8n nodes (HTTP, Excel 365, HTML)
- +Keeps data in a familiar spreadsheet environment
Cons
- –Requires n8n instance and Excel 365 account
- –Depends on justetf.com page structure remaining stable
- –Initial setup needed for webhook and table mapping
Frequently asked questions
It lets you click a button in Excel to fetch current ETF metrics from justetf.com and write them into a study sheet using n8n.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…