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

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
www.altium.com...
Altium 365:
www.altium.com...
Octopart, components search engine:
octopart.com/
Download the Circuit diagram and programming:
www.electronic...
Related Videos:
Arduino-based Home Energy Monitor
• Arduino Home Energy Mo...
ZMPT101b AC Voltage Sensor with Arduino
• ZMPT101B 250V AC Volta...
LoRa Energy Meter using Arduino,:
• LoRa Energy Meter usin...
How to design and Make yourself Arduino Development Board using Altium Designer
• Arduino LoRa Developme...
Support me on Patreon and get access to hundreds of projects:
/ electroniclinic
Subscribe to my New KZbin Channel, if you want to watch my videos in Hindi/Urdu
/ @letsgetstartedd
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:
amzn.to/3v40DkE
CT Clamp Current Sensor
amzn.to/46AEEQu
CT Clamp Current Sensor from the DFrobot:
www.dfrobot.co...
ZMPT101b AC Voltage Sensor
amzn.to/3PGvyM2
Other must-have Tools and Components:
Arduino Uno, Nano, Mega, Micro "All types of Arduino Boards":
amzn.to/3fk5OTi
Top Arduino Sensors:
amzn.to/3vZbnfM
Super Starter kit for Beginners
amzn.to/3cq56C5
Top Oscilloscopes
amzn.to/3ctF3d8
Top Soldering iron kits: "best"
amzn.to/39nqDtb
3D printers:
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:
www.electronic...
Programming Digest:
programmingdig...
Follow me on Instagram:
/ electroniclinic
Follow my Facebook Page Electronic Clinic:
web.facebook.c...
Follow my Facebook Group, Arduino Projects:
/ 190031841821771
Email:
[e-mail]
#energymeter #iotproject #altiumdesigner

[@PhG1961]

Really awesome! Your contribution to the internet/KZbin community is epic!

[@JohnTyroneAviles-hh4cz]

Thank you for having this kind of content. It really helping us for some projects just like this

[@chandrurn]

That's awesome project, please demonstrate similar project with Hx711 and Google sheets, that will be most appreciated 👍

[@ElectroniClinic]

Next video is on iot based weighing scale. Its a long series on hx711 and energy meters.

[@kazukied2]

That's such a weird voltage. What country are you in?

[@shakerileiwat4341]

Awesome project👍👍👍 Thank you 🌹

[@asyrafacap_]

Hi Sir, im beginner in electronic. Just want to ask, is this project is measuring main electric bill or just a load that we attach the CT sensor? Can i also attach the CT sensor at main panel of my electric house to measure my bill for a month? Thanks in advance for your answer.

[@himansusekharpraharaj18]

Awaiting for a article on Arduino based power factor correction❤

[@shrawanrao6467]

How to measure the power factor,is the formula base?

[@martinchirwa3300]

Sir is it possible to receive that sensor data from anywhere around the world ? Or you need to be close to the esp board to get that sensor data since it uses wifi that covers a short distance

[@wndmlr]

Is there a version of this with cellular data transfer

[@desilog7394]

Is that possible I want to show readings on my react native app like u showing on Google sheet

[@THARUNKSECE-B]

Bro i want to connect this with a server and a billing app with 1 month reading. How can i proceed plz ? Help me bro

[@ivanpanergaviola4103]

please give me the system flowchart of this one

[@0124akash]

Tomorrow I will work on it. But zmpt voltage range is max 260V how to measure above 260V, sir.

[@ElectroniClinic]

why above 260V? its more than enough.

[@0124akash]

@@ElectroniClinic there is 280-290V is comming many time. That's why I am making this project.

[@JohnTyroneAviles-hh4cz]

Do you have a code for the esp32

[@tangapranathi3976]

is it possible to create simulation in proteus software

[@ElectroniClinic]

You will need to find the models. If the models are available then you can make the simulation.

[@mdhamza3636]

Hey, have you do this?

[@hajsandeepa4332]

can we directly get the usage data to a our own database?

[@ElectroniClinic]

Yes. You can watch my videos on vb.net desktop application designing.

[@fa9649]

How can i display newest data is on top

[@ivanpanergaviola4103]

the system flow chart please

[@shivufpv6248]

Hi without oning the laptop they data's will be stored in the goggle sheets?

[@ElectroniClinic]

Yes

[@shivufpv6248]

This code will work even for dc voltage and current sensor module?

[@aminarry1823]

Hi, how can i order this project?

[@gavoelpapi]

hola muchas greacias pero no me muestra resultados

[@ايهابسلامنور]

It doesn't show me any results

[@ايهابسلامنور]

لا تضهر لي نتائج

[@sathyansat7163]

I tried this project ,but no data is generating in google sheet, may be anything wrong in scripts. Can you help.

[@gobeeselvaratnam707]

did you find out anything?

[@gavoelpapi]

hola no me muestra resultados por que?

[@casianreport3318]

Where is the script?

[@ElectroniClinic]

Link is in the description