Sticky Assistant

A multi-tool Google Workspace add-on suite for Sticky, now modernized with TypeScript, Rollup, and Vitest.

Quick Install (Universal)

To clone and set up the project in one command:

macOS / Linux:

curl -fsSL https://raw.githubusercontent.com/RubenBroere/sticky-assistant/main/scripts/install.sh | bash

Windows (PowerShell):

iwr https://raw.githubusercontent.com/RubenBroere/sticky-assistant/main/scripts/install.ps1 | iex

Tools

• Sticky Assistant - Action Points
  • Scan Google Docs for action points and optionally sync to Todoist.
• Sticky Assistant - Committees
  • Clone committee folder structures and update year placeholders.

Project Structure

• src/ - TypeScript source code
  • action-points/ - Action Points tool implementation
  • committee/ - Committee tool implementation
  • core/ - Shared utilities (branding, localization, UI)
• dist/ - Bundled JavaScript (generated by Rollup)
• scripts/ - Installation and setup scripts

Local Development

1. Install dependencies: npm install
2. Build: npm run build (bundles TS to dist/)
3. Test: npm test (runs Vitest unit tests)
4. Push to Apps Script: npm run push (requires clasp login and scriptId in .clasp.json)

Environment Setup

This repo supports personal deployments. Each developer uses their own Apps Script project and local .clasp.json.

1. Login to Google: npx clasp login
2. Create/Link project: npx clasp create --type standalone --title "Sticky Assistant"
3. Update .clasp.json: Ensure scriptId is correct and rootDir points to "dist".

Testing

Unit tests are located alongside the source code with the .spec.ts extension. Use npm test to run them locally.