有没有办法将文本文件上传到Google sheets，其中包含分隔符或类似于regex的内容来填充单元格

import os
import csv
import re
import google.auth
from googleapiclient.discovery import build

# 身份验证和授权
credentials, project = google.auth.default()
service = build('sheets', 'v4', credentials=credentials)

# 上传文本文件并填充单元格
def upload_text_file_to_sheets(file_path, sheet_id, range_name, delimiter):
    # 读取文本文件内容
    with open(file_path, 'r') as file:
        content = file.read()

    # 解析文本文件内容并生成行列数据
    rows = content.split('\n')
    data = []
    for row in rows:
        cells = re.split(delimiter, row)
        data.append(cells)

    # 构建请求数据
    body = {
        'values': data
    }

    # 发送请求
    request = service.spreadsheets().values().update(
        spreadsheetId=sheet_id,
        range=range_name,
        valueInputOption='RAW',
        body=body
    )
    response = request.execute()

    print('文本文件已成功上传到Google Sheets！')

# 示例用法
file_path = 'path/to/text/file.txt'
sheet_id = 'your-sheet-id'
range_name = 'Sheet1!A1'
delimiter = ','

upload_text_file_to_sheets(file_path, sheet_id, range_name, delimiter)