Google Sheets Delete Row

[aidan cottrell]

Hi, with the Google Sheets delete row action, it appears that a sheetId (gid) of has been hardcoded to "0", as you state that the selected sheet must be at the first index of the spreadsheet to make the action work.

Can you adjust the api call so that we can specify other sheets? Seems like it would be a pretty simple fix as you are already getting the sheet objects from the connection.

Row & column operations | Google Sheets | Google for Developers

developers.google.com

"updateDimensionProperties": {
"range": {
"sheetId": sheetId,
"dimension": "ROWS",
"startIndex": 0,
"endIndex": 3

 

[Fagun Shah]

This is already in the pending queue as told to me earlier.
It should come soon

 

[Fagun Shah]

Hi, with the Google Sheets delete row action, it appears that a sheetId (gid) of has been hardcoded to "0", as you state that the selected sheet must be at the first index of the spreadsheet to make the action work.

Can you adjust the api call so that we can specify other sheets? Seems like it would be a pretty simple fix as you are already getting the sheet objects from the connection.

Row & column operations | Google Sheets | Google for Developers

developers.google.com

"updateDimensionProperties": {
"range": {
"sheetId": sheetId,
"dimension": "ROWS",
"startIndex": 0,
"endIndex": 3

They replied on my thread(private) that they have made the required changes and now it supports the selection of sheets instead of 1st sheet of the spreadsheet.

Check it from your side once.

 

[aidan cottrell]

Thankyou amazing! Much appreciated.