Error on append: Range (xxx!A1017) exceeds grid limits. Max rows: 1016

[mikeparker]

Describe the bug When the sheet needs more rows adding, the append command doesn't automatically add new rows, and the action fails.

Error:"Max rows 1016" when appending data to a spreadsheet.

Run jroehl/[email protected]
  with:
    spreadsheetId: xxx
    commands: [
    *** "command": "appendData*** "args": *** "minCol" : 1, "worksheetTitle" : "xx*** "valueInputOption" : "USER_ENTERED*** "data": [[xx]] *** ***
  ]
  
  env:
    GSHEET_CLIENT_EMAIL: xxx
    GSHEET_PRIVATE_KEY: ***

Error: Range (xxx!A1017) exceeds grid limits. Max rows: 1016, max columns: 26

To Reproduce Append to a spreadsheet with all its rows filled.

You can click this button to make it work again. But ideally this would be automated.

Expected behavior Appending data still works even after filling the last row.

I've looked at the release notes since 1.0.0 as I realise I'm on an old version but it doesn't look like this behaviour has changed - please let me know if this is wrong.