← 返回 Skills 市场
232
总下载
0
收藏
0
当前安装
2
版本数
在 OpenClaw 中安装
/install employee-reminder-ops
功能描述
Google Sheets-driven employee reminder and special-event reporting workflow for internal operations. Use when setting up or migrating birthday reminders, dai...
使用说明 (SKILL.md)
Employee Reminder Ops
Use this skill when working on the internal reminder workflow currently called Plan A.
What this skill covers
- Read employee and special-event data from Google Sheets
- Generate daily reminder reports
- Route reminder reports into Telegram or Discord groups/channels
- Configure scheduler/runtime for daily 7:00 AM reports
- Migrate the workflow to another machine
Core workflow
- Load staff and event data from Google Sheets
- Normalize dates and detect upcoming birthdays/events
- Render one report message per day
- Send the report to the mapped chat/group/channel
- Avoid duplicate sends for the same day
Current data model
Google Sheet
- Spreadsheet ID is deployment config, not hardcoded in the skill
- Staff tab example:
Trang tính1 - Event tab example:
NgayDacBiet
Staff columns
Mã NVHọ và TênBộ PhậnLoại hình nhân sựVị tríNgày sinh
Event columns
STTTên sự kiệnNgày diễn raLoại sự kiệnBộ phận phụ tráchGhi chúNhắc trướcKích hoạt
Deployment guidance
Read references/deployment.md when setting up on a new machine.
Runtime/config boundary
Keep these outside the skill package:
- Google OAuth tokens
- Telegram/Discord bot tokens
- group/channel IDs
.env*.state/*- logs
Bundle only:
- workflow scripts
- schema notes
- templates/examples
- scheduler examples
assets/windows/example env file and PowerShell helper for Windows bring-up
Included references
references/architecture.md- Plan A architecture and routing notesreferences/deployment.md- install/migrate checklistreferences/google-sheet-schema.md- canonical Sheet structure for staff/eventsreferences/clawhub.md- publish/install/update commands via ClawHubreferences/troubleshooting.md- common runtime/scheduler/data issuesreferences/windows.md- Windows-specific deployment notesreferences/macos.md- macOS-specific deployment notes
安全使用建议
This skill appears to implement the claimed Google Sheets → Discord/Telegram reminder workflow, but there are important mismatches you should address before installing or running it:
- Metadata vs reality: The registry metadata lists no required binaries or env vars, but the code requires Node.js and the 'gog' CLI and expects many environment variables (e.g., PLAN_A_SHEET_ID, DISCORD_BOT_TOKEN, GOG_ACCOUNT, PLAN_A_STATE_DIR). Treat those env vars as secrets (especially DISCORD_BOT_TOKEN).
- Hardcoded defaults: The script embeds a default spreadsheet ID, a default Discord channel ID, and a default GOG account. Verify the default spreadsheet ID belongs to your organization (or overwrite it) — otherwise you may be reading or interacting with an unrelated sheet or channel.
- Absolute path in run-plan-a.sh: The bundled shell helper contains a hardcoded developer path (/Users/vtammm/.openclaw/workspace). Do not run that script as-is; edit it to your environment or run the Node script directly from a controlled location.
- State files: The tool will create and update a .state directory and JSON state file in the working directory; inspect those files and ensure your runtime location is appropriate and not a shared/public repo.
- Safe testing: Before connecting any real bot token, run the preview and json modes (node plan-a-demo.js preview or json) to inspect output. Only run 'send' or 'prod-send' after you have confirmed configuration and used a test Discord/Telegram bot and test channel.
- Secrets handling: Follow the SKILL.md advice: do not commit tokens to Git, use local .env files that are excluded from VCS, and rotate tokens if they are accidentally exposed.
If you need higher confidence, request that the publisher update the registry metadata to declare required binaries/env vars and remove or replace the hardcoded defaults and absolute paths. Review the plan-a-demo.js source yourself (or in an isolated environment) before granting any secrets or scheduling automated runs.
功能分析
Type: OpenClaw Skill
Name: employee-reminder-ops
Version: 1.0.1
The skill bundle provides a legitimate workflow for automating employee birthday and event reminders from Google Sheets to Discord or Telegram. The core logic in `scripts/plan-a-demo.js` uses a helper CLI tool (`gog`) to fetch data and the Discord API to post reports, with clear documentation in `SKILL.md` and various reference files. While it contains hardcoded default IDs and local paths (e.g., `/Users/vtammm/`), these appear to be development artifacts rather than malicious indicators, and the documentation explicitly instructs users to manage sensitive tokens via environment variables.
能力评估
Purpose & Capability
The skill claims to be a Google Sheets-driven reminder workflow (Plan A) which legitimately needs a Google CLI and chat bot tokens. However, the registry metadata declares no required binaries or environment variables, while the code requires the 'gog' CLI, Node.js runtime, and multiple environment variables (PLAN_A_SHEET_ID, DISCORD_BOT_TOKEN, GOG_ACCOUNT, etc.). Also the code contains hardcoded defaults (spreadsheet ID, Discord channel ID, gog account) that are unexpected in a generic skill package.
Instruction Scope
SKILL.md and the JS implement the intended workflow (read Sheets via gog, build reports, POST to Discord). That scope is coherent. Concerns: the demo script will execute the external 'gog' binary and POST to discord if run with a token; it reads/writes a .state file in the workspace (creates state and lastError). The bundled run-plan-a.sh contains an absolute user-specific path (/Users/vtammm/.openclaw/workspace) which is a leftover dev path and could cause surprising behavior if executed as-is.
Install Mechanism
There is no install spec (instruction-only + code files), which minimizes install-time risk. The runtime relies on external tools (Node.js and the gog CLI) and suggests using ClawHub; these are standard for this kind of skill. No remote download URLs or archive extraction are present. Still, the lack of declared required binaries in metadata is an inconsistency.
Credentials
The package metadata lists no required environment variables, but code and docs reference many environment variables including sensitive tokens (DISCORD_BOT_TOKEN, DISCORD_CHANNEL_ID), a GOG account, and local state paths. There are also hardcoded defaults for spreadsheet ID, Discord channel ID, and GOG_ACCOUNT inside the script — this both contradicts the SKILL.md statement that spreadsheet ID is 'deployment config' and increases the risk of accidental use of someone else's sheet or channel if not overridden.
Persistence & Privilege
The skill does not request elevated platform privileges or always:true. It writes a .state directory and state file under the working directory (by default process.cwd()/.state) to track sent reports and lastError; this is expected for duplicate-prevention but is persistent storage. The run script's hardcoded cd path is an out-of-package absolute path and should be removed/edited before running.
如何使用
- 确保已安装 OpenClaw(本地或 Docker 部署)
- 在对话框中输入安装命令:
/install employee-reminder-ops - 安装完成后,直接呼叫该 Skill 的名称或使用
/employee-reminder-ops触发 - 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.1
Add troubleshooting docs, Windows/macOS deployment notes, schema docs, and Windows env examples
v1.0.0
Initial release: Google Sheets reminder workflow, Telegram/Discord routing, scheduler notes
元数据
常见问题
Employee Reminder Ops 是什么?
Google Sheets-driven employee reminder and special-event reporting workflow for internal operations. Use when setting up or migrating birthday reminders, dai... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 232 次。
如何安装 Employee Reminder Ops?
在 OpenClaw 或 Claude Code 对话框中运行命令「/install employee-reminder-ops」即可一键安装,无需额外配置。
Employee Reminder Ops 是免费的吗?
是的,Employee Reminder Ops 完全免费,采用 MIT-0 许可证,可自由下载、安装和使用。
Employee Reminder Ops 支持哪些平台?
Employee Reminder Ops 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。
谁开发了 Employee Reminder Ops?
由 Vĩnh Tâm(@vt-mmm)开发并维护,当前版本 v1.0.1。
推荐 Skills