Back to Browse

IoT based Smart Energy Meter using ESP32 & Google Sheet | Google Spreadsheet

39.2K views
Aug 2, 2023
9:35

IoT based Smart Energy Meter using ESP32 & Google Sheet | Google Spreadsheet In today’s episode, you will learn how to make an IoT based Smart Energy Meter using ESP32 WiFi + Bluetooth module, the ZMPT101b AC Voltage Sensor, The DFrobot CT Clamp Current Sensor, And the Google Sheet or Google spreadsheet as the IoT platform for the real-time monitoring and data logging. Altium Designer: For Schematic and PCB designing https://www.altium.com/yt/electroniclinic Altium 365: https://www.altium.com/altium-365 Octopart, components search engine: https://octopart.com/ Download the Circuit diagram and programming: https://www.electroniclinic.com/iot-based-smart-energy-meter-using-esp32-google-sheet-or-google-spreadsheet/ Related Videos: Arduino-based Home Energy Monitor https://youtu.be/193DiCxWhkY ZMPT101b AC Voltage Sensor with Arduino https://youtu.be/5g9_JNoXrSg LoRa Energy Meter using Arduino,: https://youtu.be/9U-8ufMjxf4 How to design and Make yourself Arduino Development Board using Altium Designer https://youtu.be/1IRgB2T75P4 Support me on Patreon and get access to hundreds of projects: https://www.patreon.com/ElectroniClinic Project Description: ******* In today’s episode, you will learn how to make an IoT based Smart Energy Meter using ESP32 WiFi + Bluetooth module, the ZMPT101b AC Voltage Sensor, The DFrobot CT Clamp Current Sensor, And the Google Sheet or Google spreadsheet as the IoT platform for the real-time monitoring and data logging. This is the prototype model of IoT based Smart energy meter. And this is my Google spreadsheet for monitoring the Date, Time, Voltage, Current, Power, and Units. But, before, I start the practical demonstration, there are certain things which I would like to talk about. 1. You might be thinking, why Google sheet or Google spreadsheet as the IoT Platform? Why not Blynk IoT Platform? Well, Blynk is an amazing IoT platform and I have used it in so many projects and its good for the real-time data monitoring. But the Google spreadsheet is perfect for the real-time monitoring and Data logging. It’s absolutely free, you can monitor as many sensors as you want. You can use multiple Google sheets, and you don’t have to pay a single penny. I know, it doesn’t have those fancy widgets, but I really don’t care about the widgets. I want real-time monitoring and data logging; and I know Google spreadsheet is perfect for this job. 2. As a beginner, you might also be thinking about why ESP32? Why not ESP8266. Well the answer is ESP8266 has only 1 analog pin whereas on the other hand ESP32 has got multiple Analog pins and it also has the advantage of having a Bluetooth module. I am not saying that you can’t use the Nodemcu ESP8266 for monitoring multiple analog sensors. You can use the ADS1015 to increase the analog pins on the ESP8266 for connecting multiple analog sensors. I already have a video on the ADS1015 and the Nodemcu ESP8266 WiFi module, I have added a link in the description. 3. Your Sensors should be calibrated otherwise your project won’t be of any use. In my previous Arduino Home Energy Monitor based video, I explained in detail how to calibrate the ZMPT101b AC voltage Sensor, and how to calibrate the CT Clamp Current Sensor. So, you can apply the same calibration techniques over here. ****** Amazon Purchase links: ***************** ESP32 WiFi + Bluetooth Module (My recommendation), more IO pins, improved speed, and supports a Lipo Battery: https://amzn.to/3v40DkE CT Clamp Current Sensor https://amzn.to/46AEEQu CT Clamp Current Sensor from the DFrobot: https://www.dfrobot.com/product-1486.html ZMPT101b AC Voltage Sensor https://amzn.to/3PGvyM2 Other must-have Tools and Components: Arduino Uno, Nano, Mega, Micro "All types of Arduino Boards": https://amzn.to/3fk5OTi Top Arduino Sensors: https://amzn.to/3vZbnfM Super Starter kit for Beginners https://amzn.to/3cq56C5 Top Oscilloscopes https://amzn.to/3ctF3d8 Top Soldering iron kits: "best" https://amzn.to/39nqDtb 3D printers: https://amzn.to/3ruG1dt DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links, I will receive a small commission. This helps support the channel and allows me to continue to make videos like this. Thank you for your support! **************** For more Projects and tutorials visit my Websites Electronic Clinic: https://www.electroniclinic.com/ Follow me on Instagram: https://www.instagram.com/electroniclinic/ Follow my Facebook Page Electronic Clinic: https://web.facebook.com/profile.php?id=100063900156958 Follow my Facebook Group, Arduino Projects: https://web.facebook.com/groups/190031841821771 Email: [email protected] #energymeter #iotproject #altiumdesigner

Download

0 formats

No download links available.

IoT based Smart Energy Meter using ESP32 & Google Sheet | Google Spreadsheet | NatokHD