Google App Scripts Redirect Chains

Hi, I need someone to help me with Google Sheet App Scripts. I need a method of detecting whether a redirect of a URL in a daisy chain of many redirects is a 404/301/200/500 status (just like httpstatus.io/ does) e.g. a 301, then 200 e.t.c.

The code exist for single redirect chains e.g. https://banhawy.medium.com/how-to-use-google-spreadsheets-to-check-for-broken-links-1bb0b35c8525

It would also be interesting to see if there's a quick way to scan a URL for any unsecure links ("http://") contained in the code, and way to count the number of H1, H2 and H3 tags. Thanks, Matt