Since this week I’m using the Google Spreadsheet app to log the energy consumption on an hourly basis. However, when I open the result in Google Spreadsheets, the result is shown as text, because it looks like this; 123.45. Google sees this as a text, since the expected format is 123,45 (a comma instead of a dot). Is there a way to change the data output from Homey to Google Spreadsheets? The data is coming from the HomeWizard P1 meter (HomeWizard app).
This Link could be of some help.
you have to set the language of Sheets to English or US. Then you will see it as data not a tekst, you can change this in the settings of Sheets