# @cryptosheet/sheet

> Utility functions to interact with Google Spreadsheets

Latest version **2.0.0** (published 2018-09-02) · ISC license · 0 weekly downloads

## Install

```sh
npm install @cryptosheet/sheet
pnpm add @cryptosheet/sheet
yarn add @cryptosheet/sheet
bun add @cryptosheet/sheet
```

## Health

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

Positive: no vulnerabilities.

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

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 2.0.0 |
| Published | 2018-09-02 |
| First published | 2018-09-02 |
| Weekly downloads | 0 |
| License | ISC |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 1 |
| Unpacked size | 5.9 KB |
| Known vulnerabilities | 0 (+1 in 1 direct dependencies) |
| Install scripts | no |
| Author | Christian Fei |
| Maintainers | christian_fei |

## Links

- npm: https://www.npmjs.com/package/@cryptosheet/sheet
- Repository: https://github.com/cryptosheet/cryptosheet-shared
- Homepage: https://github.com/cryptosheet/cryptosheet-shared#readme
- Issues: https://github.com/cryptosheet/cryptosheet-shared/issues
- npm.io page: https://npm.io/package/@cryptosheet/sheet

## Dependencies (1)

- [googleapis](https://npm.io/package/googleapis.md) ^33.0.0

## Recent versions

- 2.0.0 (latest) — 2018-09-02
- 1.0.0 — 2018-09-02
- 0.1.2 — 2018-09-02

## README

# `@cryptosheet/sheet`

Utility functions to interact with Google Spreadsheets

## Usage

```
const {toSheetRows, sheetFor} = require('@cryptosheet/sheet')

const columns = ['createdAt', 'exchange', 'currencyPair', 'balance']
const accounts = [{
  createdAt: '...',
  exchange: 'coinbase',
  currencyPair: 'ltc-eur',
  balance: 0.123
}]

const rows = toSheetRows(accounts, columns)
const {
  clearSpreadsheetValues,
  getSpreadsheetValues,
  getSpreadsheet,
  updateSpreadsheetValues
} = sheetFor(`ACCOUNTS!A:${endColumn}`, config)

updateSpreadsheetValues(rows).then(() => log('updated sheet'))
```

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