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#

1. Load staff and event data from Google Sheets
2. Normalize dates and detect upcoming birthdays/events
3. Render one report message per day
4. Send the report to the mapped chat/group/channel
5. 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ã NV
• Họ và Tên
• Bộ Phận
• Loại hình nhân sự
• Vị trí
• Ngày sinh

Event columns#

• STT
• Tên sự kiện
• Ngày diễn ra
• Loại sự kiện
• Bộ phận phụ trách
• Ghi chú
• Nhắc trước
• Kí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 notes
• references/deployment.md - install/migrate checklist
• references/google-sheet-schema.md - canonical Sheet structure for staff/events
• references/clawhub.md - publish/install/update commands via ClawHub
• references/troubleshooting.md - common runtime/scheduler/data issues
• references/windows.md - Windows-specific deployment notes
• references/macos.md - macOS-specific deployment notes