The Google Drive CMS

A content management system (CMS)
built on an interface everyone understands.




How does it work

The Google Drive CMS is a Google Sheet with a custom menu option to publish the content of that spreadsheet to your site's API. Using this workflow you could send the contents of your Google Sheet

Add the Google Drive CMS template to your Google Drive
Copy the Google Drive CMS template to your Google Drive

This template provides the Apps Scripts and basic structure to publish content to your API endpoint.

Either use the big yellow buttons on this page, or make a copy of a pre-existing Google Drive CMS template in your Drive.


Create headers for your content

On the CMS sheet of your new Google Drive CMS template add headers, which will be used as the keys in the JSON object sent to your API.
Think of these headers like field names in a database.

For example, a Spreadsheet that looks like this:

NameEmail

Will send JSON to your endpoint that looks like this:

See example Spreadsheet
Add the Google Drive CMS template to your Google Drive
Add an API to the settings

Open the sheet on the Spreadsheet called SETTINGS and edit the endpoint value to the API you want the Spreadsheet's content sent to.



info_outlineNote! You need to wire-up how your chosen endpoint handles the sent data. Google Drive CMS is unopinionated in this regard.

Hit publish from the main toolbar

Next Steps »