After searching around for libraries, concluded on following 3:
- Sheetrock
- Tabletop
- sheetsee
Most recent useful link:
https://gist.github.com/nyancodeid/abc7f2c3ce47eda753dee8a2b63070ab
- https://videlais.com/2018/05/16/working-with-google-sheets-in-twine/
- https://github.com/jsoma/tabletop
- https://jlord.us/sheetsee.js/docs/basics.html
- https://jlord.us/sheetsee.js/docs/about.html
- https://github.com/jlord/sheetsee
- https://css-tricks.com/creating-an-editable-webpage-with-google-spreadsheets-and-tabletop-js/
More reference links:
Getting started
- https://github.com/edfasano70/crudOnGas/blob/master/Code.gs
- https://github.com/ashrafali46/Google-Sheets-Web-App/blob/master/Code.gs
- https://github.com/rheajt/gradebook-google-script/blob/master/Code.gs
- https://codepen.io/ashrafali46/pen/pKGzjQ
Links for google app script
- https://github.com/ziaongit/CRUD-GoogleSheet/blob/master/assets/js/main.js
- https://github.com/dklimok/google-apps-script-sheets-to-front-end-crud/blob/master/_log.js
- https://github.com/KevinCayenne/googleSheetApiTest.github.io/blob/master/js/script.js
- https://github.com/abhishek-parmar1/CRUD/blob/master/base.gs
- https://github.com/idindrakusuma/example-crud-google-sheets-script/blob/master/google-script.js
- https://github.com/ashrafali46/Google-Sheet-Data-CRUD-App-Script-jQuery/blob/master/script.js
Working samples
- https://docs.google.com/spreadsheets/d/1qtuaxOUQx5zzLFMgdAqBX8z1TSGmxCwVI3MtC3dHXQY/edit#gid=0
- https://codepen.io/ashrafali46/pen/bJgwEN
- https://programming-steps.blogspot.com/2016/10/google-sheet-data-crud-app-script-jquery.html
Awesome library to render data from Google Sheets