My solution to this is setting the data in a different google sheet and using 2 import ranges to get my results, it does create a small delay but it allows the app to work properly. With that being said I did have to use a script to add new information to the other google sheet since Glide cannot enter data in additional sheets.
If your curious about the doube importranges it goes like this:
1- The data you are looking up or referencing is imported to the sheet with all the data.
2- The second sheet houses all of your lookups.
3- That sheet returns the result in the same list format as your Glide google sheet.
4- The Glide google sheet imports the results as the 2nd import range.
It’s that simple. Heres what my 2 sheets look like doing this for Glide:
And this solution pulls from a google sheet of 95,000+ rows