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

**URL:** <https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101>\
**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:** 3

<div class="post-metadata">

**Author:** ![mull](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/mull/32/3530_2.png) [@mull](https://community.homey.app/u/mull)\
**Post date:** [June 19, 2023, 12:09pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/41 "2023-06-19T12:09:43Z")

</div>

Hurray! Finally got it to work using BLL. Thanks for the help Arie. Much obliged.

Up until now I managed a little workaround. A script that checks if new data is added and then adds date/time/whatever to a chosen column.

The data from Homey gets logged into “Blad3” (Swedish for _Sheet 3_) and then imported to “Blad4” via ImportRange.

Why duplicate everything by using ImportRange? Because I suspect the trigger OnEdit doesn’t work when data is added through external sources - but it works with ImportRange. Hence linking column A from Blad3 to column A in Blad4 by: =IMPORTRANGE(“http-URL-to-sheet”; “Blad3!A:A”)

In Sheets (Extensions/Apps Script) I (well ok, ChatGPT) then added:

> function onEdit(e) {  
> var sheet = e.range.getSheet();  
> var editedCell = e.range;
> 
> // Check if a new value is added in column A  
> if (sheet.getName() === ‘Blad4’ && editedCell.getColumn() === 1 && editedCell.getRow() \> 1 && editedCell.getValue() !== ‘’) {  
> var newRow = editedCell.getRow();  
> var timestampRange = sheet.getRange(‘G’ + newRow);  
> var date = new Date();  
> var timestamp = Utilities.formatDate(date, ‘GMT’, ‘YYYY-MM-dd HH.mm.ss’);  
> timestampRange.setValue(timestamp);  
> }  
> }

Anywho, it’s all moot now that the BLL formatting works. Sweet! 😍

---

<div class="post-metadata">

**Author:** ![Walter\_vande\_kerkhof](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/walter_vande_kerkhof/32/28963_2.png) [@Walter\_vande\_kerkhof](https://community.homey.app/u/Walter_vande_kerkhof)\
**Post date:** [July 13, 2023, 8:24pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/42 "2023-07-13T20:24:26Z")

</div>

Using the app for over a month now to write my p1 meter values to a google sheet. I run the flow every hour. Noticed that, although the flow runs every hour, sometimes the values aren’t logged into the google sheet. Anyone recognize this and have a clue how to solve this?

---

<div class="post-metadata">

**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:** [July 13, 2023, 11:37pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/43 "2023-07-13T23:37:55Z")

</div>

Logging P1 ones a day, have seen that lately some days were missing.

---

<div class="post-metadata">

**Author:** ![Walter\_vande\_kerkhof](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/walter_vande_kerkhof/32/28963_2.png) [@Walter\_vande\_kerkhof](https://community.homey.app/u/Walter_vande_kerkhof)\
**Post date:** [July 14, 2023, 7:30pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/44 "2023-07-14T19:30:33Z")

</div>

It’s even worse. Not missing some values but a lot of values. See screendump

 ![IMG_0926](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/c/4/c4ee8927bed28049d0c7628d3973c3e71c04e12e.png)

---

<div class="post-metadata">

**Author:** ![Walter\_vande\_kerkhof](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/walter_vande_kerkhof/32/28963_2.png) [@Walter\_vande\_kerkhof](https://community.homey.app/u/Walter_vande_kerkhof)\
**Post date:** [August 4, 2023, 3:20pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/45 "2023-08-04T15:20:44Z")

</div>

Contacted Athom. They say it’s on the google side. The only suggestion they had was to send the same info once the first time results in an error.

Tried that but it doesn’t solve it for me

---

<div class="post-metadata">

**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:** [August 5, 2023, 10:49am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/46 "2023-08-05T10:49:39Z")

</div>

As alternative, you can consider [[APP][Pro] Simple (Sys) LOG - Use this app for Simple (Sys) Logging](https://community.homey.app/t/app-pro-simple-sys-log-use-this-app-for-simple-sys-logging/77533)

---

<div class="post-metadata">

**Author:** ![Walter\_vande\_kerkhof](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/walter_vande_kerkhof/32/28963_2.png) [@Walter\_vande\_kerkhof](https://community.homey.app/u/Walter_vande_kerkhof)\
**Post date:** [August 5, 2023, 12:31pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/47 "2023-08-05T12:31:23Z")

</div>

I’m familiar with that app. The advantage iof google sheets is that it can be used in excel as a datasource and all my graphs are refreshed when opening the excel file. Don’t know if that’s possible with simple log as well

---

<div class="post-metadata">

**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:** [August 6, 2023, 10:37pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/48 "2023-08-06T22:37:38Z")

</div>

Exporting to excel always shows “the latest x logs”. And it’s even possible to call a local URL with the latest logs:

> [@\[APP\]\[Pro\] Simple (Sys) LOG - Use this app for Simple (Sys) Logging](https://community.homey.app/t/app-pro-simple-sys-log-use-this-app-for-simple-sys-logging/77533/321):
>
> HTML page ready! Here you can check Syslog on the fly (while at home). Just change the Homey IP address in the URL… Save this code to a HTML file and save on eg. your Home screen on you phone. \<!DOCTYPE html\> \<html\> \<head\> \<style\> table, th, td { border: solid 1px #ddd; border-collapse: collapse; padding: 2px 3px; text-align: left; } th { font-weight:bold; } \</style\> \</head\> \<body\> …

---

<div class="post-metadata">

**Author:** ![FabianB](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/fabianb/32/17313_2.png) [@FabianB](https://community.homey.app/u/FabianB)\
**Post date:** [January 4, 2024, 12:22pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/49 "2024-01-04T12:22:02Z")

</div>

Same problem here, but no solution found yet…

---

<div class="post-metadata">

**Author:** ![Walter\_vande\_kerkhof](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/walter_vande_kerkhof/32/28963_2.png) [@Walter\_vande\_kerkhof](https://community.homey.app/u/Walter_vande_kerkhof)\
**Post date:** [January 4, 2024, 5:48pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/50 "2024-01-04T17:48:31Z")

</div>

I solved this problem by starting the flow x:01 instead of x:00.

---

<div class="post-metadata">

**Author:** ![FabianB](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/fabianb/32/17313_2.png) [@FabianB](https://community.homey.app/u/FabianB)\
**Post date:** [January 4, 2024, 9:44pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/51 "2024-01-04T21:44:36Z")

</div>

I think I don’t understand what you mean…

---

<div class="post-metadata">

**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:** [January 4, 2024, 11:28pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/52 "2024-01-04T23:28:56Z")

</div>

I guess he solved it by starting the flow one minute after each hour, instead of exactly at each hour?

---

<div class="post-metadata">

**Author:** ![Walter\_vande\_kerkhof](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/walter_vande_kerkhof/32/28963_2.png) [@Walter\_vande\_kerkhof](https://community.homey.app/u/Walter_vande_kerkhof)\
**Post date:** [January 5, 2024, 9:42am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/53 "2024-01-05T09:42:16Z")

</div>

correct

---

<div class="post-metadata">

**Author:** ![Alexander\_84](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/alexander_84/32/13597_2.png) [@Alexander\_84](https://community.homey.app/u/Alexander_84)\
**Post date:** [February 3, 2024, 8:17am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/54 "2024-02-03T08:17:17Z")

</div>

I also have a problem with no data being logged to sheets. I’ve tried different flow starts, as 11:59pm and so on with data only being logged 1 of 5 days. Flow only runs once a day. Frustrating…

---

<div class="post-metadata">

**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:** [February 3, 2024, 1:11pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/55 "2024-02-03T13:11:24Z")

</div>

You are aware of the fact you can log error messages from flow cards in Advanced flow?  
It might reveal the cause…

Example

 ![Screenshot_20240203-141426_Chrome](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/2/02c2609ad486cb6b5c8f16c09542d6f353afaae2.jpeg)

---

<div class="post-metadata">

**Author:** ![Alexander\_84](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/alexander_84/32/13597_2.png) [@Alexander\_84](https://community.homey.app/u/Alexander_84)\
**Post date:** [February 4, 2024, 10:51am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/56 "2024-02-04T10:51:29Z")

</div>

I was not I can check this out.  
But when I test the flow it works. And if I set a time in the next minute when I’m inside the advanced flow it reports. But not at the time I actually want it to report.

---

<div class="post-metadata">

**Author:** ![mravensberg](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/mravensberg/32/94205_2.png) [@mravensberg](https://community.homey.app/u/mravensberg)\
**Post date:** [February 14, 2024, 2:20pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/57 "2024-02-14T14:20:09Z")

</div>

Have a strange issue with the Google Sheet flow; When I start the flow from test mode, the flow runs perfectly and a new row is added to the spreadsheet. However when the flow runs unattended (every hour) I get a “Rate Limited” error. I added a retry 65 sec’s later, but still the same rate limited. Do you get a rate limited as well?

---

<div class="post-metadata">

**Author:** ![mravensberg](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/mravensberg/32/94205_2.png) [@mravensberg](https://community.homey.app/u/mravensberg)\
**Post date:** [February 15, 2024, 12:37pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/58 "2024-02-15T12:37:39Z")

</div>

moved start of the flow to 1 minute after each hour (0:01, 1:01, 2:01 etc) and now it works like a charm

---

<div class="post-metadata">

**Author:** ![John\_Andersen](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/john_andersen/32/30171_2.png) [@John\_Andersen](https://community.homey.app/u/John_Andersen)\
**Post date:** [March 24, 2024, 8:07am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/59 "2024-03-24T08:07:48Z")

</div>

After latest update of the Google Sheets app I have an issue selecting the Google document:  
 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/6/a6f2e4f2277972819699bf50d96372b749eb49ee.png)  
I’m the only one having this issue?

---

<div class="post-metadata">

**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 24, 2024, 8:38am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/60 "2024-03-24T08:38:49Z")

</div>

Same here, previously that was a selection list of sheets on ones account.

[Previous page](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101.md?page=2)

[Next page](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101.md?page=4)