This guide explains how to configure the "Get cell value" action to retrieve a specific data from a Google Sheet and save it in a variable (Shortcode) usable in your system.
Define the row and column from which to get the value
To retrieve a value from a specific cell, follow these steps:
1. In the Google Sheets Settings section, make sure you have selected the correct Google Sheet.
2. In the Action field, select Get cell value.
3. Under the configuration area, locate the section related to the "Get cell value" action. If necessary, use the duplication button (usually "Add variable") to define a new cell to read.
4. In the Row field:
- Enter the exact number of the row from which you want to get the value (e.g.,
5). - Tip: If you leave this field empty, the system will automatically use the Last filled row of the sheet.
5. In the Column field:
- Enter the letter of the column from which you want to get the value (e.g.,
A,B,C, etc.). This field is mandatory.
6. In the Shortcode field:
- Define a unique name (only lowercase letters, numbers, and hyphens) for the variable that will contain the retrieved value.
- The value read from the specified cell (Row and Column) will be saved in this Shortcode and can be used in subsequent automation steps by calling it as
{shortcode-name}.
Example: If you set Row: 10, Column: C and Shortcode: prezzo-prodotto, the system will read the value of cell C10 and save it in the variable {prezzo-prodotto}.
