Dividend Data Google Sheets Integration

I maintain a Google Sheet with a watch-list of tickers and I need fresh dividend metrics pulled in from dividendhistory.org. IMPORTXML() fails on that domain, so I’m after a purpose-built solution that will:

• Read my ticker list, visit the page or table link I will supply for each one, and capture four specific fields: Price Change %, Total Return (with dividends reinvested), Dividend Amount, and Current Yield.
• Write each value into the sheet’s pre-assigned columns, overwriting the old data while leaving my layout intact.
• Offer a simple in-sheet trigger—either a custom menu item or a button—so I can refresh on demand.
• If a field is missing, leave the previous value in place and flag the cell (or a notes column) with a clear warning so I know something changed on the source page.

Method
I’m open to a pure Google Apps Script or a lightweight Python micro-service connected through the Google Sheets API; feel free to recommend whichever you believe will be more reliable given dividendhistory.org’s structure.

Deliverables
1. Fully commented code installed in my Sheet and ready to run.
2. Quick setup guide so I can add new tickers or move the script to another document.
3. Brief hand-off call or Loom video to demonstrate the refresh workflow and error-handling logic.

Let me know which approach you’d take and the timeframe you’d need to turn this around. I’m looking forward to getting this automated.