Have a list of shortened urls and need their final destination? Use this custom function in google sheets to extract them all at once.
Handy little snippet that can make testing redirects on URLs a lot easier, which can be useful for expanding short links from social media sites like Twitter.
Source: get the redirect location of a url using google apps script
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.