StatusCake

Zapier Set Ups – Automatically export uptime data to Google Sheets

statuscake

Ever wanted to keep a backup of StatusCake data without manual entry or usage of the API? This article will take you through a different and automated method of doing so for the Up and Down test alerts. This is done with the help of the Zapier service, and the data will be stored in Google Sheets.

zap3

It’s easy to set up automated input of your downtime data to Google Sheets through Zapier. Each time that a website goes down, a new row can be added to your spreadsheet, and another row will be added when it comes back up. This gives you a great raw record of your downtimes, and this data can be retained for as long as you choose.

The Zapier integration can grab info from each alert, including the test’s name, the UP/DOWN status, the time of the alert, the location that the testing came from, and the status code that was present.
zap1

You can choose exactly how you want the spreadsheet to be formatted when creating the Zap, and which details should be included, when this is completed you’ll see the up and down alerts looking something like the above in your spreadsheet.

If you would like to give this Zap configuration a try, you should use StatusCake as the “Trigger” and Google Sheets as the action, it’s just these 2 steps that would be required.

cropped

Share this

More from StatusCake

DNS
Engineering

What’s new in Chrome Devtools?

3 min read For any web developer, DevTools provides an irreplaceable aid to debugging code in all common browsers. Both Safari and Firefox offer great solutions in terms of developer tools, however in this post I will be talking about the highlights of the most recent features in my personal favourite browser for coding, Chrome DevTools. For something

Engineering

How To Create An Animated 3D Button From Scratch

6 min read There has certainly been a trend recently of using animations to elevate user interfaces and improve user experiences, and the more subtle versions of these are known as micro animations. Micro animations are an understated way of adding a little bit of fun to everyday user interactions such as hovering over a link, or clicking

Want to know how much website downtime costs, and the impact it can have on your business?

Find out everything you need to know in our new uptime monitoring whitepaper 2021

*By providing your email address, you agree to our privacy policy and to receive marketing communications from StatusCake.