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

Google sheets is free. Google Sheets: Online Spreadsheets & Templates | Google Workspace

" 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-functies, zoals Help me met ordenen, zijn beschikbaar als add-on. Ga naar abonnementen en prijzen voor organisaties of Google Workspace voor individuen."

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.

1 Like

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. :wink:

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

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?

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

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.

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

Getting data back form a sheet is not possible.

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.

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.

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

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

I have created a ticket @ Athom.

1 Like

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.

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.

Any ideas?

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

Rgds,
Carl

Can you access https://accounts.google.com from a regular browser?

Hi Robert, yes I can.

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

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

1 Like

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.

Try from the mobile app.

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

Thanks Robert!