使用Google Sheets API列出所有电子表格

pip install --upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlib

import os.path
from google.auth.transport.requests import Request
from google.oauth2.credentials import Credentials
from google_auth_oauthlib.flow import InstalledAppFlow
from googleapiclient.discovery import build

# 如果修改这些范围，请删除文件token.json。
SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly']

# 文件token.json存储了用户的访问和刷新令牌，它是自动创建的
# 当授权流程第一次完成时。
creds = None
if os.path.exists('token.json'):
    creds = Credentials.from_authorized_user_file('token.json', SCOPES)
# 如果没有有效的凭据可用，则让用户登录。
if not creds or not creds.valid:
    if creds and creds.expired and creds.refresh_token:
        creds.refresh(Request())
    else:
        flow = InstalledAppFlow.from_client_secrets_file(
            'credentials.json', SCOPES)
        creds = flow.run_local_server(port=0)
    # 保存授权令牌以便将来使用
    with open('token.json', 'w') as token:
        token.write(creds.to_json())

# 创建Google Sheets API服务对象
service = build('sheets', 'v4', credentials=creds)

# 调用spreadsheets.list方法获取所有电子表格
sheets = service.spreadsheets().list().execute()

# 打印所有电子表格的ID和名称
for sheet in sheets.get('sheets', []):
    print(f"{sheet['properties']['title']} - {sheet['properties']['sheetId']}")