open-index/open-npm huggingface dataset:
npm package: @sheetbase/gmail-angular
Description: Send email using Gmail
Author: Sheetbase
Latest version: 0.0.1
Deprecated: Please use https://www.npmjs.com/package/@sheetbase/angular

# Sheetbase Module: @sheetbase/gmail-angular

Send email using Gmail.

<!-- <block:header> -->

[![NPM](https://img.shields.io/npm/v/@sheetbase/gmail-angular.svg)](https://www.npmjs.com/package/@sheetbase/gmail-angular) [![License][license_badge]][license_url] [![Support me on Patreon][badge_patreon]][patreon_url] [![PayPal][badge_paypal_donate]][paypal_donate_url] [![Ask me anything][badge_ask_me]][ask_me_url]

<!-- </block:header> -->

## Install

`npm install --save @sheetbase/gmail-angular`

## Lisence

Sheetbase Angular is released under the [MIT](https://github.com/sheetbase/angular/blob/master/LICENSE) license.

<!-- <block:footer> -->

[license_badge]: https://img.shields.io/github/license/mashape/apistatus.svg
[license_url]: https://github.com/sheetbase/angular/blob/master/LICENSE

[badge_patreon]: https://lamnhan.github.io/assets/images/badges/patreon.svg
[patreon_url]: https://www.patreon.com/lamnhan

[badge_paypal_donate]: https://lamnhan.github.io/assets/images/badges/paypal_donate.svg
[paypal_donate_url]: https://www.paypal.me/lamnhan

[badge_ask_me]: https://img.shields.io/badge/ask/me-anything-1abc9c.svg
[ask_me_url]: https://m.me/sheetbase

<!-- </block:footer> -->
npm package: @sheetbase/handlebars-server
Description: Handlebars for Google apps script.
Author: Yehuda Katz
Latest version: 4.0.11-4
Deprecated: please use the official package

# Sheetbase Module: @sheetbase/handlebars-server

Handlebars for Google apps script.

<!-- <block:header> -->

[![License][license_badge]][license_url] [![clasp][clasp_badge]][clasp_url] [![Support me on Patreon][patreon_badge]][patreon_url] [![PayPal][paypal_donate_badge]][paypal_donate_url] [![Ask me anything][ask_me_badge]][ask_me_url]

<!-- </block:header> -->

## Install

- Using npm: `npm install --save @sheetbase/handlebars-server`

- As a library: `1onxq7LQFPM7BgErdOCogyc6_BIqCpnoINv6BqoYrYpNsj7U0ayRulVB2`

  Set the _Indentifier_ to **Handlebars** and select the lastest version, [view code](https://script.google.com/d/1onxq7LQFPM7BgErdOCogyc6_BIqCpnoINv6BqoYrYpNsj7U0ayRulVB2/edit?usp=sharing).

## Examples

```ts
function example1(): void {
  const source: string =
    "<p>Hello, my name is {{name}}. " +
    "I am from {{hometown}}. I have {{kids.length}} kids:</p>" +
    "<ul>{{#kids}}<li>{{name}} is {{age}}</li>{{/kids}}</ul>";
  const template = Handlebars.compile(source);
  const data = {
    name: "Alan",
    hometown: "Somewhere, TX",
    kids: [{ name: "Jimmy", age: "12" }, { name: "Sally", age: "4" }]
  };
  let result = template(data);
  Logger.log(result);
}
```

## Documentation

Homepage: http://www.handlebarsjs.com/

## License

**@sheetbase/handlebars-server** is released under the [MIT](https://github.com/sheetbase/module-handlebars-server/blob/master/LICENSE) license.

<!-- <block:footer> -->

[license_badge]: https://img.shields.io/github/license/mashape/apistatus.svg
[license_url]: https://github.com/sheetbase/module-handlebars-server/blob/master/LICENSE
[clasp_badge]: https://img.shields.io/badge/built%20with-clasp-4285f4.svg
[clasp_url]: https://github.com/google/clasp
[patreon_badge]: https://ionicabizau.github.io/badges/patreon.svg
[patreon_url]: https://www.patreon.com/lamnhan
[paypal_donate_badge]: https://ionicabizau.github.io/badges/paypal_donate.svg
[paypal_donate_url]: https://www.paypal.me/lamnhan
[ask_me_badge]: https://img.shields.io/badge/ask/me-anything-1abc9c.svg
[ask_me_url]: https://m.me/sheetbase

<!-- </block:footer> -->
npm package: @sheetbase/jsrsasign-server
Description: Jsrsasign for Google apps script.
Author: Kenji Urushima
Latest version: 8.0.12-3
Deprecated: please use the official package

# Sheetbase Module: @sheetbase/jsrsasign-server

Jsrsasign for Google apps script.

<!-- <block:header> -->

[![License][license_badge]][license_url] [![clasp][clasp_badge]][clasp_url] [![Support me on Patreon][patreon_badge]][patreon_url] [![PayPal][paypal_donate_badge]][paypal_donate_url] [![Ask me anything][ask_me_badge]][ask_me_url]

<!-- </block:header> -->

## Install

- Using npm: `npm install --save @sheetbase/jsrsasign-server`

- As a library: `1vWIxUEbidGO8Jl3tMoofvecwBdQmqMdHpa-zFeR653aFt1VQMbzKzaMV`

  Set the _Indentifier_ to **Jsrsasign** and select the lastest version, [view code](https://script.google.com/d/1vWIxUEbidGO8Jl3tMoofvecwBdQmqMdHpa-zFeR653aFt1VQMbzKzaMV/edit?usp=sharing).

## Examples

```ts
function example1(): void {
  const base64: string = Jsrsasign.utf8tob64("hello");
  Logger.log(base64);
}

function example2(): void {
  const md5: string = Jsrsasign.KJUR.crypto.Util.md5("hello");
  Logger.log(md5);
}

function example3(): void {
  // sign HS256 signature with password "aaa" implicitly handled as string
  const sJWS = Jsrsasign.KJUR.jws.JWS.sign(
    null,
    { alg: "HS256", cty: "JWT" },
    { age: 21 },
    "aaa"
  );
  Logger.log(sJWS);
}
```

## Documentation

Homepage: http://kjur.github.io/jsrsasign/

## License

**@sheetbase/jsrsasign-server** is released under the [MIT](https://github.com/sheetbase/module-jsrsasign-server/blob/master/LICENSE) license.

<!-- <block:footer> -->

[license_badge]: https://img.shields.io/github/license/mashape/apistatus.svg
[license_url]: https://github.com/sheetbase/module-jsrsasign-server/blob/master/LICENSE
[clasp_badge]: https://img.shields.io/badge/built%20with-clasp-4285f4.svg
[clasp_url]: https://github.com/google/clasp
[patreon_badge]: https://ionicabizau.github.io/badges/patreon.svg
[patreon_url]: https://www.patreon.com/lamnhan
[paypal_donate_badge]: https://ionicabizau.github.io/badges/paypal_donate.svg
[paypal_donate_url]: https://www.paypal.me/lamnhan
[ask_me_badge]: https://img.shields.io/badge/ask/me-anything-1abc9c.svg
[ask_me_url]: https://m.me/sheetbase

<!-- </block:footer> -->
npm package: @sheetbase/lodash-server
Description: Lodash for Google apps script.
Author: Lodash
Latest version: 4.17.11-2
Deprecated: please use the official package

# Sheetbase Module: @sheetbase/lodash-server

Lodash for Google apps script.

<!-- <block:header> -->

[![License][license_badge]][license_url] [![clasp][clasp_badge]][clasp_url] [![Support me on Patreon][patreon_badge]][patreon_url] [![PayPal][paypal_donate_badge]][paypal_donate_url] [![Ask me anything][ask_me_badge]][ask_me_url]

<!-- </block:header> -->

## Install

- Using npm: `npm install --save @sheetbase/lodash-server`

- As a library: `1P8qfUHEUdQPB0Pc8S7Vb_7MvUnxU8Mt7GtLNd7QMuqup4KamkavaN5YT`

  Set the _Indentifier_ to **Lodash** and select the lastest version, [view code](https://script.google.com/d/1P8qfUHEUdQPB0Pc8S7Vb_7MvUnxU8Mt7GtLNd7QMuqup4KamkavaN5YT/edit?usp=sharing).

## Examples

```ts
function example1(): void {
  const chunk = _.chunk(["a", "b", "c", "d"], 2);
  // => [['a', 'b'], ['c', 'd']]
  Logger.log(chunk);
}

function example2(): void {
  const object = { a: [{ b: { c: 3 } }] };
  const value: number = _.get(object, "a[0].b.c");
  // => 3
  Logger.log(value);
}

function example3(): void {
  const object = { a: [{ b: { c: 3 } }] };
  _.set(object, "a[0].b.c", 4);
  _.set(object, "a[0].b.d", "Hello");
  // { 'a': [{ 'b': { 'c': 4, 'd': 'Hello' } }] }
  Logger.log(object);
}
```

## Documentation

Homepage: https://lodash.com/

## License

**@sheetbase/lodash-server** is released under the [MIT](https://github.com/sheetbase/module-lodash-server/blob/master/LICENSE) license.

<!-- <block:footer> -->

[license_badge]: https://img.shields.io/github/license/mashape/apistatus.svg
[license_url]: https://github.com/sheetbase/module-lodash-server/blob/master/LICENSE
[clasp_badge]: https://img.shields.io/badge/built%20with-clasp-4285f4.svg
[clasp_url]: https://github.com/google/clasp
[patreon_badge]: https://ionicabizau.github.io/badges/patreon.svg
[patreon_url]: https://www.patreon.com/lamnhan
[paypal_donate_badge]: https://ionicabizau.github.io/badges/paypal_donate.svg
[paypal_donate_url]: https://www.paypal.me/lamnhan
[ask_me_badge]: https://img.shields.io/badge/ask/me-anything-1abc9c.svg
[ask_me_url]: https://m.me/sheetbase

<!-- </block:footer> -->
npm package: @sheetbase/md5-server
Description: JavaScript MD5 implementation for Google apps script.
Author: Sebastian Tschan
Latest version: 2.10.0-1
Deprecated: please use the official package

# Sheetbase Module: @sheetbase/md5-server

JavaScript MD5 implementation for Google apps script.

<!-- <block:header> -->

[![License][license_badge]][license_url] [![clasp][clasp_badge]][clasp_url] [![Support me on Patreon][patreon_badge]][patreon_url] [![PayPal][paypal_donate_badge]][paypal_donate_url] [![Ask me anything][ask_me_badge]][ask_me_url]

<!-- </block:header> -->

## Install

- Using npm: `npm install --save @sheetbase/md5-server`

- As a library: `1MWgpT1eLKYxP6-v9cuH91FWHdagJXVQFtAN2MX2QLUXDiZNfpiDfbnab`

  Set the _Indentifier_ to **Md5** and select the lastest version, [view code](https://script.google.com/d/1MWgpT1eLKYxP6-v9cuH91FWHdagJXVQFtAN2MX2QLUXDiZNfpiDfbnab/edit?usp=sharing).

## Examples

```ts
function example1(): void {
  const hash = Md5.md5("hello");
  Logger.log(hash);
}
```

## Documentation

Homepage: https://blueimp.github.io/JavaScript-MD5/

## License

**@sheetbase/md5-server** is released under the [MIT](https://github.com/sheetbase/module-md5-server/blob/master/LICENSE) license.

<!-- <block:footer> -->

[license_badge]: https://img.shields.io/github/license/mashape/apistatus.svg
[license_url]: https://github.com/sheetbase/module-md5-server/blob/master/LICENSE
[clasp_badge]: https://img.shields.io/badge/built%20with-clasp-4285f4.svg
[clasp_url]: https://github.com/google/clasp
[patreon_badge]: https://ionicabizau.github.io/badges/patreon.svg
[patreon_url]: https://www.patreon.com/lamnhan
[paypal_donate_badge]: https://ionicabizau.github.io/badges/paypal_donate.svg
[paypal_donate_url]: https://www.paypal.me/lamnhan
[ask_me_badge]: https://img.shields.io/badge/ask/me-anything-1abc9c.svg
[ask_me_url]: https://m.me/sheetbase

<!-- </block:footer> -->
npm package: @sheetbase/polyfill-server
Description: Es6 shim for Google apps script.
Author: Paul Miller
Latest version: 0.35.3-4
Deprecated: please use the official package

# Sheetbase Module: @sheetbase/polyfill-server

Es6 shim for Google apps script.

<!-- <block:header> -->

[![License][license_badge]][license_url] [![clasp][clasp_badge]][clasp_url] [![Support me on Patreon][patreon_badge]][patreon_url] [![PayPal][paypal_donate_badge]][paypal_donate_url] [![Ask me anything][ask_me_badge]][ask_me_url]

<!-- </block:header> -->

## Install

- Using npm: `npm install --save @sheetbase/polyfill-server`

- As a library: `1YGFR9Mv-chy7B419d-PrTX8a_Cwg2QWJM1g2qpgVzUNXJM1L5-0D77dC`

  Set the _Indentifier_ to **Polyfill** and select the lastest version, [view code](https://script.google.com/d/1YGFR9Mv-chy7B419d-PrTX8a_Cwg2QWJM1g2qpgVzUNXJM1L5-0D77dC/edit?usp=sharing).

## Examples

```ts
function example1(): void {
  var obj1 = { a: 1, b: 2 };
  var obj2 = { c: 3 };
  var obj3 = Object.assign(obj1, obj2);
  Logger.log(obj3);
}
```

## Documentation

Homepage: https://github.com/paulmillr/es6-shim

## License

**@sheetbase/polyfill-server** is released under the [MIT](https://github.com/sheetbase/module-polyfill-server/blob/master/LICENSE) license.

<!-- <block:footer> -->

[license_badge]: https://img.shields.io/github/license/mashape/apistatus.svg
[license_url]: https://github.com/sheetbase/module-polyfill-server/blob/master/LICENSE
[clasp_badge]: https://img.shields.io/badge/built%20with-clasp-4285f4.svg
[clasp_url]: https://github.com/google/clasp
[patreon_badge]: https://ionicabizau.github.io/badges/patreon.svg
[patreon_url]: https://www.patreon.com/lamnhan
[paypal_donate_badge]: https://ionicabizau.github.io/badges/paypal_donate.svg
[paypal_donate_url]: https://www.paypal.me/lamnhan
[ask_me_badge]: https://img.shields.io/badge/ask/me-anything-1abc9c.svg
[ask_me_url]: https://m.me/sheetbase

<!-- </block:footer> -->
npm package: @sheetbase/sheets-nosql-angular
Description: Using Google Sheets as NoSQL database
Author: Sheetbase
Latest version: 0.0.1
Deprecated: Please use https://www.npmjs.com/package/@sheetbase/angular

# Sheetbase Module: @sheetbase/sheets-nosql-angular

Using Google Sheets as NoSQL database.

<!-- <block:header> -->

[![NPM](https://img.shields.io/npm/v/@sheetbase/sheets-nosql-angular.svg)](https://www.npmjs.com/package/@sheetbase/sheets-nosql-angular) [![License][license_badge]][license_url] [![Support me on Patreon][badge_patreon]][patreon_url] [![PayPal][badge_paypal_donate]][paypal_donate_url] [![Ask me anything][badge_ask_me]][ask_me_url]

<!-- </block:header> -->

## Install

`npm install --save @sheetbase/sheets-nosql-angular`

## Lisence

Sheetbase Angular is released under the [MIT](https://github.com/sheetbase/angular/blob/master/LICENSE) license.

<!-- <block:footer> -->

[license_badge]: https://img.shields.io/github/license/mashape/apistatus.svg
[license_url]: https://github.com/sheetbase/angular/blob/master/LICENSE

[badge_patreon]: https://ionicabizau.github.io/badges/patreon.svg
[patreon_url]: https://www.patreon.com/lamnhan

[badge_paypal_donate]: https://ionicabizau.github.io/badges/paypal_donate.svg
[paypal_donate_url]: https://www.paypal.me/lamnhan

[badge_ask_me]: https://img.shields.io/badge/ask/me-anything-1abc9c.svg
[ask_me_url]: https://m.me/sheetbase

<!-- </block:footer> -->
npm package: @sheetbase/tamotsux-server
Description: Tamotsu ORM that support multiple sheets.
Author: ITMammoth
Latest version: 0.0.4

# Sheetbase Module: @sheetbase/tamotsux-server

Tamotsu ORM that support multiple sheets.

<!-- <block:header> -->

[![Build Status](https://travis-ci.com/sheetbase/tamotsux-server.svg?branch=master)](https://travis-ci.com/sheetbase/tamotsux-server) [![Coverage Status](https://coveralls.io/repos/github/sheetbase/tamotsux-server/badge.svg?branch=master)](https://coveralls.io/github/sheetbase/tamotsux-server?branch=master) [![NPM](https://img.shields.io/npm/v/@sheetbase/tamotsux-server.svg)](https://www.npmjs.com/package/@sheetbase/tamotsux-server) [![License][license_badge]][license_url] [![clasp][clasp_badge]][clasp_url] [![Support me on Patreon][patreon_badge]][patreon_url] [![PayPal][paypal_donate_badge]][paypal_donate_url] [![Ask me anything][ask_me_badge]][ask_me_url]

<!-- </block:header> -->

## Install

Using npm: `npm install --save @sheetbase/tamotsux-server`

```ts
import * as Tamotsux from "@sheetbase/tamotsux-server";
```

As a library: `15fzNG5GZ7Ko6ygGYsMvthZLHovrc3eI_BEwFhwciOWVsBx47WCo13wvW`

Set the _Indentifier_ to **TamotsuxModule** and select the lastest version, [view code](https://script.google.com/d/15fzNG5GZ7Ko6ygGYsMvthZLHovrc3eI_BEwFhwciOWVsBx47WCo13wvW/edit?usp=sharing).

```ts
declare const TamotsuxModule: { Tamotsux: any };
const Tamotsux = TamotsuxModule.Tamotsux;
```

## Scopes

`https://www.googleapis.com/auth/spreadsheets`

## Usage

- Docs homepage: https://sheetbase.github.io/tamotsux-server

- API reference: https://sheetbase.github.io/tamotsux-server/api

### Examples

```ts
import * as Tamotsux from "./public_api";

const defaultSpreadsheet = SpreadsheetApp.openById(
  "1Zz5kvlTn2cXd41ZQZlFeCjvVR_XhpUnzKlDGB8QsXoI"
);

export function example1(): void {
  Tamotsux.initialize();
  const FooTable = Tamotsux.Table.define({
    sheetName: "foo",
    spreadsheet: defaultSpreadsheet
  });

  const first = FooTable.first();
  Logger.log(first);
}

export function example2(): void {
  Tamotsux.initialize(defaultSpreadsheet); // dafault
  const BarTable = Tamotsux.Table.define({ sheetName: "bar" });

  const all = BarTable.all();
  Logger.log(all);
}
```

## License

**@sheetbase/tamotsux-server** is released under the [MIT](https://github.com/sheetbase/tamotsux-server/blob/master/LICENSE) license.

<!-- <block:footer> -->

[license_badge]: https://img.shields.io/github/license/mashape/apistatus.svg
[license_url]: https://github.com/sheetbase/tamotsux-server/blob/master/LICENSE
[clasp_badge]: https://img.shields.io/badge/built%20with-clasp-4285f4.svg
[clasp_url]: https://github.com/google/clasp
[patreon_badge]: https://lamnhan.github.io/assets/images/badges/patreon.svg
[patreon_url]: https://www.patreon.com/lamnhan
[paypal_donate_badge]: https://lamnhan.github.io/assets/images/badges/paypal_donate.svg
[paypal_donate_url]: https://www.paypal.me/lamnhan
[ask_me_badge]: https://img.shields.io/badge/ask/me-anything-1abc9c.svg
[ask_me_url]: https://m.me/sheetbase

<!-- </block:footer> -->
npm package: @sheetbase/testing
Description: Tools for testing Sheetbase backend.
Author: Sheetbase
Latest version: 1.1.0

# Sheetbase Testing

Tools for testing Sheetbase backend.

## Install

`npm install --save-dev @sheetbase/testing`

## Usage

```ts
// import testing browser
import { Browser } from '@sheetbase/testing';

// import app instance
import * as App from '../src/index';

// init a browser instance for the app
const browser = new Browser(App);

// begin test
describe('Home routes', () => {

    it('GET /', () => {
        const { body } = browser.get('/');
        expect(body).to.contain('Sheetbase Backend');
    });

    it('POST /', () => {
        const { body } = browser.post('/');
        expect(body.data).to.eql({ title: 'Sheetbase Backend' });
    });

});

```

## API

```ts
const browser = new Browser(App);

// GET /
const { body } = browser.get('/', { /* params */ });

// POST /xxx
const { body } = browser.post('/xxx', { /* params */ }, { /* body */ });

// PUT /
const { body } = browser.put('/', { /* params */ }, { /* body */ });

// PATCH /
const { body } = browser.patch('/', { /* params */ }, { /* body */ });

// DELETE /
const { body } = browser.delete('/', { /* params */ }, { /* body */ });

```

## License

This package is released under the [MIT][license_url] license.

<!-- block:footer -->

[license_url]: https://github.com/sheetbase/testing/blob/master/LICENSE

<!-- /block:footer -->
npm package: @sheetbase/user-server
Description: User management system.
Author: Sheetbase
Latest version: 0.0.9

# Sheetbase Module: @sheetbase/user-server

User management system.

<!-- <block:header> -->

[![Build Status](https://travis-ci.com/sheetbase/user-server.svg?branch=master)](https://travis-ci.com/sheetbase/user-server) [![Coverage Status](https://coveralls.io/repos/github/sheetbase/user-server/badge.svg?branch=master)](https://coveralls.io/github/sheetbase/user-server?branch=master) [![NPM](https://img.shields.io/npm/v/@sheetbase/user-server.svg)](https://www.npmjs.com/package/@sheetbase/user-server) [![License][license_badge]][license_url] [![clasp][clasp_badge]][clasp_url] [![Support me on Patreon][patreon_badge]][patreon_url] [![PayPal][paypal_donate_badge]][paypal_donate_url] [![Ask me anything][ask_me_badge]][ask_me_url]

<!-- </block:header> -->

## Install

Using npm: `npm install --save @sheetbase/user-server`

```ts
import * as User from "@sheetbase/user-server";
```

As a library: `1ThvmvlMcPVBFUzT2QUy6pHiAEsfrKbhLSmju-CCXatiLASXXb8KFssHr`

Set the _Indentifier_ to **UserModule** and select the lastest version, [view code](https://script.google.com/d/1ThvmvlMcPVBFUzT2QUy6pHiAEsfrKbhLSmju-CCXatiLASXXb8KFssHr/edit?usp=sharing).

```ts
declare const UserModule: { User: any };
const User = UserModule.User;
```

## Usage

- Docs homepage: https://sheetbase.github.io/user-server

- API reference: https://sheetbase.github.io/user-server/api

## License

**@sheetbase/user-server** is released under the [MIT](https://github.com/sheetbase/user-server/blob/master/LICENSE) license.

<!-- <block:footer> -->

[license_badge]: https://img.shields.io/github/license/mashape/apistatus.svg
[license_url]: https://github.com/sheetbase/user-server/blob/master/LICENSE
[clasp_badge]: https://img.shields.io/badge/built%20with-clasp-4285f4.svg
[clasp_url]: https://github.com/google/clasp
[patreon_badge]: https://lamnhan.github.io/assets/images/badges/patreon.svg
[patreon_url]: https://www.patreon.com/lamnhan
[paypal_donate_badge]: https://lamnhan.github.io/assets/images/badges/paypal_donate.svg
[paypal_donate_url]: https://www.paypal.me/lamnhan
[ask_me_badge]: https://img.shields.io/badge/ask/me-anything-1abc9c.svg
[ask_me_url]: https://m.me/sheetbase

<!-- </block:footer> -->