look up spreadsheet for a keyword

[Andres]

I want to get all the new rows thath have a specific key word. I used the look up function, but it only responds the fir row not all the other that keeps adding up.

 

[ArshilAhmad]

The "Lookup Spreadsheet Rows" action event captures all the rows that contain the Lookup Value. Please note that the value will only be looked up within the first 100 rows.

 

[Andres]

When I run the test, it keeps returning just the first row, not all the new / other rows.

 

[Andres]

How can I capture every new row that has the keyword FORET to either send an email, message, or add a new row.

 

[ArshilAhmad]

You can disable the Simple Response, then click on 'Save & Send Test Request.' This will give you the entire data in array format.