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

Apps
,
1

Google Sheets

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

Note:

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.

2

Google Sheets - Frequently Asked Questions

(reserved)

3

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?

image
image2048Ă—1536 147 KB

4

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

5

Yes I did:

image
image2048Ă—1536 142 KB

6

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

Screenshot 2023-01-15 at 11.47.07
Screenshot 2023-01-15 at 11.47.07854Ă—302 26 KB

1 Like
7

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

1 Like
8

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.

9

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?

Thanks

10

Isn’t that something you configure in the sheet?

11

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.

12

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

13

Clever Robert!

I will try that too!

14

I tried to find this but where to adjust

image
image2048Ă—1536 228 KB

image
image2048Ă—1536 193 KB

These settings don’t let me calculate.

15

“Bestand > Instellingen > Landinstelling”

16

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

17

image
image786Ă—1444 77.4 KB

1 Like
18

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

19

Works for me @robertklep!
Great tip!

20

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