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.
- Use a combination of
actions available in this package to automate
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:
|Activate sheet||Activates a specific sheet in the open spreadsheet.
|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.
|Create workbook||Creates a new workbook in your Google Drive.
|Delete cell||Deletes cells within a worksheet.
|Delete range||Delete a range of cells.
|Delete row/column||Deletes a row or column in a worksheet.
|Delete sheet||Deletes a sheet from the workbook.
|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.
|Get single cell||Retrieves the value from the specific cell in a Google sheet and
stores it in a string variable.
|Go to cell||Goes to the specified cell.
|Insert row/column||Inserts a blank row or column into a spreadsheet.
|Open spreadsheet||Opens an existing spreadsheet.
|Read column||Retrieves data from a column and stores it in a list variable.
|Read row||Retrieves data from a row and stores it in a list variable.
|Set cell||Sets the value of a specific cell.
|Write from data table||Writes the contents of a data table variable to a specific spreadsheet.