Website status monitoring using Google Sheets and Google Apps Script.
A Spreadsheet-bound apps script solution to conduct automated status monitoring on websites listed by the user in a Google Sheets management file. A separate status log file in Google Sheets will be created so that users can easily integrate data with BI services such as Google Data Studio.
Copy this sample spreadsheet to your Google Drive.
Replace the WEBSITE NAME and TARGET URL columns with those of the website(s) that you want to monitor.
Delete everything except the first row.
Go over the parameters that you can set for this status monitoring and edit the VALUE items to suit you needs.
From the spreadsheet menu, select Web Status > Triggers > Set Status Check Trigger/Set Log Extraction Trigger to set up time-based triggers to conduct automated status checks. The latest results will be shown in the 01_Dashboard worksheet.
You will be asked to authorized the script the first time you execute it. Users of free Gmail account should expect to see the Unverified warning during this authorization process. Note that the owner of the script is yourself, and that this solution will not send or receive any information to and from any other Google accounts or services outside the Google ecosystem (except for checking the HTTP response codes of the websites that you designated because, well, that's what it does for status monitoring) unless you explicitly share the spreadsheet.
Updates will be distributed via @ttsukagoshi/website-monitoring-by-gas (GitHub).
You must agree to the Terms and Conditions to use this solution.