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

    🖤 BLACK FRIDAY DEALS ARE NOW LIVE! 🖤

    🔥 Enjoy an exclusive 10% discount on our LTD Plan — first-time ever offer!

    🚀 Unlock the Pabbly Plus Unlimited Yearly Plan and get unlimited access to every Pabbly application at a truly unbeatable Black Friday price.

    👉 Grab the Black Friday Offer

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: 173
  • Schermata 2023-01-02 alle 17.54.13.png
    Schermata 2023-01-02 alle 17.54.13.png
    191.5 KB · Views: 175

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