How to Use Google Sheets to Check Website Status Code

Step 1: Create/Import Spreadsheet in Google Sheets

• Open your web browser and navigate to Google Sheets (sheets.google.com). 

• Click on the “+ New” button and select “Google Sheets” to create a new blank spreadsheet.

Step 2: Write a Custom Function in the Script Editor

• Access Script Editor: In your Google Sheets, go to “Extensions” > “Apps Script” to open the Script Editor. And Write the script.

• Get the script from this document: https://docs.google.com/document/d/1HlpWKmNu0YYGLj1HxCbJaolGWz7eFImWBYJ9anQeDEg/edit

Step 3: Test Your Function in the Spreadsheet

• Enter URLs: In your spreadsheet, enter the website URLs you want to check in the “Website URL” column.

• In the cell next to the first URL, type =getStatusCode(A2) 

• Press Enter. The cell will display the corresponding status code.

• Click here to get more information