This guide explains how to configure the "Get cell value" action to read a specific data from a Google Sheet and save it as a variable (Shortcode) usable in the subsequent steps of your automation.
Procedure to Add a Variable
To add a variable of type "retrieve," you must first ensure that the selected action is the correct one.
1. In the Google Sheets Settings section, verify that the Action field is set to Get cell value.
2. Under the Action field, click the Add variable button. A new configuration row will be added.
3. Configure the variable by filling in the following fields:
- Row: Enter the row number from which you want to read the data. If you leave this field empty, the default value
Last rowfilled in the sheet will be used. - Column: Enter the letter of the column (e.g., A, B, C, etc.) from which to get the data.
- Shortcode: Enter a unique identifier for the variable that will be created (for example:
prezzo-prodottoorcodice-cliente). The value read from the cell will be saved in this Shortcode, which you can later call in your automation using the syntax{shortcode-id}.
4. Repeat steps 2 and 3 for each additional variable you want to retrieve from the Google Sheet.
