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