以编程方式更新Google文档上托管的电子表格

import google.auth
from google.oauth2 import service_account
from googleapiclient import discovery

# 设置Google Cloud项目的相关信息
credentials = service_account.Credentials.from_service_account_file(
        'path/to/your/credentials.json',
        scopes=['https://www.googleapis.com/auth/spreadsheets'])

# 创建Google Sheets API的客户端
sheets_api = discovery.build('sheets', 'v4', credentials=credentials)

# 设置要更新的电子表格的相关信息
spreadsheet_id = 'your-spreadsheet-id'
range_name = 'Sheet1!A1:B2'
value_input_option = 'USER_ENTERED'

# 更新电子表格
values = [
    ['Hello', 'World'],
    ['Foo', 'Bar']
]
body = {'values': values}
result = sheets_api.spreadsheets().values().update(
        spreadsheetId=spreadsheet_id, range=range_name,
        valueInputOption=value_input_option, body=body).execute()
print(result)