import os
import google.auth
from googleapiclient.discovery import build
from google.oauth2.credentials import Credentials

# 获取认证
creds, project = google.auth.default(scopes=['https://www.googleapis.com/auth/calendar', 'https://www.googleapis.com/auth/spreadsheets'])

# 创建 Calendar 服务
calendar_service = build('calendar', 'v3', credentials=creds)

# 创建 Sheets 服务
sheets_service = build('sheets', 'v4', credentials=creds)

# 获取日历事件
events_result = calendar_service.events().list(calendarId='primary', timeMin='2023-01-01T00:00:00Z', maxResults=10, singleEvents=True, orderBy='startTime').execute()
events = events_result.get('items', [])

# 准备数据
data = []
for event in events:
    start = event['start'].get('dateTime', event['start'].get('date'))
    data.append([event['summary'], start])

# 写入 Sheets
sheet_id = 'your_sheet_id'
range_name = 'Sheet1!A1:B'
body = {
    'values': data
}
result = sheets_service.spreadsheets().values().update(spreadsheetId=sheet_id, range=range_name, valueInputOption='RAW', body=body).execute()

print('{0} cells updated.'.format(result.get('updatedCells')))