Sheets has an APi so you can just POST values straight into a sheet from HA using https://home-assistant.io/components/rest_command/
See https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append
Sheets has an APi so you can just POST values straight into a sheet from HA using https://home-assistant.io/components/rest_command/
See https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append