How to Use Google Docs to Monitor Multiple Sites and Get Free Downtime SMS Alerts

Google Calendar will be aiding Google Docs to send free SMS notification when site is down. Whereas the actual monitoring is done by Google Docs.

• Configuring Google Calendar for Phone Notification

1. Log in to Google Calendar

2. Click on the Gears icon on the top right and select settings.

3. Now click on the Mobile Setup tab.

4. Select Country, enter your Phone number and now click Send Verification Code. Now enter the code you got on your mobile and verify your number. If you don’t receive the code check if your carriers fall under supported mobile providers.

5. Now in Notifications select SMS as your default notification channel and save it.

Now you are done with the Google Calendar configuration part. All that is left is to copy the Google Docs provided below and set the polling frequencies.

• Configuring Google Docs To Monitor your Sites

1. Log in to Google Docs

2. Click here to make copy of the Google Spreadsheet.

3. In F3 to F6 cell you can enter the URL of the sites you want to monitor. Currently supports up to four sites. You can tweak the code to support many more.

4. In cell F8 enter your Email Address into which you want to get alerts. Entering phone number is not required as it will be picked up from Google Calendar.

5. Now select Tools-> Script editor.

6. Select Resources-> Current script’s triggers. Under Run select “isMySiteDown” then in Event select Time-Driven, Minutes timer and Every minute and save it. Now click the Authorize button and then Grant Access. Save the trigger again.

Now on Google Docs will be polling and monitoring all the sites you have entered every minute. You will be getting SMS alert, Email alert when any of the mentioned site is DOWN, the exception/error details will be logged in ‘C’ column and URL will be logged in ‘B’ column helping you identify which site was actually down. Similarly you will be getting alerts once the site which was DOWN is UP again.

Get Free SMS Alerts for New and Important Emails on Gmail with Google Docs

1. Setting up Google Calendar to make SMS as default reminder channel

If you have completed the above steps, You are successfully configured Google Calendar for your phone notification.

2. Creating filter condition and linking to Label in Gmail

• Login to Gmail.
• Click on the Gears icon on the top right and select Settings.
• Go to Labels tab.
• Scroll down and click Create new label.
• Give label name as sendsms and click create. Now label creation is done.
• Now click on filter tab.
• Click Create a new filter.
If you want SMS alerts only for emails from some important person such as your boss. Set the filter condition using ‘from’ field.



If you want SMS alerts for all incoming emails. Set the ‘Has the words’ field with is:inbox




• Click Create filter with this search.
• Now check Apply the label and select sendsms from the drop down. Finally click create filter.                                           
  

3. Configuring Google Docs To Poll for New Incoming Emails

1. Login to Google Docs.
2. Click here to make copy of the spreadsheet. Click Yes, make a copy.
3. Now select Tools-> Script Editor. Then Resources-> Current script’s triggers.
4. Select click here to add one. Under events select Time-Driven then minutes timer and every minute and save it.
5. Click Authorize and then grant access. Now click close and save the trigger again. That’s it.

So, now on Google Docs will be polling your Gmail Account every minute for new incoming messages through the label you have created and will send a free SMS alerts as and when they arrive.