At the Intersection of Empathy & AI

Data logging made easy — Intel Edison and Sheetsu

A simple hack using Intel Edison and Sheetsu to log sensor data directly to Google Sheets for IoT projects.
Data logging made easy — Intel Edison and Sheetsu

How many times have you wondered, it would be so cool if I could know every time when my code fails, I could log it somewhere? or I need to create the right thresholds, I wish I could log all the data on a remote location? Well, if you have ever come across these questions, let me give you an easy solution to it all. For the demonstration purpose, I am going to use Intel Edison as the development board and Google Spreadsheet to put all my logged data.

Let's first create a basic spreadsheet. Go create a blank spreadsheet. I am calling mine DataLoggingBlog. Now, since the spreadsheet is done, let's create an API out of this. This is going to give us the access of not just POST and GET requests but multiple others. To do this, we are going to use Sheetsu. Just sign in using the google account, and then paste the link to the google spreadsheet. Or just paste the link, Sheetsu is going to ask for permission to access you docs, allow it and you are done.

Now that this is working, let's test the API with a POST call, we already know how we want to send the data. I am going to use Postman Client to test the API. Why? Because I love it. I am going to first create the Headers. I am going to write the body in JSON format. Now that the POST is done, let's check how our spreadsheet looks like. And basically that is it. Your API works. Congratulations!

All you need to do now is intergrate it with Edison. Let's do that now. My way of working with the edison is to login serially and write the commands using VI. The link to the code could be found in the repository. The response should be a success. And that is how you make your lifes easy with Sheetsu. I love it, tell me your experience with it?

Member discussion