I would like to see an addon for one of the open source spreadsheet apps - don’t really care which one.
Would need some sort of configuration layer to link specific cells to sensors, helpers, events or other triggers in HA.
In the same way that the GUI deyamlifies automations and scripts, this would dejinjafy templates.
Also - in the same way NodeRed brings PLC programming skills into the HA ecosystem, this would bring in spreadsheet programming which is a much more widely held skill in society.
Wouldnt be usefull for calculating you budget, but opens a lot of template alternative options.
Looks like the Google Docs integration is for extracting data only - I was envisaging more of a bi-directional comms.
Eg. A sensor may report total solar generation while another reports total energy export.
The spreadsheet may have a list of energy consuming appliances, their total load, and an order of priority for which are most desirable to run if there is spare energy available.
The spreadsheet could then set a series of boolean outputs (linked to switches on the relevant appliance, or to trigger an automation to control the appliance) to switch on the most desirable set of appliances to most efficiently use the spare energy generation.
I’m sure this could also be accomplished by other means, but the point is to leverage spreadsheet skills for folk who may struggle with jinja.