Get the redirected URL. This function gets the first redirected URL in a chain.

<aside> 🆓 This is a free function. The AppScript code and original tutorial is available here:


How to use the formula

=redirects(url) (9).gif

To return a redirected URL, you need to input a URL into the function.

Eg. =redirects(”<>”)

The redirect function only works on a cell-by-cell basis, you can’t input multiple URLs.

<aside> 💡 Quick tip: if you are using the redirects function across 100s/1000s URLs and they’re stuck in loading, refreshing the spreadsheet can often make them appear.