Google Sheets als Datenbank oder Tiny CMS

WHAT?

Basically, you can use Google Sheets (or Excel Sheets) as a database or tiny CMS and access the data from any website or application. It means that you can make the copy or content of an entire website or application editable to other humans or machines. For example, you can provide your customers with a solution to maintain, edit or update the content on their websites themselves. It should be also interesting for data scientists who want to present their research, work and data live on the web.

WHY?

Since tabletop.js is dead and not compatible with the current Google API v4 (2021) I had to look for a new solution or alternative to export data from Google Sheets via JSON and import it to a web page.
In this case the holy grail is Papa Parse. Additionally, I’m using isotope.js to add a fancy quick search and a “filter by category” option. For hipsters, I can even offer a solution in vue.js

HOW?

Here is a working Demo on Codepen.
And the code published on Github.

Here is a code example with vue.js
And the search and filter by category stuff with vue.js


Posted

in

by

Tags:

Comments

2 responses to “Google Sheets als Datenbank oder Tiny CMS”

  1. Felipe from Chile Avatar

    Maybe for this reason the past version of my website is failed. Tabletop is very similar to Handlebars.

    For good the actual version is a Vue website who read a json from a google spreadsheet. http://m.agendabiobio.cl

    I will like to get this filter you did. Unfortunally i’m not developer 🙂

    I’m very fan of sheet to website approach and i made the website with tons of effort.

    Regards form Chile, SouthAmerica!

    1. Frank Bueltge Avatar

      Hi Felipe, you actually just need a filter function in Javascript to filter the results from JSON. Here is an example for the filter function, but without vue: https://codepen.io/aenk/pen/RwgPXKd
      So you could implement it without vue or hire a developer 🙂
      It should be an easy and fast task for an experienced developer.

      Regards from Germany!

Leave a Reply

Your email address will not be published. Required fields are marked *