Question redirect_uri_mismatch When authorizing with Google Sheets Service O Auth

I have created the google cloud app, configured the O Auth Consent Screen and created my credential.

In the credentials, i configured all these URLs as authorized redirect URLS:



But when i select to Authorize in the Google Sheets Service, in this screen:



It shows me a redirect_uri_mismatch error:



I have no idea how to fix this, since all the URLs are set.

Do i need to specify the port in the URL too? Because that will be a problem, since each time i click to authorize in Unity, it uses a different port.

It should be working for any port, right?

What am i doing wrong?

 

Update: I have managed to make the authorization work by adding to the Redirect URL the http://localhost/authorize/ (with the slash at the end)

But i still cannot push / pull data from the Google Sheets



This is the error

I have seen a similar issue being reported on this other post, but there are no replies.

 

I'm trying to use the Google Sheets Service to syncronize my String Table for localization, following this official doc

The authentication part was the issue initially, but i have managed to make it work by providing the correct URL for the Redirection.

Now the issue lies on pushing / pulling (after the authentication complete) on this asset:



That shows the above 401 error when doing anything to pull / push data (The selection sheet dropdown works perfectly, pulling the correct sheet names)

 

Yes, i'm using O Auth, and followed the documentation about authentication.

I needed to add the Redirect because i was receiving a 400: redirect_uri_mismatch error, as stated previously in the original post

Well, i'm not sure exactly what i'm doing that you consider as "not seen anyone need to to this before", considering i'm just following the official documentation about the Localization Package.

The only different thing i did that is not stated on the documentation is adding the Redirect URL into the O Auth Consent Screen on Google Console, since it was

So, these are the steps i have made:

1- Installed the Localization Package in the Package Manager window (https://docs.unity3d.com/Packages/com.unity.localization@1.0/manual/Installation.html)

2- Created the Localization Settings
3- Created the Locales
4- Chose a Default Locale
5- Created a String Table Collection
(https://docs.unity3d.com/Packages/com.unity.localization@1.0/manual/QuickStartGuideWithVariants.html)

6- Visited Google API Console and created the Credentials
7- Created the O Auth Client ID
(https://docs.unity3d.com/Packages/c...Google-Sheets-Configuring-Authentication.html)

8- Created the Sheets Service Provider Asset
9- Selected the O Auth authentication method, and loaded the .json to use the Client ID and Secret
10 - Clicked on "Authorize" Button
(https://docs.unity3d.com/Packages/c...al/Google-Sheets-Sheets-Service-Provider.html)

11- Unity opened a browser for Google Login, and it gave me this error:



12- Because of that, I went back into the Google API Console, into the Credentials, and added the http://localhost/authorize/ URL into the Redirect URL list

13- After that, clicking on the "Authorize" Button, successfully worked and printed the following in the Unity Console:


14- Then, i selected the String Table Collection, and added the Google Service Extension and put in the Sheet ID that i'm using to Localize the strings.
(https://docs.unity3d.com/Packages/c...le-Sheets-Syncing-StringTableCollections.html)

15- Added the Default Columns in the "Mapped Colums" section

15- When clicking on either Push or Pull, it prints this error on the console:



UPDATE: As i'm writing this response, and testing each step, the error when clicking Push / Pull has been solved somehow. Probably it was just some kind of instability on Google Servers