googlesheets-reader

read rows from a Google Spreadsheet and convert to JSON documents

Usage no npm install needed!

<script type="module">
  import googlesheetsReader from 'https://cdn.skypack.dev/googlesheets-reader';
</script>

README

Deprecation Notice: this uses v3 of the google spreadsheets API

New development @ https://github.com/bradoyler/googlesheet-to-json

googlesheets-reader

Node.js library to read rows from a Google Spreadsheet and convert to JSON documents.

ie.

[
 { Section:'Sports', Date:'8/6/2015'},
 { Section:'Business', Date:''}
]

This is a early work in-progress.

Install

npm install googlesheets-reader --save

Example

see 'test' folder

or run:

$ node test

Todos:

  • Add Mocha tests
  • Support for paging through large sheets
  • Support for accessing private sheets