Divident Yield in Google Sheets

Hi,

I've tried a couple code snippets to get the div % into google sheets and nothing seems to be working. I'm not trying to pay for a subscription for an API, was wondering if anyone had some working code snippets that can pull the div yield. Doesn't have to be real time, just has to update when I reload the sheet.

Thanks so much.