Error when connecting to Google Sheet

[James_Fussell]

I have a Google sheet which is connected to several AppSheet Apps. I am now trying to add it to another one and it will not allow. Here is a screenshot of the issues

Any suggestions?

[Steve]

Reduce the number of rows in the spreadsheet?

[James_Fussell]

Thanks Steve. That worked. I thought that a Google Sheet could handle a lot more than 100,000 rows. What route would you recommend for larger databases? What’s the next step up from a Google Sheet?

[Steve]

help.appsheet.com

Limits on Data Size

How to design your app with consideration of caching and intermittent connectivity.

help.appsheet.com

Approaches to Data Scalability

How to scale apps to go past spreadsheet row limits.