Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Google Sheets package

  • Updated: 4/12/2021
    • Automation 360 v.x
    • Build
    • RPA Workspace

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:
  1. Use the Connect action to establish a connection to the Google server.

    See Using the Connect action for Google packages.

  2. Use a combination of actions available in this package to automate tasks.
    Note: To use actions from other Google packages establish a connection using the Connect action from that package.
  3. 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.
    Note: 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.
    Note: 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
      Note: 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.
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.
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.
      Note: 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.
  • 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.
Send Feedback