Unable to obtain worksheet id using the available google sheet operations which is required for create empty row or column & delete worsheet operations #2796
As a user I am unable to obtain worksheet id using the available google sheet operations which is required for create empty row or column & delete worksheet operations
Steps to Reproduce
When I "create new worksheet", the result variable doesn't populate the ID. It is also not possible for the user to set the worksheet ID while creating this new worksheet.
This ID is needed for performing other important google sheet operations like create empty column or row and delete worksheet.
The worksheetID cannot be retrieved or known or set using existing google sheet connectors operations.
Therefore, I am unable to utilize the google sheets connector in my workflow and need to utilize the official google sheets API.
Documentation specifies that Start and End index can be empty. However, if empty, it is not possible to deploy the diagram.
Expected Behavior
When I create the new worksheet the response should return the sheet id. So that it can be used in other operations. This is the response received using the official google sheet API
OR I should be able to perform create empty column or row and delete worksheet operations using the worksheet name.
Describe the Bug
As a user I am unable to obtain worksheet id using the available google sheet operations which is required for create empty row or column & delete worksheet operations
Steps to Reproduce
When I "create new worksheet", the result variable doesn't populate the ID. It is also not possible for the user to set the worksheet ID while creating this new worksheet.
This ID is needed for performing other important google sheet operations like create empty column or row and delete worksheet.
The worksheetID cannot be retrieved or known or set using existing google sheet connectors operations.
Therefore, I am unable to utilize the google sheets connector in my workflow and need to utilize the official google sheets API.
Documentation specifies that Start and End index can be empty. However, if empty, it is not possible to deploy the diagram.
Expected Behavior
When I create the new worksheet the response should return the sheet id. So that it can be used in other operations. This is the response received using the official google sheet API
OR I should be able to perform create empty column or row and delete worksheet operations using the worksheet name.
Environment