Port changes everytime gspread.oauth is run

[caynebrister1]

Bug:
Everytime gspread.oauth is used it uses a different port for the redirect URI which means I cant set a redirect URI for my OAuth client ID in the API dashboard. Because of the fact that I cant set a URI that will repeat the next time I run my code I constantly get the following message:

Steps to reproduce the behavior:

1. Downlaod JSON for your OAuth Client ID
2. Name the downloaded file as 'oauth_creds.json'
3. Move the JSON gile into the 'auth' folder of your project
4. Run the following code

import gspread

gc = gspread.oauth(
    credentials_filename='auth/oauth_creds.json'
)

The expected behavior is for a static redirect URI to be produced, that way it can be defined properly in the web console. Otherwise a URI with a different port each time can't be defined in the web console for the google API.

Environment info:

• OS Linux Mint
• Python 3.10.6
• gspread 5.7.2

[caynebrister1]

I believe the solution may be to use 'local_server_flow', but I don't understand what value to pass to the 'client_config' parameter.

[lavigne958]

Hi thank you for raising this issue.

I understand your point about the port being used locally where your code run. We can look for a way to solve this.

I am confused about your second comment:

I believe the solution may be to use 'local_server_flow'

What flow do you use ? the default one ? because if you use the default flow it's already the local_server_flow which uses some port to listen locally and to me is where your issue is located. If you use the console_flow then it won't work it has been deprecated.

[GmGniap]

This error is also happening to me. Any solution for this one?

If I updated that dynamically changing port number in Google Cloud > Redirect URI , error changed to "localhost refused to connect". I think this new error happened because of my machine permission for port , correct? How should I solve that kind of permission error? When I tried to search on internet , some suggested to setup flask server with this port on my own. Do I need to setup like this just to use gspread?

OS: macOS

[kombuchacoder]

Hi,

So, I have been facing a similar issue. The port for the redirect URI keeps on changing and I get the redirect_uri mismatch error every time.

Solution:

1. On google cloud console, edit the oauth credentials and add the redirect uri - http://localhost:35669/. You can use any other port also, I am using 35669 in this example
2. Edit your oauth call to this

FLOW_PORT = 35669

def local_server_flow_fixed_port(client_config, scopes):
    return gspread.auth.local_server_flow(
        client_config=client_config, scopes=scopes, port=FLOW_PORT
    )

client = gspread.auth.oauth(
    flow=local_server_flow_fixed_port,
)

Environment Info
OS: WSL2 Ubuntu 22.04.3 LTS
Python: 3.10.12
gspread: 6.1.2