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: https://keywordsinsheets.com/status-codes/

</aside>

How to use the formula

=redirects(url)

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

Eg. =redirects(”<https://www.amazon.co.uk>”)

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.

</aside>