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

this video is brought to you by Altium in today's episode you will learn how to make an iot based Smart Energy meter using esp32 Wi-Fi plus Bluetooth module the zmpd101b ac voltage sensor the TF robot CD clamp current sensor and the Google sheet or Google spreadsheet is 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 number one you might be thinking why Google sheet or Google spreadsheet is the iot platform why not blink iot platform will blink is an amazing iot platform and I have used it in so many projects and it's good for the real-time data monitoring but the Google spreadsheet is perfect for the 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 number two as a beginner you might also be thinking about why esp32 why not esp8266 well the answer is esp8266 has only one 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'm not saying that you can't use the node MCU esp826 for monitoring multiple analog sensors you can use the ads 1015 to increase the analog pins on the esp8266 for connecting multiple analog sensors number three your sensors should be collaborated otherwise your project won't be of any use and my previous Arduino home energy monitor based video I explained in detail how to calibrate the zmpd101b ac voltage sensor and how to calibrate the CT clamp current sensor so you can apply the same calibration techniques over here I think I have shared enough useful information with you guys so now let's go ahead and start the Practical demonstration my laptop is connected to the Wi-Fi since this is an iot based project it really doesn't matter if you connect the laptop and esp32 Wi-Fi plus Bluetooth module to the same Wi-Fi network or different Wi-Fi networks anyway in the Google spreadsheet I will be monitoring the date time voltage current power and units I'm going to supply ac voltage to the zmpt101b ac voltage sensor be very careful never touch these contacts when the AC Supply is connected next I am going to attach the CT clamp current sensor everything looks good but first i'm going to measure the actual voltage and current the actual voltage is 168 volts the actual load current fluctuates between 0.35 and 0.36 ampere now let's power up the esp32 Wi-Fi plus Bluetooth module [Music] as you can see I'm able to receive the desired values foreign voltage and current values are pretty close to the actual voltage and current values if on your side the current value is different then you can change the correction factor value in the programming anyway once the data is received in the Google spreadsheet then it's not going anywhere unless you delete it yourself anyway you can also monitor the same values on your cell phone all you need is to login into your account you can check the voltage current power and units at any given time now let's go ahead and take a look at the connections as usual I'm using my designed esp32 base development board but you can also do the same exact connections on a breadboard and now forget about the relays and just concentrate on the connections I'm about to explain connect the VCC and ground pins of the zmpt101b ac voltage sensor to the esp32 3.3 volts and ground connect the outpin of the zmpt101b voltage sensor to the esp32 io34 connect the VCC and ground wires of the AC current sensor to the esp32 3.3 volt and ground connect the output signal via a to the esp32 io33 so that's all about the connections and still if you think you have missed anything then you can follow this circuit diagram now let's go ahead and start with the Google spreadsheet setup ultimate designer is the world's most trusted PCB design system ultim designer enables Engineers to effortlessly connect with every facet of the electronics design process over 35 years of innovation and development focused on a truly unified design environment makes it the most widely used PCB design solution with ultium designer you can create PCB designs with an intuitive and Powerful interface that connects you to every aspect of the electronics design process routed your way through any angle tuned for the delay push slide and walk around faster than ever easily work together with your mechanical team and forget about the days of swapping design files every design change stays in sync between ultim designer and SolidWorks BTC crew Autodesk Inventor Autodesk Fusion 360 or Siemens NX interact and collaborate with mechanical designers like never before and a photorealistic 3D design environment one of the best things about ultimate design is that you can share your designs with your team members using ultim365. they can check your design leave comments and if there are any issues they can fix them from anywhere in the world ultimate designer also uses the world's fastest component search engine octopart so you won't have any difficulty in searching for components links to the ultim designer ultim 365 and octopod are given in the description while you're logged in into your registered Gmail ID click on Google apps click on sheets click on start a new spreadsheet enter your project name [Music] sit the column names go to the extensions menu and click on the app script enter the project name [Music] copy and paste the script you can download it from my article go to your Google spreadsheet and copy this part of the URL and paste it in the script [Music] click on the deploy button and select new deployment click on enable deployment types and select web app write the description under who has access select anyone and then click on the reply button click on authorize access Gmail account click on advanced select the project click the allow button copy the deployment ID open the esp32 programming which you can download from a website electronicclinic.com and paste it next to the Google script ID and that's it finally you can select your esp32 board and the communication port and click on the upload button and don't forget to change your SS ID and password foreign [Music] as you can see the program has been uploaded [Music] [Music] thank you support me on patreon for more videos I hope you liked today's episode like and share this video with your friends see you in next episode and thanks for watching [Music]

Channel: Electronic Clinic

Views: 18,675

Keywords: iot based smart energy meter, energy meter, smart energy meter, energy meter data logging, google spreadsheet for data logging, google sheet for data logging, esp32 project, home energy monitor, smart energy meter using esp32, esp32 and google sheet, esp32 and google spreadsheet, current and voltage monitoring, power monitoring, ac voltage sensor, current transformer, ct clamp current sensor, split core transformer, electronic clinic, iot smart energy meter, iot, esp32, meter

Id: tJ1WnTRnnro

Length: 9min 35sec (575 seconds)

Published: Wed Aug 02 2023