StatusCake

Zapier Set Ups – Automatically export uptime data to Google Sheets

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

How To

Using Social Media for Affiliate Marketing

7 min read Today, social media uses a wide range of different social networking platforms to help its users with the creation and sharing of ideas, information, personal interests and hobbies by establishing virtual networks. Affiliates can benefit from these groups that use web-based applications to communicate, interact and connect.

man-and-woman-on-website
How To

How to Improve User Experience

4 min read One of the biggest eCommerce questions – how do you improve user experience? Here are all the top tips for a better UX design to help you drive revenue.

woman-astronaut-flying
Product & Updates

How Page Speed Affects SEO

2 min read We all know page speed is crucial but not just for you brand – it affects SEO so hugely that it can make your pages drop in ranking.

short-reads

How to Reduce Bounce Rate

5 min read Learn what bounce rate is and how it is measured, what a good bounce rate looks like, and the actionable steps you can take to improve the bounce rate on your website.

man-on-bike
short-reads

What Causes Website Downtime?

3 min read Website downtime no longer needs to be this big mystery that keeps you up at night. Here are the top causes for website downtime AND how to fix them.

short-reads

Over 40% of Online Advertisements are Too Large and Slow Down Websites

2 min read Large ads have been a major issue with online publishers who have been struggling with how to curtail what many call “fat ads.” The oversized ads have a major impact on the ability of website visitors to see them as they can’t view them if they don’t load properly.