Hmm, this must still be a bug. I’ve noticed the same problem where all rows do not load from the google sheet even though you are under the limit. I’ve had the same problem with one of my projects, but I haven’t had time to check it again or research it some more. I mentioned it to one of the glide employees in an experts chat a couple weeks ago, but I haven’t had a chance to read the response.
It sounds similar to this thread.