如何使用python3遍历google表中的所有表？

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

import os
import pickle
import json
import google.auth
from google.auth.transport.requests import Request
from google_auth_oauthlib.flow import InstalledAppFlow
from googleapiclient.discovery import build

# 定义用于存储认证令牌的文件名
TOKEN_FILE = 'token.pickle'
# 定义用于存储凭据的文件名
CREDS_FILE = 'credentials.json'
# 定义要访问的Google表的ID
SPREADSHEET_ID = 'your_spreadsheet_id'

# 定义所需的范围（这里是访问所有表的只读权限）
SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly']

def authenticate():
    creds = None
    # 检查token.pickle文件是否存在并且有效
    if os.path.exists(TOKEN_FILE):
        with open(TOKEN_FILE, 'rb') as token:
            creds = pickle.load(token)
    
    # 如果没有有效的认证令牌，则使用credentials.json文件进行身份验证
    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(
                CREDS_FILE, SCOPES)
            creds = flow.run_local_server(port=0)
        
        # 保存认证令牌以供将来使用
        with open(TOKEN_FILE, 'wb') as token:
            pickle.dump(creds, token)
    
    return creds

def list_sheets():
    # 身份验证
    creds = authenticate()
    # 创建Google Sheets API的服务对象
    service = build('sheets', 'v4', credentials=creds)
    # 获取电子表格元数据
    spreadsheet = service.spreadsheets().get(
        spreadsheetId=SPREADSHEET_ID).execute()
    # 获取工作表列表
    sheets = spreadsheet.get('sheets', [])
    
    # 遍历每个工作表并打印其名称
    for sheet in sheets:
        sheet_name = sheet['properties']['title']
        print(sheet_name)

# 调用函数来列出所有表
list_sheets()