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"
I'm trying to create an automation similar to this:
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"