(Finally!) see and understand your IoT data with our Google Sheets connector

The Internet of Things has made collecting data easy. The hard bit has been analyzing that data. The applications bundled with IoT devices don’t allow for freeform exploration, and only the coders of the world can write APIs and build infrastructure to get and store the data. Tableau 10 is changing that with its Google Sheets connector.

Update: Tableau 10 is here! Download now to try out the feature outlined below.

The Internet of Things has made collecting data easy. The hard bit has been analyzing that data. The applications bundled with IoT devices don’t allow for freeform exploration, and only the coders of the world can write APIs and build infrastructure to get and store the data.

Tableau 10 is changing that with its Google Sheets connector. Finally, it is possible to build a direct path from IoT devices to the analytical, intuitive power of Tableau. In Tableau 10, you can connect to your Google Sheets. Not only that, if you publish your analysis to Tableau Server, the data can be set to auto-refresh.

Yes, you read that right: Tableau 10 has a refreshing connection to Google Sheets. This has many incredible applications, but today I’m going to focus on my favorite site on the internet, IFTTT.com.

Let’s see how we can use IFTTT and Google Sheets to analyse our IoT data.

All you need are three things:

  1. One or more connected device. In this example, we’re using a sensor which activates when the front door opens (this is genuine data, but we’ve kept its owner anonymous)
  2. An IFTTT account and a recipe which, when triggered, saves information to a Google Sheet
  3. Tableau 10 and its Google Sheets connector

What insights can we find about daily habits?

I began by looking at the number of door openings per day. One day jumped right out as an outlier. What day was that? October 31—of course! Halloween! Trick or treat! I verified that by looking at when the door was opened on that day:

That’s right—the door was opened 41 times between 4 p.m. and 8 p.m.—all those kids, all those treats all generating data!

You could set up a dashboard so you can explore any day’s comings and goings with ease.

Check out this video for a detailed demonstration of how to connect to Google Sheets with Tableau 10.

This is but the simplest of simple explorations of IoT data, but the possibilities for analytics are endless. For some more ideas, check out the channels available on IFTTT.com.

  • Maybe you want to explore data from your Fitbit, or bike rides in Strava? You could also track weather in your home city and see if it affects your training.
  • You could analyse the temperatures you set on your Nest Thermostat to check home efficiency.
  • What if you looked at home security sensors to look for suspicious activity?
  • IFTTT has 328 channels you can connect to—an almost-limitless set of ways to track IoT data!

Of course, there’s much more to Google Sheets, too. Try exploring their ImportHTML and ImportFeed functions to retrieve, then explore, data from across the web.

What will YOU do with the Google Sheets connector? Let us know!

Learn more about Tableau 10

Tableau 10 includes a brand new look and feel, and a host of new features to help you prep, analyze, and share your insights even faster. Check out our Coming Soon page for details.