Hello everybody,
I added google calender and it work’s perfectly well with the oauth typ “TV und eingeschränkte Eingabe” = “TV and restriceted Entries”. But whenever I wanted to add the sheets application the autorisation fails and says “access blocked - error 400: redirect_uri_mismatch”. I Also already deleted this one and tried it with web application which resulted in nothing working at all.
Can anybody post a way to to use both? (Sheets API is activated as well)
The error shown, redirect_uri_mismatch, means Google is rejecting the callback URI sent by Home Assistant because it does not exactly match the URI registered in that OAuth client. Recheck the Sheets integration’s displayed callback value character-for-character in the same Web application client used for Sheets; keeping Calendar on its separate client is the safest test.
Hey Reese,
thanks for the quick response. I already tried it with a second client beeing set up as a webapplication and set an authorised forwarded autorisation url “https://homeassistant.atil3479.ts.net/auth/external/callback” (numbers a fictive ones) but it didn’t work as well :-/. I think it was the same error. I was now willed to reconstruct the problem but clicking on the tab Oauth-Logindata makes HA load forever and I can’t delete the oauth. And set up a new one for sheets. I also restarted HA but no change.
Holy crap - looks like my ha is down. Can’t load backups as well :-/.
HA is running normal again and I deleted the sheets oauth in ha and added it with the web application and it is like I remembered. He’s again stating redirect uri mismatch. Any suggestions?
Ok - once again I also asked copilot and he told me that it doesn’t work with tailscale. And as cloudflare doesn’t work anymore as well that’s the moment again where I need help from u guys. I hope anybody has a working idea on this one and can tell why it works for the calender but not for sheets.
The redirect_uri_mismatch points to the OAuth client, not Tailscale itself. The Sheets client needs the exact callback shown by Home Assistant, entered character-for-character; a stale callback entry would cause this.