My Blog
Scroll down to discover

Monitor your Website’s Uptime with Google Docs

October 28, 2013Category : IT & Network

Do you have a website or a blog? Would you like to receive instant alerts as soon as your site goes down or becomes inaccessible to users? Would you like these alerts to arrive in your email inbox or as text messages on your mobile phone or both?


Monitor Website’s Uptime with Google Docs

You can also use Google Docs to monitor your website(s) and, unlike the commercial services, Google imposes no restrictions. You can track any number of websites with Google Docs and it will send email /text alerts in case of any issues. And this DIY website monitoring tool is absolutely free.

Here’s how you quickly configure Google Docs to monitor the uptime /downtime of your website(s). This has to done just once and Google Docs will continuously monitor all your sites in the background.

Let’s get started:

  1. Sign-in to your Google account and then click here to copy this Google sheet into your Google Drive. You may use your Google Apps account as well.
  2. Put your website URLs in cell B2 (comma separated) and your email address in cell B3. If you wish to be alerted by text messages, just replace No with Yes in cell B4.
  3. You’ll find a new Website Monitor menu in your Google Docs toolbar. Click Initialize and you’ll get a pop-up asking for authorization. Grant the necessary access.
  4. Go to the Website Monitor menu again and choose “Start” to begin the monitoring process.  Close the Google Sheet.

That’s it. The Google Docs sheet will monitor your website in the background at 5-minute intervals and will send alerts whenever it has trouble accessing the website. If the issue is resolved, you’ll get another notification saying “all’s well.”

The uptime and downtime times get logged in the same Google Docs sheet so you can use that data to analyze the performance of your web hosting company.

Get SMS Alerts for Import Gmail Messages

To register your mobile phone with Google Calendar, you need to obtain a verification code. Here’s how:

  1. Click the gear icon at the top of any page and select Settings from the drop-down menu
  2. Click the Mobile Setup tab
  3. Select your country from the Country drop-down menu
  4. Enter your phone number in the Phone number field
  5. Select your carrier from the drop-down menu, if applicable. If you see the link See Help Center for supported providers, please check if your provider is supported before requesting your verification code.
  6. If your carrier is supported, click the Send Verification Code button, and you’ll get a text message on your phone
  7. Once you receive this message, enter the code you received in the Verification code field and click the Finish setupbutton
  8. Click Save

How Website Monitor works?

Internally, there’s a simple Google Script attached to the Google Docs sheet that does the monitoring.

The script invokes itself every 5 minutes, with the magic of Script Triggers, 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.

How SMS Alerts Are Sent via Google

Google Apps Script can send email messages but the script employs a workaround for sending text messages.

It creates a regular 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 this tutorial.

© Oliver / All rights reserved.
To top