# node-google-spreadsheet-basic

> Interacts with Google Spreadsheets

Latest version **0.1.1** (published 2015-03-25) · 0 weekly downloads

## Install

```sh
npm install node-google-spreadsheet-basic
pnpm add node-google-spreadsheet-basic
yarn add node-google-spreadsheet-basic
bun add node-google-spreadsheet-basic
```

## 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 | 2015-03-25 |
| First published | 2014-06-09 |
| Weekly downloads | 0 |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 2 |
| Known vulnerabilities | 0 |
| Install scripts | no |
| Maintainers | juanandresfloored |

## Links

- npm: https://www.npmjs.com/package/node-google-spreadsheet-basic
- Repository: https://github.com/floored/node-google-spreadsheet-basic
- Issues: https://github.com/floored/node-google-spreadsheet-basic/issues
- npm.io page: https://npm.io/package/node-google-spreadsheet-basic

## Dependencies (2)

- [async](https://npm.io/package/async.md) *
- [xml2json](https://npm.io/package/xml2json.md) *

## Recent versions

- 0.1.1 (latest) — 2015-03-25
- 0.1.0 — 2014-06-09

## README

# node-google-spreadsheet-basic

Node wrapper functions to interact with a google spreadsheet by only providing spreadsheet id, email and password.

## GOTCHAs

Make sure you set your spreadsheet to be "Published to the web..." via File > Publish to the web ...

## API

```js
authenticate(email, password, callback);
```
Authenticates the user, if successful, returns an authToken [callback(err, authToken)]


```js
send(spreadsheetId, worksheetId, authToken, entries, callback);
```
Sends an array of entries

Entry format: 
```js 
{row: NUMBER, col: NUMBER, operation: ['query', 'update'], value: NUMBER/STRING}
```
Example
```js
var entries = [{row:1, col:1, operation:'update', value:4564},
{row: 10, col:2, operation: 'query'}
];
```

```js
sendOne(spreadsheetId, worksheetId, authToken, entry, callback);
```
Sends one entry

```js
getCell(spreadsheetId, worksheetId, autToken, row, col, callback);
```
Gets a cell value

```js
setCell(spreadsheetId, worksheetId, authToken, row, col, value, callback);
```
Sets a cell value

```js
test(email, password, spreadsheetId, callback);
```
Use this function to quickly test the script works for you!

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