# Google Sheet Search Rows Advanced only returning 100 results **URL:** \ **Category:** Questions\ **Tags:** google-sheets\ **Created:** [December 20, 2025, 11:52am UTC](https://community.make.com/t/google-sheet-search-rows-advanced-only-returning-100-results/99296 "2025-12-20T11:52:52Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Brett\_Lensvelt](https://avatars.discourse-cdn.com/v4/letter/b/958977/32.png) [@Brett\_Lensvelt](https://community.make.com/u/Brett_Lensvelt)\ **Post date:** [December 20, 2025, 11:52am UTC](https://community.make.com/t/google-sheet-search-rows-advanced-only-returning-100-results/99296/1 "2025-12-20T11:52:52Z")
### 🎯 What is your goal? Return all rows matching my Query statement ### 🤔 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 ---
**Author:** ![Karmic](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/karmic/32/84311_2.png) [@Karmic](https://community.make.com/u/Karmic)\ **Post date:** [December 20, 2025, 11:54am UTC](https://community.make.com/t/google-sheet-search-rows-advanced-only-returning-100-results/99296/3 "2025-12-20T11:54:07Z")
Please send relevant screenshots about this. Thanks! ---
**Author:** ![Brett\_Lensvelt](https://avatars.discourse-cdn.com/v4/letter/b/958977/32.png) [@Brett\_Lensvelt](https://community.make.com/u/Brett_Lensvelt)\ **Post date:** [December 20, 2025, 12:13pm UTC](https://community.make.com/t/google-sheet-search-rows-advanced-only-returning-100-results/99296/5 "2025-12-20T12:13:47Z")
Total number of records: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/6/b668977b0f371fed4c52c64b0f7a91e4c888a940.png) **Input Configuration:** ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/4/b41670e1e2b0eecbdc319e9c28c93347e0cb7847.png) **Output - only 5 records in this instance:** ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/f/4f2f122b892f28a8c4fc424b9d7b1d59b4a8339a.png) ---
**Author:** ![Karmic](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/karmic/32/84311_2.png) [@Karmic](https://community.make.com/u/Karmic)\ **Post date:** [December 20, 2025, 12:36pm UTC](https://community.make.com/t/google-sheet-search-rows-advanced-only-returning-100-results/99296/6 "2025-12-20T12:36:40Z")
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. ---
**Author:** ![Brett\_Lensvelt](https://avatars.discourse-cdn.com/v4/letter/b/958977/32.png) [@Brett\_Lensvelt](https://community.make.com/u/Brett_Lensvelt)\ **Post date:** [December 20, 2025, 12:41pm UTC](https://community.make.com/t/google-sheet-search-rows-advanced-only-returning-100-results/99296/7 "2025-12-20T12:41:17Z")
Thanks - I appreciate your taking the time to take a look 🙏 ---
**Author:** ![Karmic](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/karmic/32/84311_2.png) [@Karmic](https://community.make.com/u/Karmic)\ **Post date:** [December 20, 2025, 12:42pm UTC](https://community.make.com/t/google-sheet-search-rows-advanced-only-returning-100-results/99296/8 "2025-12-20T12:42:20Z")
No problem! I’m more than willing to help you with this so you’ll get this sorted out right away. ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [March 20, 2026, 12:57pm UTC](https://community.make.com/t/google-sheet-search-rows-advanced-only-returning-100-results/99296/9 "2026-03-20T12:57:04Z")