Delete Rows or Columns
Use the Delete Rows or Columns action to delete specified rows or columns from a spreadsheet.
Complete the following steps to use the Delete Rows or Columns action in your workflow:
1. Drag the Delete Rows or Columns action under Google Sheets to the canvas, place the pointer on the action, and then click 
or double-click the action. The Delete Rows or Columns window opens.
or double-click the action. The Delete Rows or Columns window opens.2. Edit the Label, if needed. By default, the label name is the same as the action name.
3. To add a Google Sheets connector type, refer to Supported Google Sheets Connector Types.
If you previously added a connector type, select the appropriate Connector Type, and under Connector Name, select the connector.
4. Click TEST to validate the connector.
5. Click MAP CONNECTOR to execute the action using a connector that is different from the one that you are using to populate the input fields. In the Runtime Connector field, provide a valid Google Sheets connector name. For more information about MAP CONNECTOR, see Using Map Connector.
6. In the Spreadsheet ID list, select or specify the ID of the spreadsheet in which you want to delete rows or columns.
7. Under the Select Data group, do the following:
a. In the Sheet ID list, select or specify the sheet ID.
b. In the Dimension list, based on what you want to delete, select one of the following options:
▪ ROWS
▪ COLUMNS
c. In the Start Index field, provide the start index. This value must not start with 0.
d. In the End Index field, provide the end index. This value must not start with 0.
Click Add to add data for multiple sheets. Click 
to delete any sheet data that you added.
to delete any sheet data that you added.8. Click Done.
Output schema
