如何用python“复制”GoogleSheet？

from google.oauth2 import service_account

credentials = service_account.Credentials.from_service_account_file('credentials.json')

from googleapiclient.discovery import build

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

# 源表格ID
source_sheet_id = '源表格ID'

# 目标表格名称
target_sheet_name = '目标表格名称'

# 复制表格请求
request = service.spreadsheets().sheets().copyTo(
    spreadsheetId=source_sheet_id,
    sheetId=0,
    body={'destinationSheetId': 0, 'destinationSpreadsheetId': source_sheet_id, 'newSheetName': target_sheet_name}
)

# 发送复制表格请求
response = request.execute()

# 复制后的表格ID
copied_sheet_id = response['sheetId']