JSPM

  • ESM via JSPM
  • ES Module Entrypoint
  • Export Map
  • Keywords
  • License
  • Repository URL
  • TypeScript Types
  • README
  • Created
  • Published
  • Downloads 26
  • Score
    100M100P100Q70065F

Helper utilities for Google Apps Script: UI dialogs, triggers, Telegram notifications, Entity/Repository for Sheets

Package Exports

  • @sysa-ivan/gas-helpers/entity
  • @sysa-ivan/gas-helpers/eslint
  • @sysa-ivan/gas-helpers/prettier
  • @sysa-ivan/gas-helpers/properties
  • @sysa-ivan/gas-helpers/sheet
  • @sysa-ivan/gas-helpers/telegram
  • @sysa-ivan/gas-helpers/triggers
  • @sysa-ivan/gas-helpers/ui

Readme

gas-helpers

Helper utilities for Google Apps Script: UI, triggers, Telegram notifications, Google Sheets (Entity/Repository).

For AI agents: See AGENTS.md for imports, patterns, and GAS caveats.

Installation

npm install gas-helpers

Modules

Module Description
ui Spreadsheet UI dialogs (alert, confirm, prompt) with availability check
triggers Managing time-based triggers in Google Apps Script
telegram Sending notifications to Telegram via Bot API
sheet Entity and Repository for working with Google Sheets data
properties ScriptProperty for typed key-value storage in script properties

Requirements

  • Google Apps Script
  • @types/google-apps-script (peer dependency)

Common Pitfalls

  • Ui unavailable: When script runs from a trigger, onEdit, or time-driven execution, SpreadsheetApp.getUi() throws. Always use Ui.isAvailable() before alert, confirm, prompt.
  • Secrets: Store botToken in PropertiesService.getScriptProperties(), not in source code.
  • Entity columns: Column indices are 0-based (same as array indices).

License

ISC