Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Google Sheets package

  • Updated: 2022/07/27
    • 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