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/1ehehmjDRfwE7DmCln4cgW4WG26HA1Jk0/view?usp=sharing

URls redirect Home Assistant:
https://my.home-assistant.io/redirect/oauth

GPIOD Repository:
https://github.com/jdeneef/ha_gpiod/

GPIO Configuration:
https://drive.google.com/file/d/1XGc1W0o7JibOc8p1T1w1_QWyHLKgLC3c/view?usp=sharing

Helper Data Sheet:
https://drive.google.com/file/d/1uaE2R-UVaGBECJsBauEtid1n6Z8c01p4/view?usp=sharing

Automation:
https://drive.google.com/file/d/1WJnPe66ZhYaDDKChoSTn7M5Kn1MmNBYF/view?usp=sharing

Others:
Hacs:
https://www.youtube.com/watch?v=Q8Gj0LiklRE
Gmail:
https://www.youtube.com/watch?v=IHKliqSFZvM
Telegram:
https://www.youtube.com/watch?v=HUzseE0gOqs

"Home Assistant" "Tutorial" "Micro Cut" "Numeric Helper" "Milliseconds" "Notification" "Automation" "Electric Power" "GPIOD" "Raspberry Pi" "Power outage" "Google Sheets"

Видео Logging power outages with Google Sheets and Home Assistant канала Progs Pont