SheetAPI

Get google spreadsheet data as api response.


Setup

To use with node:

``
$ npm install sheet-api@latest
`

Then in the console:

`
var SheetAPI = require('sheet-api').SheetAPI;
`

To use directly in the browser:

`

`

Usage

SpreadSheetUrl Format - https://docs.google.com/spreadsheets/d/{DOCID}/edit

To use with node:

`
import {SheetAPI} from "sheet-api";

var spreadSheetUrl = "";

var sheet = new Sheet(spreadSheetUrl);
sheet.fetchData().then((responseData) => {
console.log(responseData);
});

`

To use directly in the browser:

`



`

Documentation

Api Response format:

`
{
docName: string,
version: number,
sheets: [{
range: {rows: number, cols: number},
values: [Array]
}]
}
``

Note :

- Spreadsheet should be open accessed by default (no private doc is supported).
- Private doc can be accessed only if session is opened in browser and using this library at client side.

Demo

Refer to demo folder

License

BSD