Among the various things I am using Home Assistant for is viewing the stats from my WaterFurnace ground-source heat pump (aka residential “geothermal”).
There is an integration that reads a bunch of variables. And I can monitor both points in time and historical data via Home Assistant. After just a couple of days, I feel like I have a dramatically better understanding of how the system works.
However, I would like to export the data into some other format, most obviously a shared Google or Microsoft spreadsheet of some sort.
I see that there are tools for backup but what about writing sensor (and other, presumably) data?
Thanks. I think that I have the opposite problem. I want to WRITE to a file. Maybe the notifications do that, but the integration polls the server every 10 seconds, so I think it would be overkill to use notifications or that.
hm…yes, you’re right.
I just did a quick search and this was the recommendation I’ve found.
Another Idea could be to use something like node red.
This would allow you to read a sensors state in regular intervals - and do what ever you want with that information.
You can forward it to another application - or maybe, write into a file? (but I haven’t checked yet by myself)
Forwarding to Google Cloud, Google Drive or something similar would be perfect. Will take a look. Thanks. I didn’t know about Node Red, and it looks like a great tool.