Open johnbeech opened 3 years ago
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.
I've created a
v2.0.2
fork here with new tests and CI pipeline:To install from my repo (connected-web org):
To directly use this dependency from a node project, use the following in your
package.json
:Proposed PR here waiting on review: https://github.com/bassarisse/google-spreadsheet-to-json/pull/31