3 ms·
I recently used Google Sheets as a CMS for a couple of projects. In my case I had a server-side script which read the sheets, converted the data to JSON and sa
by elondaits 6y ago
I recently used Google Sheets as a CMS for a couple of projects.
In my case I had a server-side script which read the sheets, converted the data to JSON and saved it on a file which was then fetched by the JS client. The conversion only had to run when there were updates (e.g once a day).
It was really convenient in my particular case because all users where familiar with Google Sheets, already had users and passwords, and I had good granular control over permissions.
- ignoramous 6y agoYou might also be interested in Glide, helps build mobile-apps with Google Sheets: https://news.ycombinator.com/item?id=19163081 https://news.ycombinator.com/item?id=19163081
- mettamage 6y agoHow does it work when you have a lot of text and you need to put that in one cell? Doesn't that get a bit too unruly?
- vijaybritto 6y agoI dont think we need to care about google sheet's looks while using it as a DB. This approach is pretty good and fast
- mettamage 6y agoAh, fair enough. I totally forgot that reason, haha.
- czzarr 6y agoIf you have more needs like this, you could try out Awesome Table. https://gsuite.google.com/marketplace/app/awesome_table/56088344336 https://gsuite.google.com/marketplace/app/awesome_table/5608... (I'm the product manager)