如何使用Google sheets API从特定的SpreadSheet获取工作表id列表？

from google.oauth2 import service_account
from googleapiclient.discovery import build

# 使用服务账户文件进行身份验证
SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly']
SERVICE_ACCOUNT_FILE = 'path/to/service_account.json'

credentials = service_account.Credentials.from_service_account_file(
    SERVICE_ACCOUNT_FILE, scopes=SCOPES)

service = build('sheets', 'v4', credentials=credentials)

# 替换为您的Spreadsheet ID
spreadsheet_id = 'your-spreadsheet-id'

# 获取工作表元数据
sheet_metadata = service.spreadsheets().get(spreadsheetId=spreadsheet_id).execute()
sheets = sheet_metadata.get('sheets', '')

# 打印每个工作表的ID和标题
sheet_ids = []
for sheet in sheets:
    title = sheet['properties']['title']
    sheet_id = sheet['properties']['sheetId']
    print(f"Sheet name: {title}, Sheet ID: {sheet_id}")
    sheet_ids.append(sheet_id)

# 输出工作表ID列表
print(sheet_ids)