@sysa-ivan/gas-helpers
v1.2.5
Published
Helper utilities for Google Apps Script: UI dialogs, triggers, Telegram notifications, Entity/Repository for Sheets
Maintainers
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-helpersModules
| 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 useUi.isAvailable()beforealert,confirm,prompt. - Secrets: Store
botTokeninPropertiesService.getScriptProperties(), not in source code. - Entity columns: Column indices are 0-based (same as array indices).
License
ISC
