# \[APP\] Google Sheets - Append to Google Sheets from a Flow **URL:** \ **Category:** Apps\ **Tags:** app, official\ **Created:** [March 26, 2024, 5:03am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101 "2024-03-26T05:03:31Z")\ **Posts on this page:** 20\ **Page:** 4
**Author:** ![Jack\_withCK](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jack_withck/32/151933_2.png) [@Jack\_withCK](https://community.homey.app/u/Jack_withCK)\ **Post date:** [March 25, 2024, 6:49am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/61 "2024-03-25T06:49:28Z")
I have the same issue, came here to see if I was doing something wrong because I only just installed the app. ---
**Author:** ![OH2TH](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/oh2th/32/111414_2.png) [@OH2TH](https://community.homey.app/u/OH2TH)\ **Post date:** [March 25, 2024, 9:02am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/62 "2024-03-25T09:02:49Z")
Since the app is developed by Athom, you should open a ticket to support. ---
**Author:** ![Marius\_Stensrod](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/marius_stensrod/32/56540_2.png) [@Marius\_Stensrod](https://community.homey.app/u/Marius_Stensrod)\ **Post date:** [March 26, 2024, 9:47am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/63 "2024-03-26T09:47:37Z")
> [@John\_Andersen](#): > > I’m the only one having this issue? The old flow card is deprecated, in that new one you enter the URL for the document. Open the Google sheets document in a browser and copy paste the adress (the hint in what you need is in the box, with greyed out text). After you have done that, you can click on “sheet” and you get a dropdown menu for the different sheets in the document. ---
**Author:** ![OH2TH](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/oh2th/32/111414_2.png) [@OH2TH](https://community.homey.app/u/OH2TH)\ **Post date:** [March 26, 2024, 9:54am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/64 "2024-03-26T09:54:17Z")
Support responded with: > Unfortunately we had to make some adjustments to the Google Sheets app after a notification from Google that we aren’t allowed to use the readonly scope in the Google API. > > We know this is a step back in the usability of the app, but Google made us do this. ---
**Author:** ![Jan\_Peeters](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jan_peeters/32/86660_2.png) [@Jan\_Peeters](https://community.homey.app/u/Jan_Peeters)\ **Post date:** [May 29, 2024, 12:39pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/65 "2024-05-29T12:39:51Z")
> [@OH2TH](#): > > copy paste the adress Hmm, I suppose not to many active users for this app? Is there any reason why just copying the address of the sheet (URL) would not work? Here, the tabs are not showing up; the app has no contact with the sheet behind the link. Or have I used the wrong URL? ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/c/a/cace2577387945e30703f461e70343f6a5576444.png) ---
**Author:** ![Hielke\_de\_Jong](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/hielke_de_jong/32/79029_2.png) [@Hielke\_de\_Jong](https://community.homey.app/u/Hielke_de_Jong)\ **Post date:** [May 29, 2024, 12:49pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/66 "2024-05-29T12:49:41Z")
Maybe you copied also some not visible characters? Like a return. Maybe check it bij copying it from the card and then paste in browser ---
**Author:** ![Jan\_Peeters](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jan_peeters/32/86660_2.png) [@Jan\_Peeters](https://community.homey.app/u/Jan_Peeters)\ **Post date:** [May 29, 2024, 12:57pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/67 "2024-05-29T12:57:20Z")
Thank you, but no. It seems the app has lost the ability to connect to my google account. I deleted the existing “device” and tried to add anew. With the below result. My guess is that might be an issue with the app. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/c/0c216e8317276471346551dd04bdc4c95ba0f6c7.png) This was basically the before last reason why I keep my Homey. Now anything except “Flows” is literally better in HomeAssistant. ---
**Author:** ![Jan\_Peeters](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jan_peeters/32/86660_2.png) [@Jan\_Peeters](https://community.homey.app/u/Jan_Peeters)\ **Post date:** [May 29, 2024, 3:25pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/68 "2024-05-29T15:25:28Z")
When creating a new “device”, I see a google login screen popping up. I can select the account and I am able to login. Once klicked on “next”, the popup screen goes away and the left screen stays on “Please log in on the …” Until the timeout message. Anyone? ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/e/8/e855400b77ae985337f3c93e702bbdfcc65ee040.png) ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/9/0955ad59be5bbbf5d63db93e34a55b1d1dd13ee8.png) ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/8/c/8cd802a86fb5f8b4d2bfd6bf84906c73e421f436.png) ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/1/3/1301053fe01883e7c476955a28959de2d76da206.png) ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/1/b/1bea7bb6d1ced2c1a9b85d88a00c7b3ee5a5408d.png) ---
**Author:** ![Jan\_Peeters](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jan_peeters/32/86660_2.png) [@Jan\_Peeters](https://community.homey.app/u/Jan_Peeters)\ **Post date:** [May 29, 2024, 6:19pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/69 "2024-05-29T18:19:30Z")
I Guess it is a known issue … that still isn’t fixed in 11.1.0-RC3 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/6/b/6b794d881b674198fe808486413498b8b8637237.png) ---
**Author:** ![Hielke\_de\_Jong](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/hielke_de_jong/32/79029_2.png) [@Hielke\_de\_Jong](https://community.homey.app/u/Hielke_de_Jong)\ **Post date:** [May 31, 2024, 8:08am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/70 "2024-05-31T08:08:02Z")
Not everything with Google is the connection with Google-assistant. Connecting to Google-drive is not a part of the Assistant. What you can try is to remove the connection between Google and Homey on the side of Google ([Manage connections between your Google Account and third-parties - Google Account Help](https://support.google.com/accounts/answer/13533235?hl=en)). Maybe on that side something is not correct causing this behaviour. ---
**Author:** ![Jan\_Peeters](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jan_peeters/32/86660_2.png) [@Jan\_Peeters](https://community.homey.app/u/Jan_Peeters)\ **Post date:** [May 31, 2024, 11:55am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/71 "2024-05-31T11:55:55Z")
Thank you. Your feedback is appreciated. The correct link to remove the link between both is [this one](https://myaccount.google.com/connections?continue=https%3A%2F%2Fmyaccount.google.com%2Fsecurity%3Fhl%3Den%26utm_source%3DOGB%26utm_medium%3Dact&hl=en&utm_source=OGB&utm_medium=act). The below screen only popped up because this access was deactivated (device removed, link removed). Though your reply contained valuable information, it isn’t specifically linked to my request above. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/3/2/32fc4949279d2328d19d0f9c11e7e066db3bb87d.png) ---
**Author:** ![Hielke\_de\_Jong](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/hielke_de_jong/32/79029_2.png) [@Hielke\_de\_Jong](https://community.homey.app/u/Hielke_de_Jong)\ **Post date:** [May 31, 2024, 4:11pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/72 "2024-05-31T16:11:04Z")
Google needs permission for using sheets. Needed rights are: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/6/f/6f6a0b7b6e719596a95f544f79f8d52e93f627a1.png) For Google assistant you need other rights. If the access to Sheets is activated, only thing you need is the URL of the sheet. Also then there is no need to add a new-device for the sheet (as you can use as many sheets you want and this is not one per device). So maybe there is a hick-up between your account and the access you need. In that case probably best to make sure your account does not have that permission anymore. ---
**Author:** ![Jan\_Peeters](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jan_peeters/32/86660_2.png) [@Jan\_Peeters](https://community.homey.app/u/Jan_Peeters)\ **Post date:** [May 31, 2024, 7:11pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/73 "2024-05-31T19:11:02Z")
> [@Hielke\_de\_Jong](#): > > you need other rights OK, thank you. So if I understand this correctly, being stuck at the below screen when creating a google sheets device is an indication of missing access rights? i must say I find this very unlickely, but I will dig into this. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/b/0b1a5de2be9828322409ba8bd083303150cbc711.png) _Edit_ In the access rights, Google sheets isn’t even mentioned. Which makes sense since the Google Sheets App in Homey is stuck at the login screen (see the above). ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/f/d/fd94aa66ac193c45e3898acf66889ab491f73436.png) ---
**Author:** ![Hielke\_de\_Jong](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/hielke_de_jong/32/79029_2.png) [@Hielke\_de\_Jong](https://community.homey.app/u/Hielke_de_Jong)\ **Post date:** [May 31, 2024, 7:32pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/74 "2024-05-31T19:32:01Z")
I did not say or even suggest that missing rights is the problem. I just asked you to check. This because adding the device is only setting the necessary rights for the service. As you already had those before it was something you could check. ---
**Author:** ![Marius\_Stensrod](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/marius_stensrod/32/56540_2.png) [@Marius\_Stensrod](https://community.homey.app/u/Marius_Stensrod)\ **Post date:** [May 31, 2024, 7:54pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/75 "2024-05-31T19:54:37Z")
Since you replied to my post, i think that i can reply, even tho you don’t have any question for me. I have tried to delete the GoogleSheets component in my Homey, added the Google Sheets component again. Copied the URL for the document, selected the proper sheet. I do not know what is going on in your end. ---
**Author:** ![Jan\_Peeters](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jan_peeters/32/86660_2.png) [@Jan\_Peeters](https://community.homey.app/u/Jan_Peeters)\ **Post date:** [June 1, 2024, 6:21pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/76 "2024-06-01T18:21:26Z")
Thank you everybody. Much obliged. I have it up and running now. Full disclosure: Athom’s answer to the timeout errror message (Post 67). Epic. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/8/f/8f396ab53f9038d9785851d5be5bab8db399ccc9.png) ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [June 29, 2024, 6:30pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/77 "2024-06-29T18:30:28Z")
First I was looking for this app to use it as a data array possibility. Sadly you could not read back. Then I realise that I could use it for a problem I had with rounding off numbers. Because I needed to compare lot of data in a time line. If you calculated that in two time frames, quarters and hours, you may not find big rounding differences. After learning first how this app needed to work, I found my thinking flaw. _In the future I shall use this tool more._ You can put a lot of data in one place to see the connection, or the lack off, better. Now I use formulas to see the results and I have to track them down. Then I try not to come be need the last row but still the next line is starting some times not on the beginning of the next row any more. For now it’s not a problem maybe later it is. ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [July 8, 2024, 11:01am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/78 "2024-07-08T11:01:03Z")
Have someone also get a email from Google Clouds. That the free periode will ended over 7 days. Then you work is lost. They want that you activated the full account. Then a lot of text where I can’t find what the price Google Sheet is and what you can do then. ---
**Author:** ![Hielke\_de\_Jong](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/hielke_de_jong/32/79029_2.png) [@Hielke\_de\_Jong](https://community.homey.app/u/Hielke_de_Jong)\ **Post date:** [July 8, 2024, 11:19am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/79 "2024-07-08T11:19:22Z")
My guess would be it is in relation with [Google Services App voor Homey | Homey](https://homey.app/nl-nl/app/nl.qluster-it.GoogleServices/Google-Services/) not for Google Sheets. ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [July 8, 2024, 11:35am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/80 "2024-07-08T11:35:51Z")
That app I don’t use. Google Sheet now for a few days and I love it. Losing the data is not the problem now because it did the job by a flow problem. That is what I hope to do a next time if needed. If you can have only one free periode, then the app is useless. [Previous page](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101.md?page=3) [Next page](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101.md?page=5)