[anyfactor]

The projects I worked on always had a mechanism to dump data into a proper database. For example, I built a daily scraper to collect some of the inventory. I didn’t keep all the data in a single sheet. Instead, all the data was stored in a cloud-based managed SQLite or PostgreSQL database, or sometimes a local SQLite database. Only the day's data was stored in Google Sheets because the client wanted to see the spreadsheet themselves and have the UI be accessible for their users.

[matharmin]

It feels a little misleading to say you're using Google Sheets as the backend database, when you need an actual database in conjunction with it.

[mattigames]

Extremely misleading, in this case Google Sheets it's working more like a frontend