google-spreadsheet-to-json v2.0.2

[johnbeech]

I've created a v2.0.2 fork here with new tests and CI pipeline:

• https://github.com/connected-web/google-spreadsheet-to-json/releases/tag/v2.0.2

To install from my repo (connected-web org):

npm i -g connected-web/google-spreadsheet-to-json

To directly use this dependency from a node project, use the following in your package.json:

  "dependencies": {
    "google-spreadsheet-to-json": "git://github.com/connected-web/google-spreadsheet-to-json#v2.0.2"
  }

Proposed PR here waiting on review: #31

[savsani]

You can get Google Sheets data into JSON using 2 Methods. (1) Using Google Apps Script (2) Using Google Sheets API v4. There is a nice script available on Codester for getting google sheets data as JSON. It comes with easy step by step tutorial for how to. Example of Dynamic HTML table from google sheets data as JSON also included in it. Sample code examples for Javascript, jQuery & PHP are also given there.