Enter a public Google Spreadsheet URL and explore what Cellmate can do.
Use Cellmate as a backend for your application. Use Google permissions to decide who can see what. Allow your colleagues to visualize the data using GUIs while you wrangle JSON.
Need just a part of your site to be dynamic? A traditional CMS might be overkill. The possibilities are endless:
Plug in your favorite charting library, or build one from scratch using d3. Now that you've got JSON, you can visualize the data however you like.