After searching around for libraries, concluded on following 3:

  1. Sheetrock
  2. Tabletop
  3. sheetsee

Most recent useful link:
https://gist.github.com/nyancodeid/abc7f2c3ce47eda753dee8a2b63070ab


  1. https://videlais.com/2018/05/16/working-with-google-sheets-in-twine/
  2. https://github.com/jsoma/tabletop
  3. https://jlord.us/sheetsee.js/docs/basics.html
  4. https://jlord.us/sheetsee.js/docs/about.html
  5. https://github.com/jlord/sheetsee
  6. https://css-tricks.com/creating-an-editable-webpage-with-google-spreadsheets-and-tabletop-js/

More reference links:
Getting started

Links for google app script

Working samples

Awesome library to render data from Google Sheets