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 - Insert empty rows or columns

Use the Google Sheets - Insert empty 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 insert empty rows or columns into a specific sheet on a spreadsheet.

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

Before you begin: 

Jump to:

Configure the Google Sheets - Insert empty rows or columns action

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

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

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

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

Section

Field

Description

Variable types
(unlabeled)

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 for inserting empty rows or columns into a spreadsheet.

To refresh the available connections, click Refresh.

(n/a)
 

Spreadsheet

The spreadsheet you want to insert rows or columns into. 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 add. Click Add row or column details to configure the details of the area of the sheet you want to add to the spreadsheet.

  • 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 add 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.).

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

(various)

Output

Spreadsheet

Stores the result of the action as an object with the following variable:

  • Spreadsheet: (Text) The name of the updated spreadsheet.

 Object