如何将数据从电报机器人的在线键盘发送到google电子表格中的特定列？

import telebot
import gspread
from oauth2client.service_account import ServiceAccountCredentials

# Telegram Bot API令牌
bot_token = 'YOUR_BOT_TOKEN'

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

# Google电子表格ID
spreadsheet_id = 'YOUR_SPREADSHEET_ID'

# Google Sheets API范围
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']

# 创建Telegram Bot实例
bot = telebot.TeleBot(bot_token)

# 处理接收到的消息
@bot.message_handler(func=lambda message: True)
def handle_message(message):
    # 获取消息文本
    text = message.text
    
    # 连接到Google Sheets API
    credentials = ServiceAccountCredentials.from_json_keyfile_name(credentials_file, scope)
    client = gspread.authorize(credentials)
    
    # 打开Google电子表格
    spreadsheet = client.open_by_key(spreadsheet_id)
    
    # 选择工作表
    worksheet = spreadsheet.sheet1
    
    # 将消息文本写入特定列
    worksheet.append_row([text])
    
    # 回复用户
    bot.reply_to(message, '数据已发送到Google电子表格中的特定列！')

# 启动Telegram Bot
bot.polling()