将消息从Telegram机器人反射到Google Sheets的问题

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

# Telegram Bot API令牌
telegram_token = 'YOUR_TELEGRAM_TOKEN'

# Google Sheets凭据文件路径
credentials_file = 'path/to/your/credentials.json'

# Google Sheets表格ID
spreadsheet_id = 'YOUR_SPREADSHEET_ID'

# 创建Telegram Bot实例
bot = telegram.Bot(token=telegram_token)

# 处理接收到的消息
def handle_message(update, context):
    message = update.message.text
    # 在这里执行将消息保存到Google Sheets的操作
    save_to_google_sheets(message)

# 将消息保存到Google Sheets
def save_to_google_sheets(message):
    # 加载Google Sheets凭据
    credentials = service_account.Credentials.from_service_account_file(credentials_file, scopes=['https://www.googleapis.com/auth/spreadsheets'])

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

    # 在这里执行将消息保存到Google Sheets的操作，例如追加到指定的表格中
    sheet = service.spreadsheets()
    sheet.values().append(spreadsheetId=spreadsheet_id, range='Sheet1!A1', valueInputOption='RAW', body={'values': [[message]]}).execute()

# 注册消息处理程序
bot.dispatcher.add_handler(telegram.MessageHandler(telegram.Filters.text, handle_message))

# 启动Telegram Bot
bot.start_polling()