This guide explains how to configure the "Get cell value" action to automatically read data from the last filled row of your Google Sheet.
Guide: Reading the Last Available Row
To set up the integration to read the last available data row in your Google Sheet, follow these steps:
1. Select the Sheet and Action
- In the
Google Sheetfield, select the document from which you want to read data. - In the
Actionfield, select theGet cell valueoption. - (Optional) If necessary, fill in the
Tab namefield to specify the internal sheet to use.
2. Define the Row to Read
- Scroll down to the configuration section for the "Get cell value" action. Here you need to define the column to read and the shortcode where you will save the data.
- Locate the field labeled
Row.
3. Enable Reading of the Last Row
- To instruct the system to read the last available data row (the lowest one containing a value), leave the
Rowfield completely empty. - Note: The placeholder text inside this field indicates
Last row, confirming that leaving it empty will apply this logic.
4. Complete the Configuration
- In the
Columnfield, enter the letter of the column from which you want to extract data (e.g.,A,B,C, etc.). - In the
Shortcodefield, enter the variable name (without curly braces) that will contain the value read from the Google Sheet (e.g.,extracted-value).
If you need to extract multiple values from the same row, you can use the Add variable button and repeat steps 3 and 4, making sure that the Row field remains empty for all added variables.
