# \[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:** 1
**Author:** ![AppStore](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/appstore/32/88202_2.png) [@AppStore](https://community.homey.app/u/AppStore)\ **Post date:** [March 26, 2024, 5:03am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/1 "2024-03-26T05:03:31Z")
# Google Sheets This discussion is started to centralize all Questions, Answers and Information around the app. > **[Google Sheets | Homey](https://homey.app/en-us/app/com.google.sheets/Google-Sheets/)** > > Append to Google Sheets from a Flow. ## Note: This topic is not actively monitored by Athom. If you have issues with this app, please report it to [support@athom.com](mailto:support@athom.com), mentioning the version of the app + a good description of the issue. ## Supported devices - Google Sheets User ## Report Bugs for this App to the Developers - Please use the Link in the App Store and follow the community guidelines, the more information provided the faster it can be solved. ## Forum Discussion Initial Discussion created by [@oh2th](https://forum.athom.com/profile/oh2th) with info from the community. Ask any Moderator to add/update/correct this Discussion. ---
**Author:** ![AppStore](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/appstore/32/88202_2.png) [@AppStore](https://community.homey.app/u/AppStore)\ **Post date:** [March 26, 2024, 5:04am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/2 "2024-03-26T05:04:17Z")
Google Sheets - Frequently Asked Questions (reserved) ---
**Author:** ![Ria\_Banis](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ria_banis/32/7966_2.png) [@Ria\_Banis](https://community.homey.app/u/Ria_Banis)\ **Post date:** [January 15, 2023, 10:31am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/3 "2023-01-15T10:31:04Z")
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](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/c/3/c33b1f8a812b94c4ae444069c73eec7efd0962eb.png) ---
**Author:** ![robertklep](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/robertklep/32/160628_2.png) [@robertklep](https://community.homey.app/u/robertklep)\ **Post date:** [January 15, 2023, 10:42am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/4 "2023-01-15T10:42:45Z")
Did you create a Google sheet to which it can append data? ---
**Author:** ![Ria\_Banis](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ria_banis/32/7966_2.png) [@Ria\_Banis](https://community.homey.app/u/Ria_Banis)\ **Post date:** [January 15, 2023, 10:45am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/5 "2023-01-15T10:45:28Z")
Yes I did: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/5/4/54bcbcac86c2787fc6c0bce91bb0d7b19701f542.png) ---
**Author:** ![robertklep](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/robertklep/32/160628_2.png) [@robertklep](https://community.homey.app/u/robertklep)\ **Post date:** [January 15, 2023, 10:50am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/6 "2023-01-15T10:50:02Z")
Did you also tick these two boxes when creating the Google Sheets User device? ![Screenshot 2023-01-15 at 11.47.07](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/e/5/e555a1248904c44ace2a887b2f9abcdd185ed34a.png) ---
**Author:** ![Ria\_Banis](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ria_banis/32/7966_2.png) [@Ria\_Banis](https://community.homey.app/u/Ria_Banis)\ **Post date:** [January 15, 2023, 10:59am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/7 "2023-01-15T10:59:27Z")
I overlooked this totally 😳 Thank you very much for your quick support. This open ups a lot of possibilities. 👍 ---
**Author:** ![OlleWestin](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ollewestin/32/46565_2.png) [@OlleWestin](https://community.homey.app/u/OlleWestin)\ **Post date:** [January 16, 2023, 1:02pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/8 "2023-01-16T13:02:34Z")
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. ---
**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:** [January 25, 2023, 8:55am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/9 "2023-01-25T08:55:12Z")
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 ---
**Author:** ![robertklep](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/robertklep/32/160628_2.png) [@robertklep](https://community.homey.app/u/robertklep)\ **Post date:** [January 25, 2023, 8:59am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/10 "2023-01-25T08:59:32Z")
Isn’t that something you configure in the sheet? ---
**Author:** ![Undertaker](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/undertaker/32/53278_2.png) [@Undertaker](https://community.homey.app/u/Undertaker)\ **Post date:** [January 25, 2023, 9:22am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/11 "2023-01-25T09:22:19Z")
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. ---
**Author:** ![robertklep](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/robertklep/32/160628_2.png) [@robertklep](https://community.homey.app/u/robertklep)\ **Post date:** [January 25, 2023, 9:33am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/12 "2023-01-25T09:33:55Z")
> [@Undertaker](#): > > 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: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/b/b/bb757680dc1b9210dece53b0ca8e87b93f1935b1.png) ---
**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:** [January 25, 2023, 10:59am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/13 "2023-01-25T10:59:55Z")
Clever Robert! I will try that too! ---
**Author:** ![Ria\_Banis](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ria_banis/32/7966_2.png) [@Ria\_Banis](https://community.homey.app/u/Ria_Banis)\ **Post date:** [January 25, 2023, 1:16pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/14 "2023-01-25T13:16:18Z")
I tried to find this but where to adjust ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/6/b/6b707b2017ec6b0a38dc91ee27c3f48e2563d061.png) ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/8/f/8f71ed3ae71e4b00732495897ab39457df810fe0.png) These settings don’t let me calculate. ---
**Author:** ![robertklep](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/robertklep/32/160628_2.png) [@robertklep](https://community.homey.app/u/robertklep)\ **Post date:** [January 25, 2023, 1:20pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/15 "2023-01-25T13:20:11Z")
“Bestand \> Instellingen \> Landinstelling” ---
**Author:** ![Ria\_Banis](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ria_banis/32/7966_2.png) [@Ria\_Banis](https://community.homey.app/u/Ria_Banis)\ **Post date:** [January 25, 2023, 1:24pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/16 "2023-01-25T13:24:37Z")
Probably on a PC in Excel? I am working almost always on my iPad, so I have to search for my laptop then 😉 ---
**Author:** ![robertklep](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/robertklep/32/160628_2.png) [@robertklep](https://community.homey.app/u/robertklep)\ **Post date:** [January 25, 2023, 1:27pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/17 "2023-01-25T13:27:29Z")
> [@Ria\_Banis](#): > > Probably on a PC in Excel? ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/2/3/2322283fc6fd95f2db86b743ca536f4ea2a0c60c.png) ---
**Author:** ![Ria\_Banis](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ria_banis/32/7966_2.png) [@Ria\_Banis](https://community.homey.app/u/Ria_Banis)\ **Post date:** [January 25, 2023, 1:49pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/18 "2023-01-25T13:49:10Z")
Found it. Thanks for your help again. (It was not in the app sheets but web based) ---
**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:** [January 26, 2023, 6:28pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/19 "2023-01-26T18:28:44Z")
Works for me @robertklep! Great tip! ---
**Author:** ![GeirL](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/geirl/32/70689_2.png) [@GeirL](https://community.homey.app/u/GeirL)\ **Post date:** [February 17, 2023, 2:23pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/20 "2023-02-17T14:23:08Z")
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 😉 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. [Next page](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101.md?page=2)