Welcome to HA forum!
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).