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

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