如何使用Python复制Google工作表？

import os
import google.auth
from googleapiclient.discovery import build

# 认证配置
credentials, project = google.auth.default()
os.environ["GOOGLE_APPLICATION_CREDENTIALS"] = "path/to/your/credentials.json"

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

# 复制工作表
spreadsheet_id = 'your-source-spreadsheet-id'
sheet_id = 'your-source-sheet-id'
destination_spreadsheet_id = 'your-destination-spreadsheet-id'

request = service.spreadsheets().sheets().copyTo(
    spreadsheetId=spreadsheet_id,
    sheetId=sheet_id,
    body={'destinationSpreadsheetId': destination_spreadsheet_id}
)
response = request.execute()

print('复制成功！')