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:

<script src="/path/to/yourCopyOf/sheet-api.bundle.min.js"></script>

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:

<script src="sheet-min.js"></script>
<script>
var spreadSheetUrl = "";
new Sheet(spreadSheetUrl).fetchData().then(function(data) {
    console.log(data);
});
</script>

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