personal-worklist-via-feishu

personal-worklist-via-feishu 1.0.0 > A smart personal work tracker powered by Feishu Bitable + OpenClaw AI. Task entry, progress review, and three daily reminders — all in one. --- ## 🌍 English --- ### Overview **personal-worklist-via-feishu** transforms your Feishu Bitable into a **personal AI work command center**. It works natively inside OpenClaw — just send a message to add tasks, update status, or trigger a review. No app switching, no manual spreadsheet edits. This skill is ideal for professionals who: - Want a lightweight task tracker without switching tools - Use Feishu as their primary workplace communication app - Need structured daily reminders with PMBOK-style review --- ### Features #### 📝 Natural Task Entry Say `"add task: Complete the project PPT by Friday, urgent"` and the AI will: 1. Confirm task name, priority level, and deadline with you 2. Auto-classify the source type (Planned / Urgent / Routine / Collaboration) 3. Write the result directly to your Feishu Bitable #### 🔔 Three Daily Reminders (Scheduled) Three cron-powered nudges fire every workday: | Time | Content | |------|---------| | **Morning 08:28** | Priority① tasks + full in-progress task list with table view | | **Afternoon 14:00** | Same task list + 30-min buffer suggestion before afternoon focus | | **End of Day 17:30** | PMBOK 5-step progress review — completion rate, pending decisions, bottleneck analysis, tomorrow preview | > Reminders are **language-aware**: once you choose Chinese or English at first use, all future reminders stay in that language. Holidays are detected automatically — no messages sent on days off. #### 📋 Status Updates via Conversation No need to open the spreadsheet. Just say: | You say | AI does | |---------|---------| | `完成了` / `done` | Marks task as Done in Bitable | | `取消了` / `cancelled` | Marks task as Cancelled | | `推迟到下周一` / `defer to next Monday` | Updates the deadline (with date verification) | | `复盘` / `review` | Triggers full PMBOK daily review | | `诊断` / `diagnose` | Runs 5-point health check | #### 🌐 Full Bilingual Support (中文 / English) At first launch, the AI asks you to choose a language. All outputs — reminders, confirmations, status updates — follow that language exclusively. No mixing. --- ### Prerequisites Before installing, make sure you have: | Requirement | Details | |-------------|---------| | **OpenClaw** | Any recent version (Windows host recommended) | | **Feishu Bitable** | A free-tier Bitable is sufficient | | **Feishu App** | A Feishu application with Bitable API permissions enabled | | **Node.js** | v16 or higher | > **Feishu API Permissions Required** (enable in [Feishu Open Platform](https://open.feishu.cn/)): > - `bitable:app` — Read/write access to Bitable > - `bitable:table` — Table operations > - `bitable:record` — Record read/write --- ### Installation #### Step 1 — Extract Extract `personal-worklist-via-feishu.zip` to your OpenClaw skills directory: ``` ~/.openclaw/workspace-robotB/skills/personal-worklist-via-feishu/ ``` #### Step 2 — Configure Credentials ```bash cd personal-worklist-via-feishu node scripts/set_config.js --app-token "YOUR_APP_TOKEN" --table-id "YOUR_TABLE_ID" ``` **How to find APP_TOKEN and TABLE_ID:** 1. Open your Feishu Bitable in a browser 2. The URL looks like: `https://xxx.feishu.cn/base/YOUR_APP_TOKEN?table=YOUR_TABLE_ID` 3. Copy the value after `/base/` → APP_TOKEN 4. Copy the value after `table=` → TABLE_ID #### Step 3 — Initialize Fields If your Bitable is **new or without the required fields**, run: ```bash node scripts/init_table.js --open-id "YOUR_FEISHU_OPEN_ID" --lang zh ``` If your Bitable **already has a structure**, you can skip this step. > `YOUR_FEISHU_OPEN_ID` — Your Feishu user Open ID. Find it in the Feishu developer console, or ask your administrator to add you as an editor. #### Step 4 — Verify ```bash node scripts/health_check.js ``` If you see `✅ All checks passed`, you're ready to use the skill. --- ### Required Bitable Fields If you are using an **existing Bitable**, ensure these fields exist with the EXACT names and options below: | Field Name | Field Type | Options (Chinese) | Options (English) | |------------|-----------|-------------------|-------------------| | 任务名称 / Task Name | Text | — | — | | 来源分类 / Source Category | Single Select | 计划任务[P] / 临时任务[U] / 例行任务[R] / 协作任务[C] | Planned[P] / Urgent[U] / Routine[R] / Collab[C] | | 优先级 / Priority | Single Select | ①紧急且重要 / ②重要不紧急 / ③紧急不重要 / ④不紧急不重要 | ① Urgent & Important / ② Not Urgent but Important / ③ Urgent but Not Important / ④ Not Urgent and Not Important | | 状态 / Status | Single Select | 待办 / 进行中 / 已完成 / 取消 | To Do / In Progress / Done / Cancelled | | 截止日期 / Deadline | Date | yyyy/MM/dd | yyyy/MM/dd | | 预计时长 / Estimated Time | Text | e.g. `1h`, `2h` | e.g. `1h`, `2h` | | 开始时间 / Start Time | Text | e.g. `9:00` or `2026-05-06` | e.g. `9:00` or `2026-05-06` | | 工作链接 / Work Link | URL | — | — | | 工作要求 / Requirements | Multi-line Text | — | — | | 干系人 / Stakeholder | Text | — | — | | 存在问题 / Issues | Multi-line Text | — | — | | 备注 / Notes | Multi-line Text | — | — | > Run `node scripts/init_table.js` to auto-create any missing fields automatically. --- ### Trigger Words (Full Reference) ``` // 📝 Task Entry 记一下工作：XXXX → Add task (Chinese) add task: XXXX → Add task (English) // 📋 Status Updates 完成了 / done → Mark as Done 取消了 / cancelled → Mark as Cancelled 还在做 / still working → Mark as In Progress 推迟到XX / defer to XX → Update deadline // 🔔 Reminders (auto-triggered by cron, no user trigger needed) Morning 08:28 → Daily focus list Afternoon 14:00 → Afternoon work plan 17:30 Mon–Fri → PMBOK progress review // 📊 Review & Diagnostics 复盘 / review → Run PMBOK daily review 台账不工作了 / diagnose → Run 5-point health check ``` --- ### How the Reminder Cron Works The three cron jobs are configured automatically when you first add a task (via `setup_reminders.js`). They fire on the following logic: ``` Morning 08:28 / Afternoon 14:00 → Read: Start Time ≤ today AND Status ≠ Done → Output: Priority① tasks + full task table End of Day 17:30 (Mon–Fri only) → Read: Deadline = today AND Status ≠ Done → Step 1: Completion rate (X done / Y total) → Step 2: Uncompleted task decisions (defer / cancel / has plan) → Step 3: Bottleneck analysis → written to "Issues" field → Step 4: Work suggestions (PMBOK risk response + schedule recovery) → Step 5: Tomorrow preview (important & urgent, status ≠ Done) ``` **Holiday detection**: The AI runs an internal check before each reminder. If today is a Chinese public holiday, the reminder is silently skipped. No message is sent. --- ### Changelog #### v1.0.0 (2026-05-06) - Initial public release - Full bilingual support (Chinese / English) - Three daily reminders (morning / afternoon / end-of-day review) - PMBOK-style progress review - Natural language task entry and status updates - Automated Bitable field initialization - 5-point health check diagnostic --- ### Troubleshooting | Symptom | Likely Cause | Fix | |--------|-------------|-----| | Reminder says "no tasks" but tasks exist | Start Time not set or is future-dated | Open Bitable and set Start Time to today or earlier | | `health_check.js` fails at "API connectivity" | Wrong App ID / App Secret | Verify credentials in Feishu Open Platform | | Task not written to Bitable | Missing field or wrong field name | Run `init_table.js` to auto-create required fields | | Language switches unexpectedly | preferences.json may be corrupted | Delete `memory/preferences.json` and restart | | Reminder fires on weekend | Old cron from previous skill version | Run `openclaw cron list`, delete old entries, re-run `setup_reminders.js` | --- ### Compatibility | Platform | Compatible | |----------|-----------| | Windows (OpenClaw host) | ✅ | | macOS (OpenClaw host) | ✅ (untested, should work) | | Linux (OpenClaw host) | ✅ (untested, should work) | | Feishu Free Tier Bitable | ✅ | | Feishu Enterprise Bitable | ✅ | --- ### License MIT License — free to use, modify, and distribute. --- ## 🇨🇳 中文 --- ### 概览 **personal-worklist-via-feishu** 将飞书多维表格变成**个人 AI 工作指挥中心**。它运行在 OpenClaw 上——只需发一条消息，就能添加任务、更新状态、触发复盘。无需切换应用，无需手动编辑表格。 适合以下用户： - 希望有轻量级任务管理工具，但不想要切换多个应用 - 飞书是主要的工作沟通工具 - 需要结构化的每日提醒和 PMBOK 式进度复盘 --- ### 核心功能 #### 📝 自然语言任务录入 发送 `"记一下工作：周五前完成项目PPT，紧急"`，AI 自动： 1. 与你确认任务名称、优先级、截止日期 2. 自动归类来源类型（计划任务 / 临时任务 / 例行任务 / 协作任务） 3. 将结果直接写入飞书多维表格 #### 🔔 三段式定时提醒 三个 cron 定时任务，每个工作日自动触发： | 时间 | 内容 | |------|------| | **早晨 08:28** | 优先级①任务 + 完整进行中/待办任务表格 | | **下午 14:00** | 同样的任务清单 + 30分钟缓冲工作建议 | | **下班前 17:30（仅工作日）** | PMBOK 五步进度复盘 — 完成率、未完成决策、阻碍分析、明日预告 | > 提醒**语言自适应**：首次使用时选择中文或英文后，所有后续提醒都使用该语言。节假日 AI 自动判断，不推送任何消息。 #### 📋 对话式状态更新 无需打开表格，直接说： | 你说 | AI 自动 | |------|---------| | `完成了` | 标记为「已完成」 | | `取消了` | 标记为「取消」 | | `还在做` | 标记为「进行中」 | | `推迟到下周一` | 更新截止日期（含日期验证） | | `复盘` | 触发 PMBOK 进度复盘 | | `诊断` | 运行五项健康诊断 | #### 🌐 中英双语 首次启动时 AI 会要求选择语言环境。所有输出——提醒、确认、状态更新——全程使用该语言，不混用。 --- ### 环境要求 | 环境要求 | 说明 | |---------|------| | **OpenClaw** | 任意近期版本（建议 Windows 主机） | | **飞书多维表格** | 免费版多维表格即可 | | **飞书应用** | 已开通多维表格 API 权限的飞书应用 | | **Node.js** | v16 及以上 | > **飞书 API 权限清单**（在[飞书开放平台](https://open.feishu.cn/)开通）： > - `bitable:app` — 多维表格读写权限 > - `bitable:table` — 数据表操作权限 > - `bitable:record` — 记录读写权限 --- ### 安装步骤 #### 第一步 — 解压安装 将 `personal-worklist-via-feishu.zip` 解压到 OpenClaw 的 skills 目录： ``` ~/.openclaw/workspace-robotB/skills/personal-worklist-via-feishu/ ``` #### 第二步 — 配置凭证 ```bash cd personal-worklist-via-feishu node scripts/set_config.js --app-token "你的APP_TOKEN" --table-id "你的TABLE_ID" ``` **如何获取 APP_TOKEN 和 TABLE_ID：** 1. 在浏览器中打开你的飞书多维表格 2. URL 格式：`https://xxx.feishu.cn/base/你的APP_TOKEN?table=你的TABLE_ID` 3. `/base/` 后面的部分是 APP_TOKEN 4. `table=` 后面的部分是 TABLE_ID #### 第三步 — 初始化字段 如果你的多维表格是**新建的或还没有要求字段**，运行： ```bash node scripts/init_table.js --open-id "你的飞书OPEN_ID" --lang zh ``` 如果你的多维表格**已有完整字段结构**，可以跳过此步。 #### 第四步 — 验证安装 ```bash node scripts/health_check.js ``` 看到 `✅ 健康检查通过` 即表示安装成功。 --- ### 多维表格字段要求 如果你使用**已有表格**，请确保以下字段存在且名称完全一致： | 字段名称 | 字段类型 | 选项值 | |---------|---------|--------| | 任务名称 | 文本 | — | | 来源分类 | 单选 | 计划任务[P] / 临时任务[U] / 例行任务[R] / 协作任务[C] | | 优先级 | 单选 | ①紧急且重要 / ②重要不紧急 / ③紧急不重要 / ④不紧急不重要 | | 状态 | 单选 | 待办 / 进行中 / 已完成 / 取消 | | 截止日期 | 日期 | yyyy/MM/dd | | 预计时长 | 文本 | 如 1h、2h | | 开始时间 | 文本 | 如 9:00 或 2026-05-06 | | 工作链接 | URL | — | | 工作要求 | 多行文本 | — | | 干系人 | 文本 | — | | 存在问题 | 多行文本 | — | | 备注 | 多行文本 | — | > 运行 `node scripts/init_table.js` 可自动创建所有缺失字段。 --- ### 触发词完整对照表 ``` // 📝 任务录入 记一下工作：XXXX → 录入任务（中文） add task: XXXX → 录入任务（英文） // 📋 状态更新 完成了 / done → 标记已完成 取消了 / cancelled → 标记取消 还在做 / still working → 标记进行中 推迟到XX / defer to XX → 更新截止日期 // 🔔 定时提醒（cron 自动触发，无需用户触发） 早晨 08:28 → 今日任务重点 下午 14:00 → 下午工作计划 17:30（周一至周五） → PMBOK 进度复盘 // 📊 复盘与诊断 复盘 / review → 运行 PMBOK 进度复盘 台账不工作了 / diagnose → 运行五项健康检查 ``` --- ### 三段式提醒运行原理 三条 cron 任务在首次录入任务时自动配置（通过 `setup_reminders.js`），触发逻辑如下： ``` 早晨 08:28 / 下午 14:00 → 筛选：开始时间 ≤ 今天 且 状态 ≠ 已完成 → 输出：今日重点（优先级①）+ 进行中/待办任务表格 下班前 17:30（周一至周五） → 筛选：截止日期 = 今天 且 状态 ≠ 已完成 → 步骤1：完成率统计（今日共X项 / 完成X项） → 步骤2：未完成任务逐一决策（推迟 / 取消 / 已有后续计划） → 步骤3：阻碍分析 → 写入多维表格「存在问题」字段 → 步骤4：PMBOK 风险应对建议 + 进度纠偏方案 → 步骤5：明日预告（状态≠已完成的重要紧急任务） ``` **节假日判断**：AI 在每次提醒触发前运行内部判断，若当天为中国法定节假日则静默跳过，不推送任何消息。 --- ### 更新日志 #### v1.0.0 (2026-05-06) - 首次公开发布 - 完整中英双语支持 - 三段式每日提醒（早晨 / 下午 / 下班前复盘） - PMBOK 五步进度复盘 - 自然语言任务录入和状态更新 - 多维表格字段自动初始化 - 五项健康诊断 --- ### 故障排查 | 现象 | 原因 | 解决方法 | |------|------|---------| | 提醒显示"暂无任务"但表格里有任务 | 开始时间未设置或设置为了未来日期 | 在多维表格中设置开始时间为今天或更早 | | `health_check.js` 在"API连通性"步骤失败 | App ID / App Secret 错误 | 在飞书开放平台核对凭证 | | 任务写入失败 | 字段缺失或字段名称不匹配 | 运行 `node scripts/init_table.js` 自动创建字段 | | 语言意外切换 | preferences.json 可能损坏 | 删除 `memory/preferences.json` 后重新启动 | | 周末收到提醒 | 旧版 skill 的 cron 未删除干净 | 运行 `openclaw cron list` 删除旧条目后重新运行 `setup_reminders.js` | --- ### 兼容性 | 平台 | 兼容状态 | |------|---------| | Windows（OpenClaw 主机） | ✅ | | macOS（OpenClaw 主机） | ✅（未实测，应可运行） | | Linux（OpenClaw 主机） | ✅（未实测，应可运行） | | 飞书免费版多维表格 | ✅ | | 飞书企业版多维表格 | ✅ | --- ### 开源协议 MIT License — 可自由使用、修改和分发。 --- ## 📦 Package Contents ``` personal-worklist-via-feishu/ ├── SKILL.md # Full skill specification (for AI) ├── INSTALL.md # Technical installation guide ├── package.json ├── scripts/ │ ├── add_task.js # Write new task to Bitable │ ├── update_task.js # Update task status / fields │ ├── list_tasks.js # Read task list │ ├── init_table.js # Auto-initialize Bitable fields │ ├── health_check.js # 5-point health diagnostic │ ├── setup_reminders.js # Auto-configure 3 cron reminders │ ├── set_config.js # Configure APP_TOKEN + TABLE_ID │ ├── check_permissions.js # Check Feishu API connectivity │ ├── request.js # Unified HTTP layer (token cache + retry) │ ├── i18n.js # Bilingual text templates │ ├── preferences.js # Language preference storage │ └── utils.js # Feishu API utilities └── examples/ ├── README.md └── test-prompts.md # Sample trigger phrases ``` --- *Published under MIT License. Supports OpenClaw on Windows. Feishu Bitable required (free tier works).*