HttpStatuscode for Gsheets SEO

With the deployment of this personalized script you can use the formula httpstatuscode(), to get the status code of the urls stored in a Google Sheet, so SEO tasks become easier :)

1- Open Google Sheets

2- In the toolbar, click on Extensions, Apps Script. copy thew script contained in script.js

3- Click on "Deploy" button and select "New Deployment".

4-Select a deployment type by clicking the cog icon and selecting "Library". Give it a name and click on "Deploy"

Now you can use the function in your sheet cells:

=httpstatuscode(A1)