使用Python访问Google Sheets Api

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

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

# 设置 API 访问范围
SCOPES = ['https://www.googleapis.com/auth/spreadsheets']

# 加载客户端配置文件
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 = googleapiclient.discovery.build('sheets', 'v4', credentials=creds)

# 示例：读取指定范围的数据
sheet_id = 'your_sheet_id'
range_name = 'Sheet1!A1:B2'
result = service.spreadsheets().values().get(spreadsheetId=sheet_id, range=range_name).execute()
values = result.get('values', [])
print(values)