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 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 See Activate sheet action in Google Sheets.
Autofit columns See Autofit columns action in Google Sheets.
Autofit rows See Autofit rows action in Google Sheets.
Close See Close action in Google Sheets.
Create sheet See Create sheet action in Google Sheets.
Create workbook See Create workbook action in Google Sheets.
Delete cell See Delete cell action in Google Sheets.
Delete range See Delete range action in Google Sheets.
Delete row/column See Delete row/column action in Google Sheets.
Delete sheet See Delete sheet action in Google Sheets.
Disconnect See Disconnect action.
Format cells See Format cells action.
Get All Sheet Names See Get All Sheet Names action.
Get Cell/text color See Get Cell/text color action.
Get Current Sheet Name See Get Current Sheet Name action.
Get multiple cells See Get multiple cells action in Google Sheets.
Get number of rows See Get number of rows action.
Get single cell See Get single cell action in Google Sheets.
Go to cell See Go to cell action in Google Sheets.
Hide worksheet See Hide worksheet action.
Insert cell See Insert cell action.
Insert range See Insert range action.
Insert row/column See Insert row/column action in Google Sheets.
Open spreadsheet See Open spreadsheet action in Google Sheets.
Paste cell See Paste cell action
Read cell formula See Read cell formula action
Read column See Read column action in Google Sheets.
Read row See Read row action in Google Sheets.
Rename sheet See Rename sheet action.
Retrieve Sheets count See Retrieve Sheets count action.
Set cell See Set cell action in Google Sheets.
Set cell formula See Set cell formula action
Set cell or text color See Set cell or text color action
Show worksheet See Show worksheet action
Write from data table See Write from data table action in Google Sheets.