Makes working with Google sheets a dream!
https://product-os.github.io/dreamsheets

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

Installation

Install by running:

npm install --save dreamsheets

Usage

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

import { readSheet } from "dreamsheets";

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

Documentation

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)

$ 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 and is licensed under Creative Commons CC0.