I’ve just gotten into home automation and I’m hooked, but unfortunately I never learned to code more than the most basic commands. I have a google sheet that is set up to automatically update the few stocks that I hold, and I’m wondering if there is any way to have google assistant/home read the daily change in price in real time? I would also love to be able to automate my cryptocurrency accounts the same way. Thank you to anyone that can offer assistance or point me in the right direction, or tell me that it’s impossible at this point.
I don’t think there is a HA component to do what you want out of the box but if you like tinkering around and learning new things there should be a way using a shell command to run a python script. Some reading recommendations I’d suggest:
Here is a topic where I described the process to write sensors’ values to a Google Sheet; just the opposite you’d like but maybe worth reading.
Here is a python3 library to manage Google Sheets.
PS: I don’t know if the process in my topic is still valid since I don’t use it anymore (I found out that Google sheets had a limit in the number of rows).