• 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.

Lookup Spreadsheet Rows not returning row index

ValeP

Member
Hi,
I'm trying to create an automation similar to this:
I have a google sheet lets say "sheet A" where I want to monitor if any row is updated. I used the trigger "new or updated row in google sheet" and it works. In the trigger I get the data of the updated row.

Then I need to look for the matching row in another file, lets say "sheet B".
I tried to use "Lookup Spreadsheet Rows" I selected "sheet B" as file where to look for the info,
Lookup Column(s) "B" that is the only column wher to search for the info
Lookup Value (Required): the mapped field from the trigger step
I only get 3 lines as response and there's no "row index" like in the tutorial...
having no row index I cannot copy updated info from "sheet A" in the right row of "sheet B"

 

Attachments

  • Schermata 2023-01-02 alle 17.44.36.png
    Schermata 2023-01-02 alle 17.44.36.png
    196.8 KB · Views: 144
  • Schermata 2023-01-02 alle 17.54.13.png
    Schermata 2023-01-02 alle 17.54.13.png
    191.5 KB · Views: 142

Fagun Shah

Well-known member
Type capital letter B in looup column field and make sure the value you're searching for is available in the Sheet B's column B.
 

ValeP

Member
Type capital letter B in looup column field and make sure the value you're searching for is available in the Sheet B's column B.
It doesn't work even with the capital B and yes, the value I'm searching is available in that column...
 
Top