I'd like to plug PocketBase [0] for a similar use case.

Last week I was looking for a place to store random data with API access, and was looking at making a Google Sheets backend, but PocketBase was easy and didn't have a 60 rpm quota [1].

Deploying to a cheap VPS was very easy with CapRover.

[0] https://pocketbase.io/

[1] https://developers.google.com/sheets/api/limits