# \[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:** 18\ **Page:** 6
**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:** [November 1, 2024, 9:19am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/101 "2024-11-01T09:19:55Z")
Hi, Sometimes I get a bug in google sheets, where a new line does not start in the first colum. Every new line (in the image below) starts some +/-20 columns to the right. And the next line yet another +/-20columns to the right an so on. Does anyone has any idea what could be happening here? ![1-11-2024 10-15-34](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/3/d/3d28f87bd21ddf03809ef588e253f79b6a338c1b.png) ![1-11-2024 10-15-14](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/d/adaaaa8f4f8a5385d38aa13aefa5c51493998ef4.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:** [November 1, 2024, 10:52am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/102 "2024-11-01T10:52:29Z")
Often it comes when you have done something else on that sheet. Move that line to the beginning of the row. Place the cursor on the 1st cell to rest there. If you have put things on the richt site of the incoming data it can happend that you have to clear it first and replace it later. ---
**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:** [November 6, 2024, 6:49pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/103 "2024-11-06T18:49:09Z")
Thank you for your feedback. It did, however, not solve my problem. đŸ˜Ș ---
**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:** [November 6, 2024, 7:33pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/104 "2024-11-06T19:33:16Z")
Google Sheets is not really stable. One moment it’s works and for sometime good and then it’s very unstable. And why that is, is guessing. Here it’s “Rate Limited” error. One tabblad now and then, the 2nd tabblad get that error mostly. ---
**Author:** ![Eternity](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/eternity/32/102113_2.png) [@Eternity](https://community.homey.app/u/Eternity)\ **Post date:** [December 5, 2024, 11:54am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/105 "2024-12-05T11:54:45Z")
Google Sheets stopped working for me too. Was not aware of any issues, but all my flows which use Sheets show that since 19th November it has stopped working. I tried to repair from within the App, but that just shows a spinning wheel. ---
**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\ **Post date:** [December 5, 2024, 2:24pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/106 "2024-12-05T14:24:15Z")
There is another app for google sheets: > **[Easy Logger](https://homey.app/nl-nl/app/no.bwa.easy-logger/Easy-Logger/)** > > Logging and Data Collection Done Easy with Google API's ---
**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:** [February 28, 2025, 2:57pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/107 "2025-02-28T14:57:28Z")
Since a few days now, I cannot get the Google Sheets to work anymore. It used to work just fine for well over one year. Has anyone got a clue as to what the root cause could be for this “400 Bad Request” notice? Any help is appreciated! ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/8/d/8d8ca0bb1b4cf30e9040e3be0dbe4179b36aefb4.png) 97f8d4ed-6a00-45d4-a618-78c2bf9ce97a ---
**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:** [March 1, 2025, 11:40am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/108 "2025-03-01T11:40:52Z")
Issue solved. ---
**Author:** ![JorisS](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/joriss/32/47769_2.png) [@JorisS](https://community.homey.app/u/JorisS)\ **Post date:** [August 22, 2025, 7:15am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/109 "2025-08-22T07:15:52Z")
Is there already a solution for the “Missing token” issue? I ran into these problems myself this summer. (A built-in debug / log console would be great) ---
**Author:** ![JST1963](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jst1963/32/140722_2.png) [@JST1963](https://community.homey.app/u/JST1963)\ **Post date:** [September 1, 2025, 9:00pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/110 "2025-09-01T21:00:21Z")
Where do I find this settings? ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/e/f/ef2faecb5f0e10964dc1f1057b9f9a8cb09282df.png) ---
**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\ **Post date:** [September 1, 2025, 11:00pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/111 "2025-09-01T23:00:38Z")
Use EasyJet Logger, does the same: [Easy Logger App voor Homey | Homey](https://homey.app/nl-nl/app/no.bwa.easy-logger/Easy-Logger/) ---
**Author:** ![JST1963](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jst1963/32/140722_2.png) [@JST1963](https://community.homey.app/u/JST1963)\ **Post date:** [September 2, 2025, 10:45pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/112 "2025-09-02T22:45:36Z")
Robert, where can I find those parameters? I’m not convinced to use EasyJet Logger. Looks more complicated than needed ---
**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\ **Post date:** [September 3, 2025, 9:48pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/113 "2025-09-03T21:48:05Z")
I can’t get them to pop up as well (tried with laptop + Chrome browser). However, with a small extra step, this works: > [@Google sheets - Can't find my files](https://community.homey.app/t/google-sheets-cant-find-my-files/142533/2): > > Apparently you’re supposed enter the URL to the file yourself; > > How to get the URL: > In the mobile Spreadsheets app, you can copy the URL (or ‘Link’) by hitting the 3 dots next to the spreadsheet (this might work with Google drive as well): > > ![Screenshot_20250903_133215_Sheets](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/3/0/30e8ad28c176e2c3fb090fbe0f990cfdc0291c61.jpeg) > > Next, tap “copy link”: > > ![Screenshot_20250903_133411_Google](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/7/8/780bc6a6647446343d3d9429a16acf044975bb29.jpeg) > > Now paste that link into the “URL to document” field: > > ![Screenshot_20250903_133622_Chrome](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/e/d/edb04f9902fe97027bfbfb3ccf7aa3757f4f12e2.jpeg) > > If all went well, you can select the sheet to use: > > ![Screenshot_20250903_132458_Chrome](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/1/a1283f859ee08fbeacb885414e663827bad6f609.jpeg) ---
**Author:** ![Johan\_Taal](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/johan_taal/32/9807_2.png) [@Johan\_Taal](https://community.homey.app/u/Johan_Taal)\ **Post date:** [December 5, 2025, 7:08am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/114 "2025-12-05T07:08:42Z")
What was the solution? I have the same issue. ---
**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:** [February 2, 2026, 3:50pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/115 "2026-02-02T15:50:59Z")
I had a lot of data in the file, over different sheets. The theory was that something somewhere just couldn’t handle the vast amount of data. Now everything is splitted into different sheets. Works like a charm again, but less userfriendly than before. ---
**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:** [March 4, 2026, 9:28am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/116 "2026-03-04T09:28:04Z")
Hi , Can someone here help me with this function I want automate but can’t find the howto? I want to automatically multiply a variable with a value that is exactly one row up. So, when adding a line 649 on march 5th, I would like to have a value in the 3rd column that is the SUM of a variable (today’s kWh) and the (yesterday’s) value that is already present in column 3, 4th row. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/2/5/253c4587a1658093ba203f5613874cb57e85d330.png) Basically, summing up my daily energy consumption to obtain a total cumulated value. anyone? ---
**Author:** ![HomeyPS](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/homeyps/32/122561_2.png) [@HomeyPS](https://community.homey.app/u/HomeyPS)\ **Post date:** [August 9, 2026, 2:54pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/117 "2026-08-09T14:54:54Z")
We are working on our PC, have a Gmail address, the Google Sheets app is installed on Homey and we are logged in. Writing to Google Sheets was going well, but it stopped today. What should we do to get it working again? ---
**Author:** ![ReneO](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/reneo/32/3522_2.png) [@ReneO](https://community.homey.app/u/ReneO)\ **Post date:** [August 9, 2026, 8:22pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/118 "2026-08-09T20:22:48Z")
So Homey is writing to a Google Sheet? Do you get an error message in Homey if the flow is started manually? [Previous page](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101.md?page=5)