If you’re looking for a very simple and free way to monitor a number of websites’ uptime, then look no further. At Impression, we use Uptime Robot for our hosted clients, but in order to give our team distributed alerts we wanted a lower overhead solution which could be shared around.

Labnol created a great solution for Google Sheets and Google Scripts a few years back, and we took that as inspiration to completely rewrite a solution for ourselves. The Google Sheets Uptime Monitor from Impression allows minute-by-minute website uptime monitoring and alerts to an unlimited number of email addresses. It’s built to scale and as such, it would be appropriate for teams managing a large number of websites.

To get started, simply open this sheet and select File > Make a copy…

On the Config sheet, simply enter the following into columns A & B;

  • The full URL you would like to track
  • A comma separated list of email addresses that you would like to be notified when your website goes down and then up

Next, click Tools > Script Editor to edit the script, which is embedded within the document linked above, but is also provided in full below.

To ensure the script is running, click Run > Run function > init once. You may be asked for some permissions for Google to connect to external services and to send mail, but this is a one time setup required to both give correct permissions but also setup the script’s triggers to run every minute.

Use this one time setup function to ensure Google has the permissions it requires from you.

And that’s it! Feel free to make suggestions in the comments below. I’ve also provided the full script snippet below for your perusal.

Aaron Dicks

Performance Director

Performance Director of Impression. Search engine optimisation, paid media and web analytics consultant. Also programmer and digital all-rounder. @aarondicks

Aaron has specialist knowledge in SEO, PPC and Analytics Consultancy.

5 thoughts on “Monitoring website uptime in Google Sheets – with email alerts

  1. Simon R. says:

    Nice, but lots of work. Why not just use a free plan from one of the monitoring companies (WebSitePulse, Pingdom, Monitis)?

    1. aarondicks says:

      Hi Simon, this is just a free way of keeping all tracking in one spreadsheet.

      Other services may provide sufficient number of free accounts suitable for most people.

      We also found the granularity of testing time to be limited on other free accounts.

      Thank you for your suggestions!


  2. peter bray says:

    Monitoring “uptime” is one thing, and rather easy to do. Increasingly, though, it’s important to move beyond that to monitor actual content. Why? Not only can this help catch any defacement from internal or external sources, but by monitoring content you help catch bugs, SEO changes that you didn’t expect (a new editor deletes all your meta-tags for example), and security issues. Products such as https://versionista.com move beyond typical “uptime” monitoring and provide content integrity monitoring.

    1. aarondicks says:

      Thanks for the tips Peter

  3. Carlos says:

    This is great!! Perfect when you have 1000 or more websites to check. Thank you!