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.
|
Create spreadsheet |
Creates a new spreadsheet in your Google Drive.
- Enter the name of the session used to open
the current spreadsheet with the Open
spreadsheet
action.
- Optional: Enter the file path. If you do not enter a
value, the spreadsheet will be created under
my-drive.
- Enter the spreadsheet name.
- Select a variable to hold the ID of the created
spreadsheet.
|
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 worksheet |
Creates a new 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 create the sheet by index or
name
|
Delete cells |
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 worksheet |
Deletes a sheet from the current spreadsheet.
- 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.
|
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.
|