[Feature request] - Advanced multi schedule management from external Google sheet #792
Description
Discussed in #785
Originally posted by cedricbarbecue January 6, 2025
Hello,
I just discovered this great integration this morning.
I don't really know how or why but I didn't come across it several months ago when I decided to switch from Netatmo to SONOFF TRV zigbee with full management via HA.
Not having found an integration for my needs, I did it myself via a few automations.
I find almost everything I want in "versatille thermostat" except the "simple" management of a complex schedule (an idea that comes directly from what the Netatmo app offers).
I took the time to read your documentation but I have the feeling that it is not possible via "versatille thermostat"
I need/want to be able to manage three schedules (work/in_holiday/friends_at_home) to set the target temperatures according to the rooms (13), times and days.
Having a good knowledge of Google Sheets, I host my schedules on a sheet that I convert into a large json that I retrieve as a sensor via the HA REST integration. Then I send the different schedules to my valves.
Afterwards, my algorithms are quite simple and clearly less advanced than what "versatille thermostat" offers.
In any case, my boiler self-regulates "a little by itself" and the heating is already much better managed than via my previous Netatmo configuration.
In short, is it planned to one day be able to integrate this type of schedule management into the integration instead of the "scheduler" integration which does not really allow the same thing ?
By the way, do you have any ideas so that I can do without my Google Sheet? I haven't found anything very practical for storing table-type data.