[APP] Google Sheets - Append to Google Sheets from a Flow

Google Sheets

This discussion is started to centralize all Questions, Answers and Information around the the app.


This topic is not actively monitored by Athom. If you have issues with this app, please report it to support@athom.com, mentioning the version of the app + a good description of the issue.

Supported devices

  • Google Sheets User

App Contributors

The Philips Hue App is closed (not available on GitHub) but actively maintained by Athom.

Report Bugs for this App to the Developers

  • Please use the Link in the App Store and follow the community guidelines, the more info provided the faster it can be solved.

Forum Discussion

Initial Discussion created by @oh2th with info from the community. Ask any Moderator to add/update/correct this Discussion.

Google Sheets - Frequently Asked Questions


I saw the new app Google Sheets and I thought to export my energy use from my p1 dongel of home wizard.
I created a “device” and tried to make a flow.
In the then I can choose a flow card but then I have to choose an item but there are no results for items. Obviously I am on the wrong track. Can some share a flow so I can see how to do this?

Did you create a Google sheet to which it can append data?

Yes I did:

Did you also tick these two boxes when creating the Google Sheets User device?

1 Like

I overlooked this totally :flushed:
Thank you very much for your quick support.
This open ups a lot of possibilities. :+1:

1 Like

Can’t Athom make this app open source? It is obviously early in the development but I think it can spin off to numerous good apps. Logging for example.

Great App! Thanks!

In a Homey flow I calculate a value and round this to 2 digits. This value than is uploaded to a Google Sheet with the time stamp. Works great.

The value is added as text, not a number. How can I set the uploaded value to a number?


Isn’t that something you configure in the sheet?

Unfortunately, it is not possible to calculate with the value despite changing it to a numerical value. A formula, e.g. calculation of an average value, ends with an error message.
It would be great if there was an option to send the value as a number or as text.
The problem is that a number is sent with a point as a separator. As soon as a comma is entered manually, the calculations also work.

I’ve set the Country setting for the sheet to “United States”, so it accepts a period as decimal separator:

Clever Robert!

I will try that too!

I tried to find this but where to adjust

These settings don’t let me calculate.

“Bestand > Instellingen > Landinstelling”

Probably on a PC in Excel? I am working almost always on my iPad, so I have to search for my laptop then :wink:

1 Like

Found it. Thanks for your help again. (It was not in the app sheets but web based)

Works for me @robertklep!
Great tip!

Trying to write values to a sheet, and it works fine. Found that I can append several values to several columns in one row by using a “;” to separate the columns. I do have however a value that contains exactly this character, and it is being split up into two columns - and that is not optimal :wink:
Anyone know how to “mark it as one string”? I have tried with " and [ and { with no luck. No matter what I do, if the field contains a ; it will be split up.

1 Like