Google BatchUpdate中每一行的不同背景色

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

# 设置认证信息
credentials = service_account.Credentials.from_service_account_file('credentials.json')
service = build('sheets', 'v4', credentials=credentials)

# 创建BatchUpdateRequest对象
batch_update_request = {
  'requests': []
}

# 创建条件格式规则
conditional_format_rule = {
  'booleanRule': {
    'condition': {
      'type': 'TEXT_EQ',
      'values': [
        {
          'userEnteredValue': '完成'
        }
      ]
    },
    'format': {
      'backgroundColor': {
        'red': 0,
        'green': 1,
        'blue': 0
      }
    }
  }
}

# 创建GridRange对象
grid_range = {
  'sheetId': sheet_id,
  'startRowIndex': 0,
  'endRowIndex': 1000,
  'startColumnIndex': 0,
  'endColumnIndex': 5
}

# 创建CellFormat对象
cell_format = {
  'backgroundColor': {
    'red': 1,
    'green': 0,
    'blue': 0
  }
}

# 创建条件格式请求
request = {
  'addConditionalFormatRule': {
    'rule': conditional_format_rule,
    'range': grid_range
  }
}

# 添加请求到BatchUpdateRequest对象的请求列表中
batch_update_request['requests'].append(request)

# 调用Google Sheets API的batchUpdate方法
response = service.spreadsheets().batchUpdate(
    spreadsheetId=spreadsheet_id,
    body=batch_update_request
).execute()

print('BatchUpdate completed.')