Website Status Monitoring using Google Sheets
Website status monitoring using Google Sheets and Google Apps Script.
About
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. Notifications of changes in website status will be sent to the user’s Gmail. An optional setting to send notifications to Google Chat is available.
Copy Sample Spreadsheet
Copy this sample spreadsheet to your Google Drive by selecting from the menu File
> Make a copy
.
How to Use
Setup
Authorization Users will be asked to authorized the script the first time they execute it. Free Gmail account users should expect to see the Not Verified by Google
warning during this authorization process. You will have to agree with authorization to use this solution despite this warning, but please 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.
Worksheet | To Do |
---|---|
01_Dashboard |
Replace the WEBSITE NAME and TARGET URL columns with those of the website(s) that you want to monitor. |
90_Spreadsheets |
Delete everything except the first header row. |
99_Options |
Go over the parameters that you can set for this status monitoring and edit the VALUE items to suit your needs. |
Worksheets not listed above can be left alone; they will be updated automatically.
Set Triggers
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.
Enable Google Chat Notification
Users can optionally enable Google Chat notification that can be used with (or replace) email notifications of changes in website status. Enter the webhook URL of the Google Chat chatroom that you want the notification to be sent to. Steps to obtain this URL is described in the official documentation by Google. The URL should look something like https://chat.googleapis.com/v1/spaces/*****/messages?key=*****&token=*****
Updates
Updates will be distributed via @ttsukagoshi/website-monitoring-by-gas (GitHub).
Terms and Conditions
You must agree to the Terms and Conditions to use this solution.
Source Code
Source code is available on GitHub. Please make requests for enhancements or reports of bugs via the GitHub issue. License regarding the use of the code is available on the GitHub repository.