无法通过Google Docs API删除表中的行

import google.auth
from googleapiclient.discovery import build

# 使用授权凭证进行身份验证
credentials, project = google.auth.default()
service = build('sheets', 'v4', credentials=credentials)

# 定义要删除的行的范围
spreadsheet_id = 'your_spreadsheet_id'
sheet_name = 'Sheet1'
start_row = 2
end_row = 5

# 构建删除行的请求
delete_request = {
  "requests": [
    {
      "deleteRange": {
        "range": {
          "sheetId": service.spreadsheets().values().get(spreadsheetId=spreadsheet_id, range=sheet_name).execute().get('sheetId'),
          "startRowIndex": start_row - 1,
          "endRowIndex": end_row
        },
        "shiftDimension": "ROWS"
      }
    }
  ]
}

# 执行删除操作
request = service.spreadsheets().batchUpdate(spreadsheetId=spreadsheet_id, body=delete_request)
response = request.execute()