我尝试使用文档gsheetsdb，但它给了我与更新值相关的问题。这就是为什么我探索gspread库，而不是为我工作，它比文档中的更容易。（个人观点）代码中的json文件可以按照文档中给出的相同方式获得。

import gspread
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']

#the json file should be put in the same location as the python file or give the entire path.
creds = ServiceAccountCredentials.from_json_keyfile_name('testingdb-b6d4d-d0a2646c069a.json', scope)

client = gspread.authorize(creds)
    
#Create one workbook name it 'TestSheet' and at the bottom rename Sheet1 as 'names'
sh = client.open('TestSheet').worksheet('names') 

#Create a list the way you want and add the data to excel worksheet,
#just use the append_row function of the sh object created.
#To read all the data just use the read_all_values() function and you get a list of lists.

row = ["Jason","22","Photography"]
sh.append_row(row)

查看文档获取json文件：streamlit docs
注意：在JSON文件中，将有一个服务帐户电子邮件ID。您需要复制它并将其放入Excel工作表共享选项中。单击共享，然后添加如下所示的服务帐户电子邮件