如何使用python通过url对google sheets进行读写

pip install gspread

import gspread
from oauth2client.service_account import ServiceAccountCredentials

# 定义Google Sheets文档的URL
sheet_url = 'https://docs.google.com/spreadsheets/d/your_sheet_id/edit#gid=0'

# 定义要读写的工作表名称
sheet_name = 'Sheet1'

# 定义要写入的数据
data = [['Name', 'Age'], ['John', 25], ['Alice', 30]]

# 定义函数来连接到Google Sheets并进行读写操作
def update_google_sheet(sheet_url, sheet_name, data):
    # 定义身份验证范围和凭据
    scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
    credentials = ServiceAccountCredentials.from_json_keyfile_name('credentials.json', scope)

    # 连接到Google Sheets
    client = gspread.authorize(credentials)
    sheet = client.open_by_url(sheet_url).worksheet(sheet_name)

    # 读取数据
    values = sheet.get_all_values()
    print('读取的数据：')
    for row in values:
        print(row)

    # 写入数据
    sheet.clear()  # 清空工作表
    sheet.insert_rows(data)  # 插入数据

    print('数据已成功写入Google Sheets！')

# 调用函数进行读写操作
update_google_sheet(sheet_url, sheet_name, data)