How do I automatically update a URL in Google Sheets? or What's the easiest way to update a URL in Go

Apps Script is your best bet for a true google sheet update a url solution.

You’ll need to write a function to ping the source URLs and check for redirects/changes.

Steep learning curve, but super flexible once you get it.