如何将嵌套的JSON数据写入Google Sheets

import gspread
from oauth2client.service_account import ServiceAccountCredentials
import json

# 设置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)

# 打开Google Sheets文档
sheet = client.open('Google Sheets文档名称').sheet1

# 嵌套的JSON数据
nested_json = {
    "key1": "value1",
    "key2": {
        "nested_key1": "nested_value1",
        "nested_key2": "nested_value2"
    },
    "key3": "value3"
}

# 解析JSON数据并写入Google Sheets
row = 1
for key, value in nested_json.items():
    if isinstance(value, dict):
        # 如果值是嵌套的JSON数据，则将其转换为JSON字符串后写入单元格
        sheet.update_cell(row, 1, key)
        sheet.update_cell(row, 2, json.dumps(value))
    else:
        sheet.update_cell(row, 1, key)
        sheet.update_cell(row, 2, value)
    row += 1

print("数据已成功写入Google Sheets。")