Skip to main content

Using Google Docs to monitor your website

There are many different ways to monitor your website. You can run a program (eg. Integrio Uptime Scout) locally on your own machine, you can use a web service (eg. FreeSiteStatus), and now you can summon the might of the entire Google infrastructure to tackle this task (via Google Docs) for free.

The whole thing is surprisingly easy to setup. You first make a copy of this spreadsheet. Then within your own copy of the spreadsheet, change the URL to point to the website you wish to monitor and the email address to be notified for uptime and downtime.


Then in the Google Docs menu, select Tools –> Script Editor to bring up the script editor window. Then select Resources –> Current Script’s Triggers. Under the "Run" drop-down menu, select "isMySiteDown". Then under "Events", select "Time-driven", followed by “Minutes timer” and choose how often you want your website to be checked (eg. Every 15 minutes). Now save the trigger and authorize Google Docs, then re-save. To get the script to run, select Run -> IsMySiteDown.


The script is also relatively easy to understand and customize, so if you have any special requirement, it should be quite straightforward to modify the script and adapt it to your needs.
Labels:

Comments

Post a Comment

Popular posts from this blog

Cooling mod for the X96 Air #2

Previously, I added a USB cooling fan to the X96 Air TV box . The problem with this mod is that the fan is always running, and it runs at full speed. Ideally, the fan should kick in only when the CPU temperature is above a certain threshold. It would be even better if there is a way to control the fan speed. Dan McDonald left me a comment pointing to his project on Github . He basically connected the fan to a USB relay that can be controlled by Python script. His project inspired me to make a similar mod that would make use of the spare D1 Mini boards I have lying around. The plan is to hook up the fan to a MOSFET (2N7000) and control it via PWM. Here's the very simple circuit: The code simply reads a single character from the serial port (0 - 9). 0 will turn the fan off, while 1 - 9 will generate a proportional PWM to drive the fan, with 1 being the lowest and 9 being the highest. Here's the Arduino code: #include <Arduino.h> void setup () { Serial . begin ( 9600 ...
1 comment
Read more

Installing and customizing CoreELEC in X96 Air

I previously installed CoreELEC on another TV Box ( Ugoos X3 Pro ), which unfortunately died after only 9 months during the summer (due to the unit overheating, which I learned is a common problem for cheap Android TV boxes). So this time I purchased a X96 Air  (4GB/32Gb) and had to do the whole thing again. So this is a note-to-self in case I ever have to install CoreELEC again on some other device. Installation of CoreELEC is simple enough by following this guide . Basically, it involves downloading and writing the firmware to a microSD card using usbimager . Then insert the microSD card, reset the unit and hold the reset until the logo appears. The unit will then proceed to boot into CoreELEC. First thing is to connect to WiFi, then enable SSH. This allows me to login via ssh and execute: ceemmc -x from the terminal. This writes CoreELEC to the built-in eMMC storage, after which I am able to remove the microSD card and reboot the unit into CoreELEC via the built-in sto...
Post a Comment
Read more

DC-DC Buck Stepdown Converter for ESP8266

I am working on a project that requires a step-down converter from 12V to 5V, that will then power a WeMOS D1 Mini. I saw this new mini buck converter based on the usual LM2596 MP2307 , so I thought I'd give it a try. Unfortunately, it didn't work. Although it is supposed to be able to supply up to 1.8A, the D1 Mini was not able to boot up. The 5V pin was being properly supplied, but the 3.3V pin measures at only ~1.3V. So I had to go back to my usual LM2596 module, which is much larger, but works to power the D1 Mini with a 12V source. Here's a great review of the mini buck converter I found while trying to figure out how to make it work. The fact that it has high quiescent current (~60mA) is also mentioned in a few other sources.
Post a Comment
Read more