I would like to load a few thousand rows of data from a google sheet and display it in a table grid in the app. But, when using it with the mobile app, the app keeps crashing because of the data loading. Is there a way to load a large number of rows of data into the app without affecting user experience and performance?
You can look at the best practices article for App design.
Also, few thousand rows of data on a mobile app may not be a good user experience. Can you try providing search and filter option to show few 100s rows instead?
Let me know if this works for you. Hope this Helps!