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

  Рет қаралды 20,686

Electronic Clinic

Electronic Clinic

Жыл бұрын

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 KZfaq 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

Пікірлер: 40
@shakerileiwat4341
@shakerileiwat4341 Жыл бұрын
Awesome project👍👍👍 Thank you 🌹
@JohnTyroneAviles-hh4cz
@JohnTyroneAviles-hh4cz 4 ай бұрын
Thank you for having this kind of content. It really helping us for some projects just like this
@PhG1961
@PhG1961 Жыл бұрын
Really awesome! Your contribution to the internet/KZfaq community is epic!
@martinchirwa3300
@martinchirwa3300 7 ай бұрын
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
@shrawanrao6467
@shrawanrao6467 Ай бұрын
How to measure the power factor,is the formula base?
@himansusekharpraharaj18
@himansusekharpraharaj18 Жыл бұрын
Awaiting for a article on Arduino based power factor correction❤
@chandrurn
@chandrurn Жыл бұрын
That's awesome project, please demonstrate similar project with Hx711 and Google sheets, that will be most appreciated 👍
@ElectroniClinic
@ElectroniClinic Жыл бұрын
Next video is on iot based weighing scale. Its a long series on hx711 and energy meters.
@asyrafacap_
@asyrafacap_ 4 ай бұрын
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.
@wndmlr
@wndmlr 7 ай бұрын
Is there a version of this with cellular data transfer
@desilog7394
@desilog7394 10 ай бұрын
Is that possible I want to show readings on my react native app like u showing on Google sheet
@fa9649
@fa9649 10 ай бұрын
How can i display newest data is on top
@kazukied2
@kazukied2 8 ай бұрын
That's such a weird voltage. What country are you in?
@gavoelpapi
@gavoelpapi 20 күн бұрын
hola muchas greacias pero no me muestra resultados
@THARUNKSECE-B
@THARUNKSECE-B 6 ай бұрын
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
@aminarry1823
@aminarry1823 10 ай бұрын
Hi, how can i order this project?
@JohnTyroneAviles-hh4cz
@JohnTyroneAviles-hh4cz 4 ай бұрын
Do you have a code for the esp32
@ivanpanergaviola4103
@ivanpanergaviola4103 3 ай бұрын
please give me the system flowchart of this one
@tangapranathi3976
@tangapranathi3976 4 ай бұрын
is it possible to create simulation in proteus software
@ElectroniClinic
@ElectroniClinic 4 ай бұрын
You will need to find the models. If the models are available then you can make the simulation.
@hajsandeepa4332
@hajsandeepa4332 10 ай бұрын
can we directly get the usage data to a our own database?
@ElectroniClinic
@ElectroniClinic 10 ай бұрын
Yes. You can watch my videos on vb.net desktop application designing.
@shivufpv6248
@shivufpv6248 9 ай бұрын
Hi without oning the laptop they data's will be stored in the goggle sheets?
@ElectroniClinic
@ElectroniClinic 9 ай бұрын
Yes
@shivufpv6248
@shivufpv6248 9 ай бұрын
This code will work even for dc voltage and current sensor module?
@ivanpanergaviola4103
@ivanpanergaviola4103 3 ай бұрын
the system flow chart please
@0124akash
@0124akash 2 ай бұрын
Tomorrow I will work on it. But zmpt voltage range is max 260V how to measure above 260V, sir.
@ElectroniClinic
@ElectroniClinic 2 ай бұрын
why above 260V? its more than enough.
@0124akash
@0124akash Ай бұрын
@@ElectroniClinic there is 280-290V is comming many time. That's why I am making this project.
@user-bu2ph6cn7k
@user-bu2ph6cn7k 4 ай бұрын
لا تضهر لي نتائج
@user-bu2ph6cn7k
@user-bu2ph6cn7k 4 ай бұрын
It doesn't show me any results
@casianreport3318
@casianreport3318 Жыл бұрын
Where is the script?
@ElectroniClinic
@ElectroniClinic Жыл бұрын
Link is in the description
@sathyansat7163
@sathyansat7163 11 ай бұрын
I tried this project ,but no data is generating in google sheet, may be anything wrong in scripts. Can you help.
@gobeeselvaratnam707
@gobeeselvaratnam707 6 ай бұрын
did you find out anything?
@gavoelpapi
@gavoelpapi 20 күн бұрын
hola no me muestra resultados por que?
ESP8266 RFID Attendance System with Google Sheets
9:39
Viral Science - The home of Creativity
Рет қаралды 12 М.
Опасность фирменной зарядки Apple
00:57
SuperCrastan
Рет қаралды 12 МЛН
ПРОВЕРИЛ АРБУЗЫ #shorts
00:34
Паша Осадчий
Рет қаралды 7 МЛН
Каха заблудился в горах
00:57
К-Media
Рет қаралды 10 МЛН
IoT AC Energy Meter using ESP32, HMI Display & Blynk
11:38
How To Electronics
Рет қаралды 6 М.
IoT Based Smart Electricity Energy Meter using ESP8266 & Blynk Application
9:39
12 Mind-Blowing ESP32 Projects to try in 2024!
8:50
ToP Projects Compilation
Рет қаралды 77 М.
13 Brilliant IoT Projects!!! (2024 Edition)
10:25
ToP Projects Compilation
Рет қаралды 114 М.
Stop, Intel’s Already Dead!
13:47
Linus Tech Tips
Рет қаралды 770 М.
Making an Energy Monitoring System
7:17
Alija Bobija
Рет қаралды 24 М.
Monitoring  House Power Consumption with ESP32 and Shelly Power Meter
8:39
I tried the Cheapest Arduino Alternative (that Nobody heard of)
13:31
Ba Travel Smart Phone Charger
0:42
Tech Official
Рет қаралды 1,2 МЛН