I had a tough time looking for an answer that didn't require a lot of work but this was my solution if anyone else is looking for help.
Using [https://stockanalysis.com](https://stockanalysis.com) as the import
Get ticker name. Is it a stock or ETF?
=IMPORTXML(CONCATENATE("https://stockanalysis.com/",**StockOrETFCell**,"/",**TickerNameCell**,"/dividend/"), "/html/body/div/div\[1\]/div\[2\]/main/div\[2\]/div/div\[2\]/div\[2\]/div")