I wanted to use Google Sheets for an internal corporate app, but authentication/authorization is a pain, I got it to work but it would have probably been faster to just have some CRUD SQLITE somewhere.
Glide (from the article) adds simple pin-based auth and access control on top of the spreadsheet data. There’s also user and role-based data protection.