Delete Rows or Columns
Use this action to delete the specified rows or columns from the a spreadsheet.
Using the Delete Rows or Columns Action
To use this action in your workflow, connect it to ThingWorx Flow. To connect to the flow, do the following:
1. Drag the Delete Rows or Columns action under the Google Sheets connector to the canvas, place the pointer on the action, and then click 
or double-click the action. The Delete Rows or Columns action window opens.
or double-click the action. The Delete Rows or Columns action window opens.2. Edit the label name, if needed. By default, the label name is same as the action name.
3. To add a new authorization, refer to the section Authorize Google Sheets in the Google Sheets connector topic.
 | If you previously added a Google Sheets authorization, select an authorization from the list. |
4. In the Spreadsheet ID field, select or specify the ID of the spreadsheet in which you want to delete rows or columns.
5. In the Select Data section, select or specify the data that follows:
◦ Sheet ID—Select or specify the sheet ID.
◦ Dimension—Select a dimension to delete.
◦ Start Index—Enter the start index such as 1.
◦ End Index—Enter the end index such as 5.
| | The start index and end index number should not start with 0. |
To add multiple data fields, click Add.
6. Click Done.