Monitor your websites with Google Sheets
Digital Inspiration offers this template and steps for monitoring your websites with Google Sheets.
Let’s get started:
- Click here to copy the website monitoring Google sheet into your Google Drive.
- Go to the Website Monitor menu (near Help) and choose Configure. You may have to authorize the script the first time you configure the monitor.
- Specify your website URL and the email address where you wish to be notified. You can put multiple addresses separated by commas.
- This is option. Enter the Google Analytics Id (e.g., UA-123456-78) and the site monitor will log downtime / uptime events in your Analytics account.
Click the Start button and the Google sheet will start monitoring your website in the background. You may now close the sheet.
The uptime and downtime times are logged in theGoogle Spreadsheet so you can use that data to analyze the performance of your web hosting company.
MONITOR MULTIPLE WEBSITES
The website monitor is open-source (Github) under MIT License. You can check our Google Apps Script page to discover more interesting projects made with Google Scripts.
If you would like to monitor more than one website with app, make a copy of the same Google Sheet and specify another website URL in the sheet.
HOW IT WORKS
Internally, a Google Script attached to the Google Sheet is doing the monitoring and logging events in Google Sheets and Google Analytics.
The script triggers every few minutes and then tries to fetch your website using URLFetchApp, a Google service similar to wget or curl. If the HTTP response code is anything other than 200, it indicates that there’s an issue with your website and an email alert is sent via the Gmail API.
A previous version of the script had the ability to send SMS text messages when your website goes down. The functionality is now removed since Google no longer support text alert notifications inside Google Calendar.
CREDIT
Created by Amit Agarwal
Google Developer Expert, Google Cloud Champion
Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India.
Amit has developed several popular Google add-ons including Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory