#Google sheets based automations

1 messages · Page 1 of 1 (latest)

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?

coral nova
#

hmm ill look into that

#

thanks

coral nova
#

Omg this is so much easier and better in every way, Thank you SO much!