Google Sheets package

The Google Sheets package contains actions that enable you to automate tasks involving cells, columns, rows, and sheets.

Before you start

Perform the following actions within the Google packages as part of using the set of available actions:

Use the OAuth action from the G-Suite Apps package to establish a connection to the G-Suite server. For more information on establishing a connection, see the G-Suite Apps package.
Use the Open spreadsheet action from the Google Sheets package to select a workbook, or the Create spreadsheet action to create a new workbook.
Optional: If the workbook contains more than one sheet, use the Activate sheet action to specify which sheet to use.
Use the Close action to exit from the workbook.

Actions in the Google Sheets package

The actions in the Google Sheets package enable you to perform the following operations:


Action	Description
Activate sheet	Activates a specific sheet in the open spreadsheet. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Specify whether to activate the sheet by index or name.
Create spreadsheet	Creates a new spreadsheet in your Google Drive. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Optional: Enter the file path. If you do not enter a value, the spreadsheet will be created under my-drive. Enter the spreadsheet name. Select a variable to hold the ID of the created spreadsheet.
Close	Saves and closes the current spreadsheet. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action.
Create worksheet	Creates a new sheet in the open spreadsheet. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Specify whether to create the sheet by index or name
Delete cells	Deletes cells within a worksheet. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Select either the Active cell or Specific cell option. If you have selected the Specific cell, enter the cell address. Select from the following delete options: Shift cells left Shift cells up Entire row Entire column
Delete worksheet	Deletes a sheet from the current spreadsheet. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Specify whether to delete the sheet by index or name.
Find cells which contains search key	See Using the Find action
Get multiple cells	Retrieves the values from the cells in a Google sheet and stores them in a table variable. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Select the Multiple cells option to retrieve values from a range of cells, or select All cells to retrieve values from all the cells. Select or create a table variable to hold the output.
Get single cell	Retrieves the value from the specific cell in a Google sheet and stores it in a string variable. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Select either the Active cell or Specific cell option. If you have selected the Specific cell, enter the cell address. Select or create a string variable to hold the output.
Go to cell	Goes to the specified cell. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Select either the Specific cell or Active cell option. If you have selected the Specific cell option, enter the cell address. For example, `B4`. If you have selected the Active cell option, select the direction in which to move from the active cell.
Open spreadsheet	Opens an existing spreadsheet. Enter a session name. Use this session name in subsequent actions to associate them with this spreadsheet. Select whether to open the spreadsheet by name, URL, or spreadsheet ID: Name: Enter the file name. URL: Enter the entire URL. Spreadsheet ID: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. If the spreadsheet contains multiple sheets, select the Specific sheet name option and enter the sheet name.
Read column	Retrieves data from a column and stores it in a list variable. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. In the Cell name field, specify the cell location from which to read the values. For example, enter A5 to retrieve all the values located in the first column, below the fifth row. You can also select the Read full column option to extract values from the entire column. Select or create a list variable to hold the output.
Read row	Retrieves data from a row and stores it in a list variable. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. In the Cell name field, specify the cell location from which to read the values. For example, enter D5 to retrieve the values located in the fifth row and right of the fourth column. You can also select the Read full row option to extract values from the entire row. Select or create a list variable to hold the output.
Set cell	Sets the value of a specific cell. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Enter the address of the cell. For example A5. Enter the value to set. Select or create a string variable to hold the value of the cell.

Product

Version

Task

Information Type

Google Sheets package

Before you start

Actions in the Google Sheets package

Documentation

Contents

Child Topics

Product

Version

Task

Information Type

Google Sheets package

Before you start

Actions in the Google Sheets package

Documentation

Contents

Child Topics

Related Content

Add to My Topics

Choose collection

Create a Collection

Rate this topic

Error