Definition and Usage
Retrieving content from the sheet by specifying the read method, such as reading a single cell, row, column, or range of data. This command allows you to extract specific information from Google Sheets and store it in variables for further processing in your workflow.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Google Sheet | Select the Google sheet to read |
| Yes | Must be a previously connected Google Sheet |
Read by | Select the method to read data from the Google Sheet | Get cell, Get one row, Get one column, Get a range | Yes | Different reading methods require different parameter inputs |
Row | Enter the row number (starts from 1) |
| Depends on read method | Required when reading a cell or a row |
Column | Specify the column using either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) |
| Depends on read method | Required when reading a cell or a column |
Starting row | Enter the row number (starts from 1) |
| Depends on read method | Required when reading a range |
Ending row | Enter the row number (starts from 1) |
| Depends on read method | Required when reading a range |
Starting column | Specify the column using either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) |
| Depends on read method | Required when reading a range |
Ending column | Specify the column using either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) |
| Depends on read method | Required when reading a range |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
The command produces a variable that stores the retrieved data. The output variable type depends on the chosen read method:
Text value: When reading a single cell
Text list: When reading a row or a column
Data table: When reading a range of cells
Using Variables in Conditions
You can use variables in parameter fields where the {x} icon appears. This allows you to dynamically set values like row or column numbers based on previously defined variables. For example, you could use a counter variable to read consecutive rows in a loop, or use a text variable to specify which column to read based on user input.
Notes
Before using this command, ensure you have properly connected to the Google Sheet you want to read from.
Row numbers start from 1, not 0 as in some programming languages.
Columns can be specified either by letter (A, B, C) or by number (1, 2, 3).
Using -1 as a row or column value will reference the last row or column with data.
When reading a range, ensure that the ending row/column is greater than or equal to the starting row/column.
The command will fail if trying to read from cells outside the sheet's boundaries.