Google Sheets - Lookup Spreadsheet Rows - question

[Praveen]

What exactly does "The response will return the 100 searched rows only." mean?

Does it mean that only the 1st 100 Rows of the spreadsheet will be searched for the Lookup value?

 

[Pabblymember11]

Hey @Praveen

According to the help text, if the actions step finds a row with your desired data, it can only put 100 records in the response received if there are more than 100 records present with the same entity.

 

[Praveen]

@Supreme Thanks for the clarification. Can you please share the link to this help text that you are referring to?

 

[Pabblymember11]

It's only been written on the help text of the action step. If you have any queries related to this do let us know.