[elondaits]

Yes. I used Google sheets as a database to build a website and ran into this issue. The worse part is, if you come across the limit there’s not much you can do but wait or rate limit.

Another problem I had is an API change one year in.

I would not use Google Sheets again. Maybe I’d try Airtable, Notion, or some other similar platform where the API access is more of a priority to the company.

[yawnxyz]

For reading sheets, it's better to use the "share as CSV" option since that gets cached pretty well w/o limits

[gofreddygo]

I've resisted this temptation to integrate with google apis for these 2 specific reasons rate limits and api changes.