Raspberry Pi Full Stack: Google Sheet data-logger (sample lecture) 

 March 2, 2020

By  Peter

In this post, I share another sample from Raspberry Pi Full Stack. This one is the introductory lecture to another new section, in which I show you how to do data-logging on Google Sheet.

I have implemented this feature using a special Python module that allows the application to easily access Google Drive and interact with the Sheet API. With this feature implemented, the application logs any sensor node incoming data to both its local database, and to Google Sheet. 

Once your sensor data are on Google Sheet, you can process them with all the functionality of the Sheet spreadsheet.

Enjoy 🙂

Transcript from this sample lecture

Hi and welcome to a new section in this course.

In this section, what we’ll do is to expand our Raspberry Pi gadget with additional nodes.

We’ll have a new node that consists of an Arduino Uno, which is connected to an RF24 transceiver.

Plus, of course, a DHT22 sensor.

This new Arduino node will be able to communicate with our Raspberry Pi base module and it will be able to send it data from the sensor.

The Raspberry Pi will receive the data and record it in its database.

And that requires a few little changes as well in the front end.

And I thought, I’ll show you what the end result of the work we’re going to do in this section will be like.

And then in the next few lectures, I’ll take you through step by step the implementation process.

So by the end of this section, what you’ll have is something like this, which looks like the original user interface for our gadget, except now we’ve got a little field here which holds a sensor ID.

Up to now we’re going to working only with the Raspberry Pi and its sensor and we call that sensor ID “1”.

But we’re going to add another node to our gadget, which is going to be the Arduino, as I said earlier.

And for the purposes of this demonstration, I’ve given it the ID of “3”.

So once we have a few samples recorded, we’ll be able to go here, say I wanted to see the records for the node with ID “3”, you can submit.

And we’ll be able to retrieve data from sensor, this case, ID “3”.

And the way that we are going to build this will allow us to set up any number of remote sensors or remote nodes, because we’ll be using the network version of the RF24 library for the Arduino and for the Raspberry Pi, which allows us multiple nodes, as I’m going to show you very soon.

So this is what we are going to be working on in this section.

We’ll start with the Arduino.

In the next lecture, I’ll show you the wiring and the sketch for the Arduino and then switch over to the Raspberry Pi and conclude the project by putting all the modifications, hardware and software together to build what you seeing here.


Peter Dalmaris is an educator, electrical engineer, electronics hobbyist, and Maker. Creator of online video courses on DIY electronics and author of three technical books, and has recently released his book Maker Education Revolution.   As a Chief Tech Explorer since 2013 at Tech Explorations, the company he founded in Sydney, Australia, Peter’s mission is to explore technology and help educate the world.  Tech Explorations offers educational courses and Bootcamps for electronics hobbyists, STEM students and STEM teachers. A life-long learner, Peter’s core skill is in explaining difficult concepts through video and text. With over 15 years of tertiary teaching experience, Peter has developed a simple yet comprehensive style in teaching that students from all around the world appreciate.  His passion for technology and in particular for the world of DIY open source hardware has been a dominant driver that has guided his personal development and his work through Tech Explorations. Peter’s current online courses have helped over 60,000 people from around the world to be better Makers. 

Peter Dalmaris

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Subscribe to our newsletter now!