# dreamsheets

> Make working with gsheets a dream

Latest version **2.0.4** (published 2026-02-19) · Apache-2.0 license · 0 weekly downloads

## Install

```sh
npm install dreamsheets
pnpm add dreamsheets
yarn add dreamsheets
bun add dreamsheets
```

## Health

**Score 55/100 (C)** — status: stable.

Positive: has types; no vulnerabilities; high quality score.

Warnings: low downloads; no esm support.

## Facts

| | |
|---|---|
| Version | 2.0.4 |
| Published | 2026-02-19 |
| First published | 2022-03-03 |
| Weekly downloads | 0 |
| License | Apache-2.0 |
| TypeScript types | bundled |
| Module format | CommonJS |
| Dependencies | 0 |
| Unpacked size | 24.7 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 1 |
| Maintainers | balena.io |
| Keywords | gsheets, google sheets, google-app-scripts, typescript |

## Links

- npm: https://www.npmjs.com/package/dreamsheets
- Repository: https://github.com/product-os/dreamsheets
- Homepage: https://product-os.github.io/dreamsheets
- Issues: https://github.com/product-os/dreamsheets/issues
- npm.io page: https://npm.io/package/dreamsheets

## Alternatives

- [@openai/codex-sdk](https://npm.io/package/@openai/codex-sdk.md) — 731.4K weekly downloads
- [babel-plugin-transform-react-jsx](https://npm.io/package/babel-plugin-transform-react-jsx.md) — 565.0K weekly downloads
- [babel-helper-remove-or-void](https://npm.io/package/babel-helper-remove-or-void.md) — 508.5K weekly downloads
- [@pnpm/store-controller-types](https://npm.io/package/@pnpm/store-controller-types.md) — 186.9K weekly downloads
- [react-native-signature-canvas](https://npm.io/package/react-native-signature-canvas.md) — 155.6K weekly downloads

## Recent versions

- 2.0.4 (latest) — 2026-02-19
- 2.0.5-build-renovate-actions-checkout-5-x-1252e9044f816fcb66500f18f65293c8a76f09f4-1 (build-renovate-actions-checkout-5-x) — 2026-02-19
- 2.0.5-build-renovate-actions-checkout-4-x-e2b292f28907af80e43e1a42cdd5a4986e04ae36-1 (build-renovate-actions-checkout-4-x) — 2026-02-19
- 2.0.4-build-add-npm-oidc-permissions-2905458887e5afa79d1608e48c7c07e9020271bc-1 (build-add-npm-oidc-permissions) — 2026-02-18
- 2.0.4-build-renovate-actions-setup-node-4-x-a23bc828df9cfae7e20f08266d0ec94a8a2c0452-1 (build-renovate-actions-setup-node-4-x) — 2025-04-14
- 2.0.4-build-renovate-typedoc-691b786c8e05a37a9baf663b967d590898e25e8c-1 (build-renovate-typedoc) — 2024-11-21
- 2.0.4-build-renovate-actions-checkout-4-x-fa319538cd15754fa3bdd35394b50c3f7010fdb3-1 (build-renovate-actions-checkout-4-x-fa319538cd15754fa3bdd35394b50c3f7010fdb3) — 2024-10-07
- 2.0.4-build-renovate-actions-checkout-4-x-d95abb9e4c8dba212ab76883e2c68fc865bdabd9-1 (build-renovate-actions-checkout-4-x-d95abb9e4c8dba212ab76883e2c68fc865bdabd9) — 2024-09-30
- 2.0.4-build-renovate-actions-setup-node-4-x-b1372c6275b8e4593463dd257a6eabc6e2aff476-1 (build-renovate-actions-setup-node-4-x-b1372c6275b8e4593463dd257a6eabc6e2aff476) — 2024-09-30
- 2.0.4-build-renovate-typedoc-f13d3b9ed9f31c9c1ec74a3c4264f80df9af6055-1 (build-renovate-typedoc-f13d3b9ed9f31c9c1ec74a3c4264f80df9af6055) — 2024-09-30
- 2.0.3-build-checkout-settings-4970a3171798ac1ca70bbc6d4bdd75f58e0bae67-1 (build-checkout-settings-4970a3171798ac1ca70bbc6d4bdd75f58e0bae67) — 2024-09-27
- 2.0.3-build-renovate-actions-setup-node-4-x-65d17da7f3a0c4fb643c89c6f94a2db061f74bea-1 (build-renovate-actions-setup-node-4-x-65d17da7f3a0c4fb643c89c6f94a2db061f74bea) — 2024-09-19
- 2.0.3-build-renovate-actions-setup-node-4-x-2aa6d15246fb5927924ae83a31cf4519fb63439c-1 (build-renovate-actions-setup-node-4-x-2aa6d15246fb5927924ae83a31cf4519fb63439c) — 2024-07-09
- 2.0.3-build-renovate-typedoc-e536c8586ccf52b18199ceea25fded11f16c8802-1 (build-renovate-typedoc-e536c8586ccf52b18199ceea25fded11f16c8802) — 2024-06-25
- 2.0.3-build-renovate-actions-checkout-4-x-90df3673ed8f204d39b8330295872cfeca458aeb-1 (build-renovate-actions-checkout-4-x-90df3673ed8f204d39b8330295872cfeca458aeb) — 2024-06-13
- … 30 more at https://npm.io/package/dreamsheets/versions

## README

<div align="center">
  <img width="400" height="auto" src="https://raw.githubusercontent.com/product-os/dreamsheets/master/icon.png">
  <br>
  <br>

[![npm version](https://badge.fury.io/js/dreamsheets.svg)](https://badge.fury.io/js/dreamsheets)

  <p>
    Makes working with Google sheets a dream!
    <br>
    https://product-os.github.io/dreamsheets
  </p>
  <br>
  <br>
</div>

Dreamsheets is a simple, easy to use, and powerful tool for managing your Google Sheets through Google Apps Script.

## Installation

Install by running:

```sh
npm install --save dreamsheets
```

## Usage

For example, you can read from a sheet like this:

```javascript
import { readSheet } from "dreamsheets";

const mySheetData = readSheet("Sheet Name", { range: "A1:Z100" });
```

## Documentation

[![Publish Documentation](https://github.com/product-os/dreamsheets/actions/workflows/publish-docs.yml/badge.svg)](https://github.com/product-os/dreamsheets/actions/workflows/publish-docs.yml)

Visit the website for complete documentation: https://product-os.github.io/dreamsheets

## Development

CI-less local workflow for windows, (should also work on mac and linux)

```bash
$ cd ./dreamsheets
$ npm install
$ npm link


$ cd ./path-to/my-new/example-model-repo
$ npm install
$ npm link dreamsheets

# now make changes to dreamsheets, build them and then test them
```

## License

The project is licensed under the Apache-2.0 license.

The icon at the top of this file is provided by
[svgrepo.com](https://www.svgrepo.com/svg/206802/sheep) and is
licensed under [Creative Commons CC0](https://creativecommons.org/publicdomain/zero/1.0/).

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