• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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

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:
 
Top