# \[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:** 5

<div class="post-metadata">

**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:55am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/81 "2024-07-08T11:55:57Z")

</div>

Google sheets is free. [Google Sheets: Online Spreadsheets & Templates | Google Workspace](https://workspace.google.com/products/sheets/)

" Hoeveel kost Google Spreadsheets?

Iedereen met een Google-account kan spreadsheets maken met Spreadsheets.

Maar sommige functies, zoals deelnemen aan een Meet-gesprek vanuit uw documenten, zijn alleen beschikbaar voor bepaalde Google Workspace-abonnementen. [Gemini voor Workspace](https://workspace.google.com/intl/nl/solutions/ai/)-functies, zoals Help me met ordenen, zijn beschikbaar als add-on. Ga naar [abonnementen en prijzen voor organisaties](https://workspace.google.com/intl/nl/pricing.html) of [Google Workspace voor individuen](https://workspace.google.com/intl/nl/individual/)."

How much does Google Sheets cost?  
Anyone with a Google account can create spreadsheets with Sheets.

But some features, like joining a Meet call from your documents, are only available on select Google Workspace plans. Gemini for Workspace features, such as Help Me Organize, are available as an add-on. Go to plans and pricing for organizations or Google Workspace for individuals.

---

<div class="post-metadata">

**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, 12:05pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/82 "2024-07-08T12:05:51Z")

</div>

Thanks for the answer.

Then I shall wait the 7 days if something is happend.

**Edit**.

Self was I looking in my Google account and saw Google Sheet indeed standing by the other free items.

Look also better to the mail then saw that it came from Google _Cloud_.  
Then a lightbulb was going on.  
In the past I was there looking for something but I game stuck in the links there.  
One moment I had to fill-in a strange list of questions and I closed every thing with **X** top right. 😉

Now I think that it can be come from that moment.

---

<div class="post-metadata">

**Author:** ![Tormod\_F](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tormod_f/32/49057_2.png) [@Tormod\_F](https://community.homey.app/u/Tormod_F)\
**Post date:** [August 1, 2024, 7:34pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/83 "2024-08-01T19:34:33Z")

</div>

Hallo, I am also starting using the Google sheets app. When entering the URL in the Then card and later trying to enter which sheet I get an 404 error message. I am getting the URL from my Google disk which leads me to the sheets entering form when using it in my browser.  
These questions you asked Ria-Banis about I don’t find when creatingthe Google Sheets device.  
Can you help me with this, so that I can start with Google Sheets?

---

<div class="post-metadata">

**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:** [August 1, 2024, 7:55pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/84 "2024-08-01T19:55:39Z")

</div>

Do you have in Homey, under **+** by Google Sheet, created a virtual device.

---

<div class="post-metadata">

**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:** [September 23, 2024, 3:37pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/85 "2024-09-23T15:37:44Z")

</div>

Because I had good result by looking to errors with Googel Sheet, I want make a more useful sheet.  
This time ones a day a upload.  
But now I get often “Rate Limited” error.  
Few day OK and then not.

Now have made also a mistake by restarting the flow. That’s is normal to do by problems.  
_Al my THEN cards for uploading are cone._

If there was a warning that this could happend with cards than I had made a copy of the text.  
For now I skip Googel Sheet. Maybe later I shall make time to restore the THEN card for upload.

**Edit**  
Al my THEN cards for uploading are back.  
“Rate Limited” error is still happening now and the by one upload.

---

<div class="post-metadata">

**Author:** ![Bence\_Molnar](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bence_molnar/32/78988_2.png) [@Bence\_Molnar](https://community.homey.app/u/Bence_Molnar)\
**Post date:** [September 26, 2024, 7:58pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/86 "2024-09-26T19:58:56Z")

</div>

Hello!  
Is there any way to get informations from google sheet to homey? This is the other direction 😃  
Do you know any idea / app for this?  
(I would like to save different google sheet cells to homey variables)  
Thanks, Bence

---

<div class="post-metadata">

**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:** [September 26, 2024, 8:40pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/87 "2024-09-26T20:40:37Z")

</div>

Getting data back form a sheet is not possible.

---

<div class="post-metadata">

**Author:** ![ArnarS](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/arnars/32/33981_2.png) [@ArnarS](https://community.homey.app/u/ArnarS)\
**Post date:** [September 28, 2024, 5:12pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/88 "2024-09-28T17:12:13Z")

</div>

I am getting a ‘missing token’ error when trying to use the ‘google sheets’ app. Anyone else getting the same?

Seems to have started failing on September 1.

---

<div class="post-metadata">

**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:** [September 29, 2024, 6:29am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/89 "2024-09-29T06:29:45Z")

</div>

That I have not  
Is that also by a “test” ?

* * *

The “Rate Limited” came again on a then card with less cells to fill.  
An test just done works fine.

---

<div class="post-metadata">

**Author:** ![ArnarS](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/arnars/32/33981_2.png) [@ArnarS](https://community.homey.app/u/ArnarS)\
**Post date:** [September 29, 2024, 8:28am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/90 "2024-09-29T08:28:31Z")

</div>

Yes, they fail when I try to run a flow. But all my ‘Google Sheets’ cards stopped working on 1st of September @ 9:00.

I did some checking and found that the cards I was using were at some timepoint deprecated:  
 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/5/1/5120647b210f4f6cb93afa562c5e9041ac382454.png)

And when I try to replace it with the new type of card, where I paste the URL of the sheet into the card, the ‘missing token’ error comes when I try to select the sheet:  
 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/d/7/d7f12dd68e412b21ac313a62ab687c614d88fb3a.png)

I have created a ticket @ Athom.

---

<div class="post-metadata">

**Author:** ![ArnarS](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/arnars/32/33981_2.png) [@ArnarS](https://community.homey.app/u/ArnarS)\
**Post date:** [October 5, 2024, 2:26pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/91 "2024-10-05T14:26:30Z")

</div>

Athom could not get anything helpful from the app’s diagnostics report. Athom therefore suggested to delete and re-install the app.

That fixed the problem, but obviously then I have a bunch of broken apps I need to fix.  
So, issue resolved, although no explanation to why it happened.

---

<div class="post-metadata">

**Author:** ![PLISSKEN](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/plissken/32/106331_2.png) [@PLISSKEN](https://community.homey.app/u/PLISSKEN)\
**Post date:** [October 18, 2024, 8:13am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/92 "2024-10-18T08:13:05Z")

</div>

Hi yall,

so I sign in using the popup to google, give access and is taken back to the spinning circle and “Please log in on the website of the manufacturer.” which times a out after a while.

 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/2/f/2f561b8e0274d964f0f5f2f2941fd126afe90ffd.png)

 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/b/c/bc1b87ac788b0ab4ef54d1a5789f9e864051430d.png)

Any ideas?

It used to work, stopped working and I removed the app and added it back.

Rgds,  
Carl

---

<div class="post-metadata">

**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:** [October 18, 2024, 8:16am UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/93 "2024-10-18T08:16:11Z")

</div>

Can you access [https://accounts.google.com](https://accounts.google.com) from a regular browser?

---

<div class="post-metadata">

**Author:** ![PLISSKEN](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/plissken/32/106331_2.png) [@PLISSKEN](https://community.homey.app/u/PLISSKEN)\
**Post date:** [October 18, 2024, 12:20pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/94 "2024-10-18T12:20:28Z")

</div>

Hi Robert, yes I can.

I tried using a different Google account and it does the same thing as the one i tried first.

---

<div class="post-metadata">

**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:** [October 18, 2024, 12:28pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/95 "2024-10-18T12:28:36Z")

</div>

It’s a strange error since it mentions “my.homey.app”, which is Homey’s web app. I assume that you’re using the Homey mobile app to configure the Google Sheets app, though?

Since it’s an Athom app, try contacting them: [Support | Homey](https://homey.app/support)

---

<div class="post-metadata">

**Author:** ![PLISSKEN](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/plissken/32/106331_2.png) [@PLISSKEN](https://community.homey.app/u/PLISSKEN)\
**Post date:** [October 18, 2024, 12:53pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/96 "2024-10-18T12:53:00Z")

</div>

No I’m using my PC, Edge.

I will try Athom support then.

In the meantime, if anyone know how to solves this feel free to chime in.

---

<div class="post-metadata">

**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:** [October 18, 2024, 12:59pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/97 "2024-10-18T12:59:36Z")

</div>

> [@PLISSKEN](#):
>
> No I’m using my PC, Edge.

Try from the mobile app.

---

<div class="post-metadata">

**Author:** ![PLISSKEN](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/plissken/32/106331_2.png) [@PLISSKEN](https://community.homey.app/u/PLISSKEN)\
**Post date:** [October 18, 2024, 1:06pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/98 "2024-10-18T13:06:05Z")

</div>

![74FBDAA4-145A-4950-BCC3-A683E3B5456F](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/5/2/52364318d2fcf91f656b8975a29a9fb7c689e351.jpeg)

---

<div class="post-metadata">

**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:** [October 18, 2024, 1:11pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/99 "2024-10-18T13:11:57Z")

</div>

I think it might be related to IPv6 being used, but Athom will probably be able to provide you with a solution.

---

<div class="post-metadata">

**Author:** ![PLISSKEN](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/plissken/32/106331_2.png) [@PLISSKEN](https://community.homey.app/u/PLISSKEN)\
**Post date:** [October 18, 2024, 1:12pm UTC](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/100 "2024-10-18T13:12:36Z")

</div>

Thanks Robert!

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

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