Google Sheet Search Rows Advanced only returning 100 results

Questions
1

:bullseye: What is your goal?

Return all rows matching my Query statement

:thinking: What is the problem & what have you tried?

I am only receiving 100 rows back, even though I have set the limit to 30,000

3

Please send relevant screenshots about this. Thanks!

5

Total number of records:

image
image265×109 3.38 KB

Input Configuration:

image
image563×851 43.5 KB

Output - only 5 records in this instance:

image
image458×663 24.9 KB

6

Looking at the screenshots. I don’t see anything wrong with it. So it’s not your query, maybe Make is capping your results.

After some digging, I’ve found that Google Sheets (Search Rows) has a 100-row limit.

It’d be a good idea to do this in batches per filter, or paginate/loop in chunks to stay below the 100 rows limit.

The issue with only 5 bundles returned, that is quite odd. Please upload all relevant screenshots so we can troubleshoot it further.

7

Thanks - I appreciate your taking the time to take a look :folded_hands:

8

No problem! I’m more than willing to help you with this so you’ll get this sorted out right away.