GoogleSheet Lookup action
Our GoogleSheet Lookup action, allows you to lookup data within your Google Sheets documents, providing you with a powerful tool for managing your data workflows.
Using our system, you can easily look up any row in your sheet, and use the custom values associated with that row within your workflow. It can do a case-sensitive search in a spreadsheet.
This functionality allows you to automate complex data management processes, such as cross-referencing data from multiple sheets or databases.
By leveraging the power of our workflow system, you can reduce errors, increase efficiency, and save time, all while ensuring the accuracy and completeness of your data.
With our lookup functionality, you can easily integrate your Google Sheets documents into your workflow processes, creating powerful data management workflows that help you to drive better outcomes.
Choose a worksheet:
Select a worksheet within your spreadsheet that you wish to use for Looking up and retrieving data.
Select a Column and Lookup Value to find the matching row
The first row is considered as Headers and the same is shown as labels for each column. You can fetch the latest headers from the sheet by clicking "Refresh Headers".
Select an extra Column and Lookup Value
If an extra column is added, then both the column's values should match to determine the matching row.
Using as Custom Variables:
One of the advantages of using lookup is that when you search for a particular row, all of its data can be saved as a custom value that can be utilized throughout your entire workflow.
Consider the following worksheet as an example. If you need to search for a specific row, you can enter the contact phone number or email address in the lookup section. Once the lookup function finds the matching row, it will store all the values under the corresponding header name as custom variables.
When you add a Lookup action, an index is automatically generated. This index is essential for mapping the row data to the custom variables and allows for easy identification of multiple lookup values. It is not possible to remove or edit the index once it is added.
The values obtained from the lookup action for a particular row can be used in all other actions within your workflows, just like any other contact fields or custom variables.
Note: As previously mentioned, the index generated by the lookup function serves as a reference and is used for internal mapping of the custom variables in lookup actions.
To get the row number of the lookup value you can use {{sheet.x.rowNumber}}.
Here x is the index of the lookup action.
Example:
The custom values of LookedUp Row can be utilized in all of the actions within your workflow. Some examples of how to do this are provided below.
In Communication Actions:
In If/Else:
Notes:
-
If the Google Sheets Lookup Action is unable to find a matching row, all subsequent Google Sheets Actions that reference this Lookup Action will be skipped due to lack of a result.
-
Since the Lookup Action results are available for If/Else Conditions you can use those to decide whether to create a spreadsheet row or update the spreadsheet row using Lookup, based on the Condition of having a Lookup Result or not.
Case Sensitivity Search
-
By default, "Case Sensitivity Lookup" is disabled, meaning that the lookup will not take into account any case sensitivity.
-
You can enable "Case Sensitivity Lookup" to do a case-sensitive lookup.
Example:
(a) If Case Sensitivity Lookup is disabled:
"John" === "john" is true and returns the matching row
(b)If Case Sensitivity Lookup is enabled:
"John" === "john" is false and does not return any matching row