Most webmasters use “free” website monitoring services to track the downtime and uptime of their sites. These free service normally offer one domain monitoring service and often required to upgrade to the premium version for unlimited domain monitoring. Some feature like email or SMS alerts require premium version. Now, via Google Drive Spreadsheet, you can monitor the status your websites freely with out paying for any commercial services. You can track and monitor unlimited number of websites and get alerts from email or SMS. This Google Scripts based website monitoring tool is absolutely FREE as well. The setup only takes free minute. After you configured, Google Drive will monitor the uptime /downtime of your website(s) continuously and automatically.
How is how to:
- Sign-in to your Google account and then click here to copy this Google sheet into your Google Drive. You can copy to as many Google account as you want.
- Put your website URLs in cell B2 (comma separated) and your email address in cell B3. If you wish to receive alerts by text messages, put Yes in cell B4.
- You’ll find a new Website Monitor menu in your Google Sheets toolbar. Click Initialize and you’ll get a pop-up asking for authorization. Grant the necessary access.
- Go to the Website Monitor menu again and choose “Start Website Monitor” to begin the monitoring process. Close the Google Sheet. How does this Google Drive Scripts based website monitor works? There’s a simple Google Script attached to the Google spreadsheet that does the monitoring. The script triggers every 5 minutes (in default) and then tries to fetch your website using URLFetchApp.fetch (a Google function similar to wget or curl). If the HTTP response code is anything other than 200, it indicates that there’s an issue with the underlying website. The spreadsheet will record whenever your website(s) is up or down. You will receive an email and/or SMS when your website(s) is/are down or up.
How does the SMS alerts works? The SMS alerts are Sent via Google Google Apps Script will creates an event in your Google Calendar but with an SMS reminder. the event is set to expire in 30 seconds and thus you get an instant text alert on your mobile. If you aren’t getting text alerts on your phone, please ensure that your phone number is associated with Google Calendar as detailed in the following tutorial.
To register your mobile phone with Google Calendar, here is how:
- Open Google Calendar.
- Click the gear icon at the top right > Settings.
- Click the Mobile Setup tab.
- Select your country from the Country drop down menu.
- Enter your phone number in the Phone number field.
- Select your carrier from the drop-down menu, if applicable.
- Click the Send Verification Code button.
- Once you receive the text message, enter the code you received in the Verification code field and click the Finish setup button.
- Click Save.
Original Script from: Digital Inspiration