This guide explains how to configure the "Get cell value" action to read data from a Google Sheet and save it into a new custom shortcode, which can be used in later stages of your automation.
Prerequisite: You must have selected the Google Sheet and, if necessary, specified the Sheet Name from which to read the data.
Procedure for Assigning the Shortcode
1. In the Google Sheets Settings section, locate the Action field.
2. Select the Get cell value option.
3. Under this setting, click the Add variable button to add a new configuration block.
4. In the new block, define the position of the cell from which you want to read data:
- In the Row field, enter the row number. If left empty, the system will read the last available row.
- In the Column field, enter the column letter (e.g.,
A,B,C).
5. In the Shortcode field, enter the identifier you want to assign to the read data (e.g., dati-foglio).
- Note: You only need to enter the shortcode name; curly braces
{ }are added automatically by the system.
Once saved, the value read from the specified cell will be available for use in any subsequent text or variable in your automation using the newly created shortcode (e.g., {dati-foglio}).
