I love pulling data to Google sheets. But getting the status code from url's within sheets can be a pain. Fortunately you can use a script to pull status codes straight to Google sheets. All with just a few clicks of a button.

‍

Daniel Foley Carter was kind enough to allow me to share this script he created. For more amazing tips, all things SEO knowledge. Check out Daniel's website and Linkedin.

‍

Linkedin: https://www.linkedin.com/in/daniel-foley-assertive/

Website: https://seo-audits.io/

‍

Lets get right to it. To use this script we will need to set up a few things.

Written instructions

‍

Step 1: Make a copy of the template

Step 2: enter https status code formula in the cell to the right of the url. (=https)

Step 3: Step 4: drag the script down to pull all url’s

Here is a video for easy viewing:

‍

That's it, you're done! Happy saving time when pulling status codes in google sheets.

‍

‍

Note: I am in no way being compensated for this article

‍