# google-sheet-to-data

> convert google spread sheet to json or matrix

Latest version **0.1.1** (published 2017-01-17) · 0 weekly downloads

## Install

```sh
npm install google-sheet-to-data
pnpm add google-sheet-to-data
yarn add google-sheet-to-data
bun add google-sheet-to-data
```

## Health

**Score 10/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support; low quality score; pre 1.0.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 0.1.1 |
| Published | 2017-01-17 |
| First published | 2017-01-16 |
| Weekly downloads | 0 |
| TypeScript types | none |
| Module format | CommonJS |
| Node | >= 6.3.0 |
| Dependencies | 2 |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 0 |
| Author | h.hyunwoo |
| Maintainers | h.hyunwoo |
| Keywords | googlespreadsheet, google spread sheet, google spread sheet json, spreadsheet |

## Links

- npm: https://www.npmjs.com/package/google-sheet-to-data
- Repository: https://github.com/hyunwoo/GoogleSheetToData
- Homepage: https://github.com/hyunwoo/GoogleSheetToData#readme
- npm.io page: https://npm.io/package/google-sheet-to-data

## Dependencies (2)

- [lodash](https://npm.io/package/lodash.md) ^4.17.4
- [google-spreadsheet](https://npm.io/package/google-spreadsheet.md) ^2.0.3

## Alternatives

- [csv-to-markdown-table](https://npm.io/package/csv-to-markdown-table.md) — 47.0K weekly downloads
- [@sapphire/ratelimits](https://npm.io/package/@sapphire/ratelimits.md) — 4.4K weekly downloads
- [js-csvparser](https://npm.io/package/js-csvparser.md) — 2.0K weekly downloads
- [@adadapted/js-sdk](https://npm.io/package/@adadapted/js-sdk.md) — 251 weekly downloads
- [@grapecity/spread-sheets-sparklines](https://npm.io/package/@grapecity/spread-sheets-sparklines.md) — 103 weekly downloads

## Recent versions

- 0.1.1 (latest) — 2017-01-17
- 0.1.0 — 2017-01-17
- 0.0.6 — 2017-01-16
- 0.0.5 — 2017-01-16
- 0.0.4 — 2017-01-16
- 0.0.3 — 2017-01-16
- 0.0.2 — 2017-01-16
- 0.0.1 — 2017-01-16

## README

# GoogleSheetToData


## Example GoogleSpread Sheet
| Key1     | Key2    | Key3 | ... |
| --------|---------|-------|-----|
| Value1_1  | Value2_1   | Value3_1    | ... |
| Value1_2 | Value2_2 | Value3_2    | ... |
## This module only reads data from the published google spreadsheet.

## Usage
##### You must have publish settings in Google spreadsheets.
##### https://support.google.com/docs/answer/37579?hl=en
##### GoogleSpreadSheet -> File -> Publish to the web.

###+ JSON
```
var sheet = require("google-sheet-to-data")('YOUR_SHEET_ID');
// sheet number start at 1
sheet.json(SHEET_IDX, function (err, rep) {
    console.log(err, rep);
});
```

####result : 

null, 
[{
  Key1: value1_1,
  Key2: Value2_1,
  Key3: Value3_1,
},
{
  Key1: value1_2,
  Key2: Value2_2,
  Key3: Value3_2,
}
...
]




###+ MATRIX
```
var sheet = require("google-sheet-to-data")('YOUR_SHEET_ID');
// sheet number start at 1
sheet.matrix(SHEET_IDX, function (err, rep) {
    console.log(err, rep);
});
```

####result :

null, 
[
  [
    Key1,
    Key2,
    Key3
    ...
  ],
  [
    Value1_1,
    Value2_1,
    Value3_1
    ...
  ],
  [
    Value1_2,
    Value2_2,
    Value3_2
    ...
  ]
  ...
]

---
_Source: https://npm.io/package/google-sheet-to-data · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._