使用Python从Google文档下载电子表格

pip install gspread

import gspread
from oauth2client.service_account import ServiceAccountCredentials

# 设置API凭据
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
credentials = ServiceAccountCredentials.from_json_keyfile_name('credentials.json', scope)

# 身份验证并打开电子表格
client = gspread.authorize(credentials)
spreadsheet = client.open('电子表格名称')

# 获取电子表格中的所有工作表
sheets = spreadsheet.worksheets()

# 下载电子表格
for sheet in sheets:
    # 获取工作表数据
    data = sheet.get_all_records()
    # 处理数据，例如保存到本地文件或进行其他操作
    print(data)