Скачать с ютуб ESP32 + Google Sheets | Writing Data to Google sheets using ESP32 | Arduino & Micropython в хорошем качестве

ESP32 + Google Sheets | Writing Data to Google sheets using ESP32 | Arduino & Micropython

In this video, I’ll show you how to send temperature and humidity data from an ESP32 to Google Sheets using both the Arduino IDE and MicroPython. We’ll use the DHT22 sensor to capture the data, and I’ll guide you through the process of connecting your ESP32 to a Google Apps Script Web App, enabling you to log sensor data in real-time directly to your Google Sheet. We'll cover: ✅ Setting up your Google Sheets and Google Apps Script to receive data. ✅ Writing data to Google Sheets from ESP32. ✅ Using NTP (Network Time Protocol) to add timestamps. ✅ Working with push buttons to control when data is sent. ✅ Handling the data in JSON format for efficient communication. What You'll Learn: ✅Sending Sensor Data: Learn how to append and replace rows in Google Sheets using HTTP POST requests from the ESP32. ✅ Real-Time Timestamps: Use the NTP client to fetch and send accurate time information along with sensor readings. ✅ Push Buttons: We’ll demonstrate how to send data on button press and track the button state. ✅ Working with JSON: Understand how to structure and send data using JSON to communicate with web services like Google Apps Script. Hardware Used: ✅ ESP32 Development Board ✅ DHT22 Sensor (Temperature & Humidity) ✅ Push Buttons 00:00 Introduction 00:30 ESP32 with google sheets (3 scenarios) 00:50 Setting up google sheet to receive data 01:17 Explanation of function used in google sheets 02:48 deploying a function in google sheets 03:44 Formatting google sheet to receive data 04:23 Wokwi creating a new project 04:57 Making Circuit (Interfacing DHT22 with ESP32) 06:05 Installing libraries 06:25 ESP32 with Google sheets using Arduino IDE (Code) 10:11 Sending data to Google sheets using ESP32 and Arduino IDE (Appending) 10:36 Changing the NTP client Time format (UTC to GMT+2) 11:30 Sending data to Google sheets using ESP32 and Arduino IDE (Replacing) 12:06 Sending data to Google sheets using ESP32 and Arduino IDE by pressing button 13:10 ESP32 with Google sheets using Micropython setup 13:35 ESP32 with Google sheets using Micropython (code) 15:42 Sending data to Google sheets using ESP32 and Micropython by pressing button 16:15 Sending data to Google sheets using ESP32 and Micropython (Appending) 16:48 Sending data to Google sheets using ESP32 and Micropython (replacing) 17:05 Final comments Code & Resources: You can find all the code used in this video at the link below: https://github.com/HighVoltages/Writi... Don’t forget to LIKE the video if it helps, and SUBSCRIBE to High Voltages for more content on ESP32, Arduino, IoT, and other cool projects! #esp32 #googlesheets #arduino