Google Sheets Piece Error 400 on Update Rows

Need help
1

Whenever I try to update a row, I get the following error:

{
  "response": {
    "status": 400,
    "body": {
      "error": {
        "code": 400,
        "message": "Range (Models!A2:ZZZ2) exceeds grid limits. Max rows: 1, max columns: 26",
        "status": "INVALID_ARGUMENT"
      }
    }
  }

Inserting new rows works fine with all the same parameters and values. It’s only updating a row that doesn’t work.

I tried deleting the piece and rebuilding it, same result.

This flow was working fine until some time yesterday morning. That is when it started throwing this error. Not sure what broke, but I don’t see a way to set the grid limits in the update rows pieces.

2

Ok, nevermind. I think I see the problem. I added a clear sheet piece to clear out old data, so I should have changed this to add new rows rather than update rows.

Pebkac error resolved.

3

Thank you @Riley for posting here, I will mark you comment as solved (If i understand correctly)

4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.