ESP32 weather station and Google Sheets

Weather station based on ESP32 and MicroPython which sends data to a Google sheet.

Public Chat
Similar projects worth following
This is a weather station based on ESP32 and MicroPython.

Here is a list of main features:

1. Measuring temperature and humidity with DHT22 sensor
2. Measuring CO2 level with MH-Z19B sensor
3. Sending data to a Google sheet
4. Supporting Google OAuth 2.0 service to get access to the sheet
5. Reporting network connection status, errors and high CO2 level with LEDs
6. Configuring the device via a web browser

The sheet doesn't need to be publicly available on the Internet. The device doesn't require any middleman such as PushingBox or IFTTT.

More details can be found in the following articles:

Portable Network Graphics (PNG) - 99.62 kB - 01/02/2021 at 12:37


  • 1 × ESP32 development board
  • 1 × DHT22 sensor For measuring temperature and humidity
  • 1 × MH-Z19B For measuring CO2 level
  • 1 × Resistor 10 KOhm
  • 1 × Resistor 20 KOhm

View all 13 components

View all 5 project logs

Enjoy this project?



sounak2007sm wrote 01/10/2021 at 07:39 point

Hi, This is a great project. I have used to connect different sensors and is still uploading sensor data. I was trying to read the data from specific cell from the google sheet. So added another function to, but it does not work. Can you please help me to add a function to read data from the google sheet?

  Are you sure? yes | no

Similar Projects

Does this project spark your interest?

Become a member to follow this project and never miss any updates