遍历Google Sheets单元格中以逗号分隔的列表

import gspread
from oauth2client.service_account import ServiceAccountCredentials

# 设置Google Sheets API的访问凭证
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
credentials = ServiceAccountCredentials.from_json_keyfile_name('credentials.json', scope)
client = gspread.authorize(credentials)

# 打开目标工作表
sheet = client.open('工作表名称').sheet1

# 获取目标单元格的值
cell_value = sheet.acell('A1').value

# 将字符串拆分为列表
value_list = cell_value.split(',')

# 遍历列表并进行处理
for item in value_list:
    # 进行相应的处理，例如打印到控制台
    print(item)