I'm trying to figure out a way to search in a google sheet.
Following is what I'm trying to accomplish as a beginner.
I have a google sheet with these 3 columns and 1 record for sample
FileName || Sheet Link || Test Document
ABC 1.1 || http://SheetLink || Yes
Automate navigate to the SheetLink in the 2nd column of the record.
In the Sheet after navigating to the SheetLink search for "Test Document" provided in the sample above.
If "Test Document" is found update the previous google CSV column as Yes else no.
Following is what I tried on the studio:
On click on the RUN by the user, I navigated to this sheet using the GSuite's "Google Application suite".
Then use Read Range to get the spreadsheet ID.
Then used read row and read column. My problem is I'm unable to get the output from read row and read column to store in a variable.
Am I going the right direction? Reference would be great too.