How to get the row id when search term matches column value in Google Sheets?

[limitcracker]

Hi,

1. I get a response from Blocksurvey.
2. Then I use Text Formater step to remove the part I don't want and keep only the second part.
3. I want to search the term in column F in my sheet.
4. I want to use the ROW ID of the matched row that contained the unique search term.
5. Then I want to make updates on this row now that I have the ROW ID.

I have problem on step 3 & 4. I don't know how to get the ROW ID of the matched term.

Here is my workflow:

Pabbly Connect

connect.pabbly.com

 

[Himesh]

Hi,

1. I get a response from Blocksurvey.
2. Then I use Text Formater step to remove the part I don't want and keep only the second part.
3. I want to search the term in column F in my sheet.
4. I want to use the ROW ID of the matched row that contained the unique search term.
5. Then I want to make updates on this row now that I have the ROW ID.

I have problem on step 3 & 4. I don't know how to get the ROW ID of the matched term.

Here is my workflow:

Pabbly Connect

connect.pabbly.com

Hello @limitcracker ,
This video might be helpful to you.

in response you'll get rowIndex (Your unique row Id) and after that yoo can use update cell value or update row as per your requirement. If you are still not able to solve this on your own feel free to DM me and we can do a free zoom call. FYI I'm not from Pabbly Connect team, just a freelancer who helps other Pabbly users.

 

[limitcracker]

Hello @limitcracker ,
This video might be helpful to you.

in response you'll get rowIndex (Your unique row Id) and after that yoo can use update cell value or update row as per your requirement. If you are still not able to solve this on your own feel free to DM me and we can do a free zoom call. FYI I'm not from Pabbly Connect team, just a freelancer who helps other Pabbly users.

Hi thanks!
Ok I got {"rowIndex"} from my Google Sheet Lookup result.
Then I used Iterator (Pabbly) step.
That was the catch!
So now I can use it in the next step Google Sheet Update Cell.

Thanks a lot! Solved!

 

[Himesh]

Hi thanks!
Ok I got {"rowIndex"} from my Google Sheet Lookup result.
Then I used Iterator (Pabbly) step.
That was the catch!
So now I can use it in the next step Google Sheet Update Cell.

Thanks a lot! Solved!

Your welcome