Find Spreadsheet Row
Finds a row in Google Sheets
- Google Sheet to search through
- Conditions to use to find the spreadsheet row
- Text conditions (e.g. "Text is exactly", "Text contains") are case-insensitive
- Whether to start searching from the bottom of the sheet rather than from the top
- Allows getting the most recent result if there are multiple matches
- Variable to store the row number
- The row number will be -1 if there is no match
- Checking to see if an item already exists in a spreadsheet to avoid adding duplicates
Last modified 1yr ago