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.

Comments

Update: Line adapter for Ozito Blade Trimmer

Update (Dec 2021): If you access to a 3D printer, I would now recommend this solution , which makes it super easy to replace the trimmer line. I have been using it for a few months now with zero issue.

Cooling mod for the X96 Air

I realized after my Ugoos box died that overheating is a big problem with cheap Android TV boxes. A teardown of the Ugoos box shows that it does not have any heatsink or fan at all! The X96 Air does have a heatsink, but the heatsink is located at the bottom of the casing with no ventilation. In this default configuration, with the ambient room temperature at 25c and playing a 1080p video, I was seeing the CPU temperature at 67c. I drilled a couple of holes at the bottom of the casing. The CPU temperature fell to 59c with the box raised about 2cm with plastic blocks. I retrieved an old 5V laptop fan: Then cut and strip away a spare USB cable: Solder the red and black wires on the fan and the cable: Secure the fan to the bottom of the casing with double-sided tape, then plug the fan into the box's USB connector. Here's a view of the box with some 3D-printed risers installed at the bottom to give the mounted fan sufficient clearance: The CPU now runs at 43c, a huge drop from the ...

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...

Random Sequence

Search This Blog