Google sheets module is not reading all my rows

Questions
1

:bullseye: What is your goal?

Hi,

I am trying to set up a simple workflow that allows me to automate email sending based on certain metrics on my google sheets.

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

I have a Google Sheets file with approximately 1,500 rows.
The rows are populated with creators (on Instagram) and their corresponding follower count. For context, I have creators ranging from 100-2M followers.

I am trying to simply filter all creators with less than 100k followers. Manually doing this on sheets works just fine, however I need this basic functionality to work on make.com because I have a pipeline that eventually will send out emails.

When I try to add a filter to the module:
Column B ≤ 100,000

It only ever returns with 27 results (rows). I then removed the filter and ran it without any filters, and it returned all rows in my sheet (1,500).

I am quite stumped as to why I keep getting 27 results, when in fact it should be around 1000.

I have around 10k credits (which I initially thought was the problem, but its not).

The colomn on my Google Sheets is in number format.
The filter is numeric operators: less than or equal to 100000

Would appreciate some guidance, thanks a lot!

3

This is strange this may be caused by some sort of data mismatch. Is there any way that you can actually do the filter either in Sheets or in the Search step so you do not need the actual bundle filter for your module? There is an option to do this. You can select the “Search Rows(Advanced)” module.

See the screenshots below

CleanShot 2026-04-22 at 10.30.21@2x
CleanShot 2026-04-22 at 10.30.21@2x1280Ă—1036 73.4 KB

CleanShot 2026-04-22 at 10.28.49@2x
CleanShot 2026-04-22 at 10.28.49@2x1558Ă—1190 118 KB

This should allow you to set the filter right in your row search criteria. This may help with your issue. Is this possible for you?

4

Hey there,

Can you check what the data looks like on an entry that didn’t match the filter but should have? Also sending emails like that is a surefire way to get your account flagged as a spammer and the emails landing in the spam folder.

5

Hi Stoyan, Thanks for your reply.

I actually figured it out. The value render option was previously on formatted value. I changed it to unformatted value and it worked instantly!