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)