coral nova
Hey, I need to make an automation based on google sheets or something like that.
In the google sheets there would be dates and time. I want HA to take the date and time minus 1 hour and trigger a smart plug. Is that somehow possible?
I have successfully read cell info in NodeRed, but that's about it, idk how to go from there.
stone breach
Google Sheets a requirement? Could you consider a local/Google calendar instead?
You can have offsets to calendar triggers: https://www.home-assistant.io/docs/automation/trigger/#calendar-trigger
coral nova
Omg this is so much easier and better in every way, Thank you SO much!