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

  Переглядів 16,755

Electronic Clinic

Electronic Clinic

9 місяців тому

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/yt/electronicl...
Altium 365:
www.altium.com/altium-365
Octopart, components search engine:
octopart.com/
Download the Circuit diagram and programming:
www.electroniclinic.com/iot-b...
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 UKposts 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.com/product-1486....
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.electroniclinic.com/
Programming Digest:
programmingdigest.com/
Follow me on Instagram:
/ electroniclinic
Follow my Facebook Page Electronic Clinic:
web. profile.php?...
Follow my Facebook Group, Arduino Projects:
/ 190031841821771
Email:
stu_engineering@yahoo.com
#energymeter #iotproject #altiumdesigner

КОМЕНТАРІ: 34
@shakerileiwat4341
@shakerileiwat4341 9 місяців тому
Awesome project👍👍👍 Thank you 🌹
@himansusekharpraharaj18
@himansusekharpraharaj18 9 місяців тому
Awaiting for a article on Arduino based power factor correction❤
@PhG1961
@PhG1961 9 місяців тому
Really awesome! Your contribution to the internet/UKposts community is epic!
@desilog7394
@desilog7394 7 місяців тому
Is that possible I want to show readings on my react native app like u showing on Google sheet
@chandrurn
@chandrurn 9 місяців тому
That's awesome project, please demonstrate similar project with Hx711 and Google sheets, that will be most appreciated 👍
@ElectroniClinic
@ElectroniClinic 9 місяців тому
Next video is on iot based weighing scale. Its a long series on hx711 and energy meters.
@martinchirwa3300
@martinchirwa3300 4 місяці тому
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
@JohnTyroneAviles-hh4cz
@JohnTyroneAviles-hh4cz Місяць тому
Thank you for having this kind of content. It really helping us for some projects just like this
@fa9649
@fa9649 7 місяців тому
How can i display newest data is on top
@wndmlr
@wndmlr 4 місяці тому
Is there a version of this with cellular data transfer
@aminarry1823
@aminarry1823 7 місяців тому
Hi, how can i order this project?
@hajsandeepa4332
@hajsandeepa4332 7 місяців тому
can we directly get the usage data to a our own database?
@ElectroniClinic
@ElectroniClinic 7 місяців тому
Yes. You can watch my videos on vb.net desktop application designing.
@asyrafacap_
@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.
@kazukied2
@kazukied2 5 місяців тому
That's such a weird voltage. What country are you in?
@THARUNKSECE-B
@THARUNKSECE-B 3 місяці тому
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
@ivanpanergaviola4103 14 днів тому
please give me the system flowchart of this one
@JohnTyroneAviles-hh4cz
@JohnTyroneAviles-hh4cz Місяць тому
Do you have a code for the esp32
@shivufpv6248
@shivufpv6248 6 місяців тому
Hi without oning the laptop they data's will be stored in the goggle sheets?
@ElectroniClinic
@ElectroniClinic 6 місяців тому
Yes
@shivufpv6248
@shivufpv6248 6 місяців тому
This code will work even for dc voltage and current sensor module?
@ivanpanergaviola4103
@ivanpanergaviola4103 10 днів тому
the system flow chart please
@tangapranathi3976
@tangapranathi3976 Місяць тому
is it possible to create simulation in proteus software
@ElectroniClinic
@ElectroniClinic Місяць тому
You will need to find the models. If the models are available then you can make the simulation.
@casianreport3318
@casianreport3318 9 місяців тому
Where is the script?
@ElectroniClinic
@ElectroniClinic 9 місяців тому
Link is in the description
@sathyansat7163
@sathyansat7163 8 місяців тому
I tried this project ,but no data is generating in google sheet, may be anything wrong in scripts. Can you help.
@gobeeselvaratnam707
@gobeeselvaratnam707 3 місяці тому
did you find out anything?
@user-bu2ph6cn7k
@user-bu2ph6cn7k Місяць тому
It doesn't show me any results
@user-bu2ph6cn7k
@user-bu2ph6cn7k Місяць тому
لا تضهر لي نتائج
13 Brilliant IoT Projects!!! (2024 Edition)
10:25
ToP Projects Compilation
Переглядів 70 тис.
Піхотинці - про потребу у людях
00:57
Суспільне Новини
Переглядів 607 тис.
когда одна дома // EVA mash
00:51
EVA mash
Переглядів 9 млн
одни дома // EVA mash @TweetvilleCartoon
01:00
EVA mash
Переглядів 4,9 млн
Monitoring  House Power Consumption with ESP32 and Shelly Power Meter
8:39
Iot based electricity theft detection system
6:13
Tiny Tech Electronics
Переглядів 22 тис.
IoT AC Energy Meter using ESP32, HMI Display & Blynk
11:38
How To Electronics
Переглядів 3,8 тис.
Send Data from NodeMCU to Google Sheets
5:01
thatiotguy
Переглядів 61 тис.
Making an Energy Monitoring System
7:17
Alija Bobija
Переглядів 21 тис.
DIY ESP32 AC Power Meter (with Home Assistant/Automation Integration)
10:58
Broken Trace Repair #electronics #mobilerepair
0:51
ideal institute aligarh
Переглядів 470 тис.
iPhone - телефон для нищебродов?!
0:53
ÉЖИ АКСЁНОВ
Переглядів 3,7 млн
Result of the portable iPhone electrical machine #hacks
1:01
KevKevKiwi
Переглядів 7 млн