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.
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.