look up spreadsheet for a keyword

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.

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.

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

Attachments

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

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