Use a Google Spreadsheet as a simple CMS

Technology

spreadcms_20070613.jpg
Using Google’s Spreadsheet API, you can create a simple CMS for your website extremely easily. It’s as simple as making a new sheet with key/value pairs for any fields you want dynamically populated. You can then access the data from javascript via the JSON API. Any updates to the spreadsheet will be immediately reflected in your page.

The only downside to this approach is that the content of your page is populated by Javascript on the client side, so search engines won’t see the content of your pages during a crawl. You could overcome this obstacle by using the PHP API to pull the spreadsheet data and render the HTML on the server side.

Simple CMS using Google Spreadsheet API – Link
Google Spreadsheets Data API – Link

Discuss this article with the rest of the community on our Discord server!
Tagged

ADVERTISEMENT

Escape to an island of imagination + innovation as Maker Faire Bay Area returns for its 16th iteration!

Prices Increase in....

Days
Hours
Minutes
Seconds
FEEDBACK