Google Sheets Delete Row
Status: Closed · Asked by aidan cottrell on · 0 views
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.
https://developers.google.com/sheets/api/samples/rowcolumn
"updateDimensionProperties": {
"range": {
"sheetId": sheetId,
"dimension": "ROWS",
"startIndex": 0,
"endIndex": 3
This is already in the pending queue as told to me earlier.
It should come soon
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.
https://developers.google.com/sheets/api/samples/rowcolumn"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.
Thankyou amazing! Much appreciated.