Can’t scale anything on Glide without database capacity.
A free gSheet has 10,000,000 cell capacity. Glide should at LEAST be able to utilize all of that. Whether that’s a 1-time import to Glide Tables, and running everything on Glide Tables from there (can’t expect Glide to constantly call Google API’s), or something else.
But scalability is badly needed. Targeting 1m rows is a good start (not for $XX,XXX/mth either).
For market perspective, I can likely run 1m users on Firebase for $50-100/mth in cloud costs, depending on the app. Hard coded though.
Would happily pay $500mth for 1m usage based rows for a plug n play builder, to skip hard coding.