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.
Note: 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	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.

Automation 360

Google Sheets package