Google Spreadsheet as a datastore

Recently, I was updating my Portfolio and I have realised that I need a datastore for my project list. A document where I can add name, description, links and status of project easily and see the changes on my portfolio just after saving sheet.

I made a google spreadsheet and set the headers as follows:

  • name — Project Name
  • description — Short desscription of project.
  • link — Github link
  • status — boolean True/False

After saving your sheet go into file sections and publish it on web to get the access using spreadsheet API.

Headers are the key to access values. Link to sheet.

Below, I have added a working example on JS Fiddle.