[Feature request] - Advanced multi schedule management from external Google sheet

[jmcollin78]

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.

[jmcollin78]

A lot of great ideas.

[sleveille4]

doesn't this allow already to achieve what you are aiming for?:
https://github.com/nielsfaber/scheduler-component
+
https://github.com/nielsfaber/scheduler-card
it allows to create scheme and pilot either climate preset or T° target directly

from the spreadsheet you display, i'd say you need to create quite a few, but you can "group" them, then toggle wich group is active.

that is what i use, i have a normal group with per room weekdays / weekend schedule, then a 2nd group, guest with different per room weekdays / weekend schedules.

looks like you would have the same, just wih a 3rd group

from there, given you already retrieve wich mode you are supposed to be (teletravail / guest / holiday) from your json, you would just have to toggle the corrseponding schedule group