Note:

Use and transfer of information received from Google APIs to any other app will adhere to Google API Services User Data Policy, including the Limited Use requirements.
In accordance with the Nintex Privacy Policy, Nintex Services do not retain any information obtained from third party services.

Google Sheets - Delete rows or columns

Use the Google Sheets - Delete rows or columns action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to delete rows or columns from a specific sheet on a spreadsheet.

For more information about the Google Sheets connector, go to Google Sheets.

Before you begin:

Understand Variables

Jump to:

Configure the Google Sheets - Delete rows or columns action
Google Sheets - Delete rows or columns action fields, buttons, and settings

Configure the Google Sheets - Delete rows or columns action

Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

Select a Connection. If you do not have a connection, see Add a connection.
Select the Spreadsheet you want to delete the rows or columns from.
Click Add row or column details and specify the Sheet, Dimension, Start index, and End index details of the area you want to delete.
Add more row or column details as needed.

For more information on all the required and optional configuration fields, go to Google Sheets - Delete rows or columns action fields, buttons, and settings.

Google Sheets - Delete rows or columns action fields, buttons, and settings

Field	Description	Variable types
Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.	The Google Sheets connection to use to delete rows or columns from a sheet in a spreadsheet. To refresh the available connections, click .	(n/a)
Spreadsheet	The spreadsheet you want to delete rows or columns from. When you specify the Google Sheets connection, all the spreadsheets in the selected connection are available to select from in the drop-down list. If you want to select a spreadsheet that is not in the list, you can insert a variable in the Spreadsheet field. When using a variable, use the spreadsheet ID. A spreadsheet ID can be extracted from its URL. For example, the spreadsheet ID in the URL https://docs.google.com/spreadsheets/d/abc123 is "abc123".	Text, Decimal, Integer, Boolean, DateTime, Collection
Rows or columns	Details identifying the rows or columns to delete. Sheet: The sheet name or number within the spreadsheet that you want to delete the rows or columns from. Type a sheet ID value, such as 'Sheet1', or insert a variable in the Sheet field. Dimension: Select to delete columns or rows. Columns: Select columns if you want to delete columns in the sheet. Rows: Select rows if you want to delete rows in the sheet. Start Index: Type the value of the beginning row or column number (these values are zero based, so Row 1 = 0, Row 2 = 1, etc.). End index: Type the value of the ending row or column number (these values are zero based, so Row 1 = 0, Row 2 = 1, etc.). Click Add row or column details to add more areas to delete. To remove a configured area click the Row or column details ellipsis and select Delete.	(various)

Field

Description

Variable types

Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

The Google Sheets connection to use to delete rows or columns from a sheet in a spreadsheet.

To refresh the available connections, click Refresh .

(n/a)

Spreadsheet

The spreadsheet you want to delete rows or columns from. When you specify the Google Sheets connection, all the spreadsheets in the selected connection are available to select from in the drop-down list. If you want to select a spreadsheet that is not in the list, you can insert a variable in the Spreadsheet field. When using a variable, use the spreadsheet ID. A spreadsheet ID can be extracted from its URL. For example, the spreadsheet ID in the URL https://docs.google.com/spreadsheets/d/abc123 is "abc123".

Text, Decimal, Integer, Boolean, DateTime, Collection

Rows or columns

Details identifying the rows or columns to delete.

Sheet: The sheet name or number within the spreadsheet that you want to delete the rows or columns from. Type a sheet ID value, such as 'Sheet1', or insert a variable in the Sheet field.
Dimension: Select to delete columns or rows.
- Columns: Select columns if you want to delete columns in the sheet.
- Rows: Select rows if you want to delete rows in the sheet.
Start Index: Type the value of the beginning row or column number (these values are zero based, so Row 1 = 0, Row 2 = 1, etc.).
End index: Type the value of the ending row or column number (these values are zero based, so Row 1 = 0, Row 2 = 1, etc.).

Click Add row or column details to add more areas to delete.

To remove a configured area click the Row or column details ellipsis and select Delete.

(various)