Google Sheets OAuth fails

Hi everyone!

I am using the integration of Google Sheets, and it works perfectly, but just for a few days.
When the error happends, I don’t have any notification of any issue or any error. I realize the issue when I check my google sheet, and I see that I dont have any data for hours or days…

To solve the problem…
1.- I go to INTEGRATIONS, and reload the integration.
2.- Then I got a notification in HA (OAuth credentials error, or something like this), and I have to LINK the account again…
After doing this It works again, but after a few days the error comes again.

Anyone who knows how can I solve this definetly?

Hi, I got the same issue. HAs anybody an idea how to resolve it permanently.
Or what do I need to add to the automation to receive a notice of this failure?

I couldnt solve the problem properly, but now I realize when the integration doesnt work.

I have created an input boolean called “Chec google sheets”
Whenever I write in google sheets (in an automation or in a script), before writting in sheets I turn on the input boolean “Chec…”, and after I turn it off.

Afterwards I created a new automation…
If the input boolean “Chec…” is on for 1 or 2 minutes, then send a notification.

The problem is not solved, but at least now I realize few minutes after failing.

1 Like

Thanks - this helps a lot for me. although it doesn’t cure the issue with the authentication

I have the same problem.
In case you find a solution, please notify my…:wink: