3 Things You Didn't Know Google Spreadsheet Can Do For You (Part 1)

There's no denying that we are all slowly becoming too dependent on Google apps. From a simple task of digging the world's information down to locating the nearby coffee shop, we always turn to Google and get the information we want in the blink of an eye.

One of the best web services that Google has ever made for everyone is the Google Docs suite. Its powerful, cloud-centric features along with its ever-improving mobile app makes it really a mature and capable platform.

Open and View Online Documents of Any Format Directly On Your Browser without Downloading Them


But just as every finest web app available in the wild, there are things that you might have missed & didn't realized you could do with Google Sheet app. And in this post, we are going to explore some of the lesser-known Google Sheet hacks and tricks to make your digital life a lot easier.

3 Clever Uses of Google Sheets You Might Not Know Yet (Part 1)


(1/3) Use Google Spreadsheet to monitor website downtime and uptime

If you have a blog or website, you know exactly how important web monitoring apps like Pingdom and Uptime Party can be. These are apps designed to monitor your website's uptime that should alert you in real-time when your site is down or inaccessible. These website monitoring apps work great, but they often come with a price.

In case you need a FREE Pingdom alternative, you can turn to Google Spreadsheet and use it as a website monitoring tool to track your site's downtime and uptime. As with premium apps like Pingdom, you get instant email or SMS notification delivered straight to your inbox once your site is down.

The process should only take about a minute or so to setup, and you're good to go.

Here's how to get started:


1 Sign-in to your Google account and make a copy of this Google sheet (File > Make a copy)

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

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

4 Go to the Website Monitor menu again and choose “Start Website Monitor” to begin the monitoring process. Close the Google Sheet.

That's it. Google Sheet should now monitor and alert you in real-time when your site goes down, as seen below:



Get Notified When A Collaborator Made Some Changes On A Shared Google Spreadsheet




CONTINUE: 3 Things You Didn't Know Google Spreadsheet Can Do For You (Part 2)