# public-google-sheets-reader

> A library to read published Google Sheets and return the data as JSON array.

Latest version **0.0.1** (published 2020-10-10) · ISC license · 0 weekly downloads

## Install

```sh
npm install public-google-sheets-reader
pnpm add public-google-sheets-reader
yarn add public-google-sheets-reader
bun add public-google-sheets-reader
```

## Health

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

Positive: no vulnerabilities.

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

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 0.0.1 |
| Published | 2020-10-10 |
| First published | 2020-10-10 |
| Weekly downloads | 0 |
| License | ISC |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 1 |
| Unpacked size | 2.8 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| Author | Nicolas Meseth |
| Maintainers | nmeseth |
| Keywords | spreadsheets, api, read, Google |

## Links

- npm: https://www.npmjs.com/package/public-google-sheets-reader
- Repository: https://github.com/winf-hsos/public-google-sheets-reader
- Issues: https://github.com/winf-hsos/public-google-sheets-reader/issues
- npm.io page: https://npm.io/package/public-google-sheets-reader

## Dependencies (1)

- [node-fetch](https://npm.io/package/node-fetch.md) ^2.6.1

## 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.0.1 (latest) — 2020-10-10

## README

# Get your spreadsheet's data as JSON
---

A simple library to get data from a published Google Spreadsheet. All you need to do is publish the sheet on the web, copy the workbook's ID, and run the following code:

```js
const reader = require('public-google-sheets-reader');

let workbookId = "[YOUR WORKBOOK ID]";
let sheetNumber = "1"; // Change to whatever sheet you want to get

test();

async function test() {
    let data = await reader.readSheetData(workbookId, sheetNumber);
    console.dir(data);
}
```

**NOTE:** All underscores or spaces in the column's names you specified in your Google Sheet will be replaced by the Google API with nothing. So names in the JSON result will slightly differ.

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