Logging power outages with Google Sheets and Home Assistant
In the previous video, we created an automation to receive an email every time there is a power outage, but this didn't allow us to get a comprehensive picture of the service quality.
For this reason, we added a log of all power status changes. We do this using Google Sheets; to do this, we modified the automation.
In this video, we also show how to configure the Gmail and Google Sheets APIs.
We also emphasize that to manage these events with our Raspberry Pi, its power supply must not be affected by power failures, we got it with a UPS before the power supply, or with a battery on the DC side.
We thank @FBASD01 for pointing out that this was not reflected in the previous video.
hardware:
Raspberry pi 4 or 5 powered by UPS or battery power supply.
Relay with 230V AC coil
Cable with plug to power the relay coil
2 cables with connector for Raspberry GPIOs
Software:
Home Assistant
Inside Home Assistant
HACS
File editor
Electrical diagram:
https://drive.google.com/file/d/1eheh...
URls redirect Home Assistant:
https://my.home-assistant.io/redirect...
GPIOD Repository:
https://github.com/jdeneef/ha_gpiod/
GPIO Configuration:
https://drive.google.com/file/d/1XGc1...
Helper Data Sheet:
https://drive.google.com/file/d/1uaE2...
Automation:
https://drive.google.com/file/d/1WJnP...
Others:
Hacs:
• HACS Setup Guide That Actually Works | Hom...
Gmail:
• How To send e-mail PERFECTLY using Gmail i...
Telegram:
• Envía notificaciones de Home Assistant con...
"Home Assistant" "Tutorial" "Micro Cut" "Numeric Helper" "Milliseconds" "Notification" "Automation" "Electric Power" "GPIOD" "Raspberry Pi" "Power outage" "Google Sheets"