hi !

thanks for the report :) it does seem something is going wrong here

I have attempted a fix here: #1525

for now, you can try this code

credentials2 = ...

import json

CREDS_FILENAME = "credentials.json"
with open(CREDS_FILENAME, "w", encoding="utf-8") as file:
    json.dump(credentials2, file)

gc, authorized_user = gspread.oauth(credentials_filename=CREDS_FILENAME)

let me know if that helps :)

Can't run, I need to run it on the server, but it will prompt
webbrowser.Error: could not locate runnable browser

通过其它方式在服务器上执行成功了

需要先在本地执行获取authorized_user

import gspread
import json

credentials = {}
gc = gspread.oauth(credentials)

执行完成后，打开文件 C:\Users\username\AppData\Roaming\gspread\authorized_user.json
将内容作为authorized_user变量就可以在服务器上使用

import gspread
import json

credentials = {}
authorized_user = {}
gc, authorized_user = gspread.oauth_from_dict(credentials, authorized_user)
sh = gc.open_by_key('1PtyQXeetBjyJ7tSwR7XSXNXm1I.....')

通过其它方式在服务器上执行成功了

需要先在本地执行获取authorized_user

import gspread
import json

credentials = {}
gc = gspread.oauth(credentials)

执行完成后，打开文件 C:\Users\username\AppData\Roaming\gspread\authorized_user.json 将内容作为authorized_user变量就可以在服务器上使用

import gspread
import json

credentials = {}
authorized_user = {}
gc, authorized_user = gspread.oauth_from_dict(credentials, authorized_user)
sh = gc.open_by_key('1PtyQXeetBjyJ7tSwR7XSXNXm1I.....')

Hi please use English to reply to any issue, in case you need help you can use https://www.deepl.com/en/translator

Executed successfully on the server through other methods

You need to execute locally first to get authorized_user

import gspread
import json

credentials = {}
gc = gspread.oauth(credentials)

After the execution is complete, open the file C:\Users\username\AppData\Roaming\gspread\authorized_user.json
and use the content as the authorized_user variable on the server

import gspread
import json

credentials = {}
authorized_user = {}
gc, authorized_user = gspread.oauth_from_dict(credentials, authorized_user)
sh = gc.open_by_key('1PtyQXeetBjyJ7tSwR7XSXNXm1I.....')