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

Поделиться
HTML-код
  • Опубликовано: 1 авг 2023
  • 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 RUclips 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 11 месяцев назад +1

    Awesome project👍👍👍
    Thank you 🌹

  • @JohnTyroneAviles-hh4cz
    @JohnTyroneAviles-hh4cz 3 месяца назад

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

  • @PhG1961
    @PhG1961 11 месяцев назад +1

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

  • @martinchirwa3300
    @martinchirwa3300 6 месяцев назад

    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

  • @asyrafacap_
    @asyrafacap_ 3 месяца назад

    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.

  • @desilog7394
    @desilog7394 10 месяцев назад

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

  • @chandrurn
    @chandrurn 11 месяцев назад +1

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

    • @ElectroniClinic
      @ElectroniClinic  11 месяцев назад

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

  • @himansusekharpraharaj18
    @himansusekharpraharaj18 11 месяцев назад

    Awaiting for a article on Arduino based power factor correction❤

  • @wndmlr
    @wndmlr 7 месяцев назад

    Is there a version of this with cellular data transfer

  • @fa9649
    @fa9649 10 месяцев назад

    How can i display newest data is on top

  • @shrawanrao6467
    @shrawanrao6467 14 дней назад

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

  • @kazukied2
    @kazukied2 7 месяцев назад +1

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

  • @THARUNKSECE-B
    @THARUNKSECE-B 5 месяцев назад

    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 9 месяцев назад

    Hi, how can i order this project?

  • @JohnTyroneAviles-hh4cz
    @JohnTyroneAviles-hh4cz 3 месяца назад

    Do you have a code for the esp32

  • @ivanpanergaviola4103
    @ivanpanergaviola4103 2 месяца назад

    please give me the system flowchart of this one

  • @gavoelpapi
    @gavoelpapi 3 дня назад

    hola muchas greacias pero no me muestra resultados

  • @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?

  • @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.

  • @tangapranathi3976
    @tangapranathi3976 4 месяца назад

    is it possible to create simulation in proteus software

    • @ElectroniClinic
      @ElectroniClinic  4 месяца назад +1

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

  • @ivanpanergaviola4103
    @ivanpanergaviola4103 2 месяца назад

    the system flow chart please

  • @0124akash
    @0124akash Месяц назад

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

    • @ElectroniClinic
      @ElectroniClinic  Месяц назад

      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 3 месяца назад

    It doesn't show me any results

  • @user-bu2ph6cn7k
    @user-bu2ph6cn7k 3 месяца назад

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

  • @casianreport3318
    @casianreport3318 11 месяцев назад

    Where is the script?

  • @sathyansat7163
    @sathyansat7163 11 месяцев назад +1

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