Google Sheets package

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

Before you start

Use the actions in the Google Sheets package in the following order:

Use the Connect action to establish a connection to the Google server.
See Using the Connect action for Google packages.
Use a combination of actions available in this package to automate tasks.
注： To use actions from other Google packages, establish a connection using the Connect action from that package.
Use the Disconnect action to terminate the connection.

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. 注： The sheet index count begins at 1.
Autofit columns	Resizes the columns that contain data to accommodate the data. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action.
Autofit rows	Resizes the rows that contain data to accommodate the data. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action.
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 sheet	Creates a new sheet in the open workbook. 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. 注： The sheet index count begins at 1.
Create workbook	Creates a new workbook in your Google Drive. Enter the username you used in the Connect action. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Enter the workbook name with one of the following file extensions: .xlsx, .xls, or .xlsm Enter the file path for the new workbook or select a file variable.
Delete cell	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 range	Delete a range of cells. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Enter the range address. For example `A1:B4`. Select the direction in which to shift the remaining active cells: Up or Left.
Delete row/column	Deletes a row or column in a worksheet. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Select whether to perform a row or column operation. Specify whether to delete the sheet by index or name. Specify whether to delete by index, active cell, or range. If you select index, enter the row/column index 注： The index count begins at 1. If you select range, specify the range of the rows/columns to delete. For example `1:10` to delete the first ten rows.
Delete sheet	Deletes a sheet from the workbook. 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.
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.
Insert row/column	Inserts a blank row or column into a spreadsheet. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Select whether to insert a row or column. If you chose row, select whether to insert the row at a specific index, above the active cell, or in a range. 注： The index count begins at 1. If you chose column, select whether to insert the column at a specific address, to the left of the active cell, or in a range.
Open spreadsheet	Opens an existing spreadsheet. Enter a session name. Use this session name in subsequent actions to associate them with this spreadsheet. In the Username field, enter the same username that you provided in the Connect action. 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.
Write from data table	Writes the contents of a data table variable to a specific spreadsheet. Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action. Select whether to write to the currently active sheet or to specify a sheet name. Select the data table variable. Enter the cell address where to start writing the data.

Automation 360