Main Content

Python/MicroPython Sensor Logger with Google Sheets

Wemos D1 mini takes sensor readings and sends a POST request containing data to Flask Server on RPi 3. Data is then written to Google Sheet.

A system for recording sensor values to a Google Sheet. Making use of HTTP requests to communicate between the micro-controller and the server, and utilising gspread to write data to online spreadsheet.

You will need to follow the instructions on the following link to set up access to your spreadsheet.

http://gspread.readthedocs.io/en/latest/oauth2.html

pin D0 to RST: Must be connected to wake from Deepsleep.

+ : to 3.3v on Wemos

- : to GND on Wemos

Signal: to A0 on Wemos

As usual, if you need help implementing this in your own project, leave me a comment and I’ll get back to you.”

Link to article