← Back to Skills Marketplace
yuqing-bitable-and-label
by
FrankieWay
· GitHub ↗
· v2.0.8
· MIT-0
360
Downloads
1
Stars
0
Active Installs
6
Versions
Install in OpenClaw
/install yuqing-bitable-and-label
Description
Incrementally sync data from XiaoAi API to Feishu Bitable and optionally auto-label records with machine-based type and sentiment annotations.
Usage Guidance
This skill appears to implement the claimed sync-and-label workflow and requires Feishu app credentials and a XiaoAi token — those are expected. Things to consider before installing:
- Do NOT set OPENAI_API_KEY / OPENAI_BASE_URL / OPENAI_MODEL unless you trust the external LLM gateway: if provided the skill will send record content to that gateway (default base is api.openai.com), but the SKILL.md did not declare network permissions for that. That mismatch can result in unexpected outbound data transfer.
- The skill writes logs, a cache directory, and lock/status files inside its own directory and the provided shell helpers may edit the local .env (monitor.sh/sync.sh include auto-fix logic). Review any .env you place in the skill directory so it does not contain unrelated secrets.
- If you plan to run this in production, run it in an isolated environment or staging workspace first and inspect outputs (sync.log, error.log, .sync_status.json). Confirm the run_only network hosts are acceptable.
- If you need labeling without sending data to third-party LLMs, verify the labeling mode will accept model outputs via stdin (the code supports a stdin/OpenClaw mode) and avoid supplying OPENAI_* env vars.
- If you want to be safer, audit the run_once functions in excel_to_feishu_bitable.py and bitable_labeling_skill.py (they perform HTTP calls and modify bitable fields) to confirm there are no additional unexpected endpoints or behaviors.
Capability Analysis
Type: OpenClaw Skill
Name: yuqing-bitable-and-label
Version: 2.0.8
The skill bundle is a comprehensive tool for synchronizing public sentiment data from the XiaoAi (Wisers) API to Feishu Bitable and performing automated labeling using LLMs. The Python scripts (excel_to_feishu_bitable.py, bitable_labeling_skill.py) implement robust data handling, including token caching, connection pooling, and batch processing. The shell scripts (sync.sh, monitor.sh) provide operational support such as health checks, log rotation, and error recovery. The permissions are appropriately restricted to Feishu and the specified data service, and the code contains no evidence of malicious intent, data exfiltration, or unauthorized execution.
Capability Assessment
Purpose & Capability
The declared inputs (Feishu APP_ID/APP_SECRET, XiaoAi token, bitable_url) match the stated purpose of syncing data to a Feishu Bitable and writing labels. The code implements expected behaviors (fetch from XiaoAi API, write to Feishu bitable, optional labeling). Note: the labeling component optionally uses an OpenAI-compatible gateway if OPENAI_* env vars are provided; that capability is plausible for the stated labeling purpose but is not listed in SKILL.md inputs or permissions.
Instruction Scope
The SKILL.md entrypoint runs sync_and_label_skill.py which follows the declared purpose. However the labeling runtime can (if OPENAI_API_KEY / OPENAI_BASE_URL / OPENAI_MODEL are set) send record content to an arbitrary OpenAI-compatible endpoint. SKILL.md's network permissions only list Feishu and the default XiaoAi host, so outbound calls to api.openai.com or other gateways are not declared. Additionally auxiliary scripts (sync.sh, monitor.sh) read/write .env, .cache, logs, and may modify files in the skill directory (e.g., sed edits of .env), which expands the runtime scope beyond a simple one-shot sync.
Install Mechanism
There is no install spec (instruction-only for platform), and provided files are Python scripts and shell helpers that run in-place. No remote download/install from arbitrary URLs is present, which is lower risk. The package includes several helper scripts and caches but nothing that auto-fetches executable code at install time.
Credentials
Required secrets (Feishu APP_ID/APP_SECRET, XiaoAi token) are proportional to the sync/write-to-bitable functionality. However the code will also use optional environment variables OPENAI_API_KEY / OPENAI_BASE_URL / OPENAI_MODEL (and other LLM config) to call external LLM gateways. Those are not declared in the skill inputs or network permissions; if set they enable sending user content to arbitrary endpoints. The shell helpers source a .env file from the skill directory (not system-wide) but will mutate it via auto-fix logic — review before use.
Persistence & Privilege
The skill is not always-enabled and does not request elevated platform privileges. It creates local files (.cache, logs, .sync.lock) and may modify files inside its own skill directory (e.g., .env auto-fix), but it does not modify other skills or request system-wide persistent privileges.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install yuqing-bitable-and-label - After installation, invoke the skill by name or use
/yuqing-bitable-and-label - Provide required inputs per the skill's parameter spec and get structured output
Version History
v2.0.8
Version 2.0.8
- No file changes were detected for this release.
- Functionality remains unchanged from the previous version.
v2.0.7
Version 2.0.7
- No detectable file or configuration changes in this release.
v2.0.6
Expanded labeling capabilities and system prompts.
- Added new system prompt files for emotion, type, product, device, brand, brand safety, and competitive mention labeling.
- Labeling items expanded: now supports machine labeling for type, sentiment, competitive mention, device, and AI-powered checks for brand/content safety.
- Updated description and configuration to reflect enhanced labeling and AI checks.
- No changes to input/output parameters or permissions beyond updating descriptions.
v2.0.5
No changes detected in this version.
- No file or configuration updates.
- Functionality and interface remain the same.
v2.0.3
- Version bump to 2.0.2.
- No functional or configuration changes detected.
v2.0.1
Version 2.0.1 (yuqing-bitable-and-label → xiaoai_sync_and_label)
- Skill renamed to xiaoai_sync_and_label and version reset to 1.0.0.
- Now supports incremental data sync from 小爱 API into Feishu Bitable, followed by optional machine labeling.
- Labeling can be toggled via the run_labeling input; labels are generated by an internal model.
- Updated and expanded configurable inputs for data sync and labeling.
- Defined clear outputs for sync and labeling record counts.
- Network permissions restricted to required service endpoints.
Metadata
Frequently Asked Questions
What is yuqing-bitable-and-label?
Incrementally sync data from XiaoAi API to Feishu Bitable and optionally auto-label records with machine-based type and sentiment annotations. It is an AI Agent Skill for Claude Code / OpenClaw, with 360 downloads so far.
How do I install yuqing-bitable-and-label?
Run "/install yuqing-bitable-and-label" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is yuqing-bitable-and-label free?
Yes, yuqing-bitable-and-label is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does yuqing-bitable-and-label support?
yuqing-bitable-and-label is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created yuqing-bitable-and-label?
It is built and maintained by FrankieWay (@frankieway); the current version is v2.0.8.
More Skills