A comprehensive automation tool for Feishu spreadsheets enabling AI agents to perform full CRUD operations on worksheets and cell data.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install feishu-sheets-skill
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install feishu-sheets-skill using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Feishu Sheets?
The Feishu Sheets skill is a specialized integration designed for the Openclaw Skills ecosystem that allows AI agents to interact with online spreadsheets within the Feishu platform. It goes beyond simple data entry, providing a robust interface for managing the entire lifecycle of a spreadsheet—from creation and worksheet organization to complex data manipulation. By utilizing this skill, developers can bridge the gap between AI-driven logic and cloud-based data storage, making it easier than ever to maintain live datasets.
This skill is particularly effective for teams relying on the Feishu or Lark suites for collaboration. It supports a wide range of actions including reading specific ranges, appending new rows, and even handling specialized data types like formulas and hyperlinks. Whether you are building an automated reporting bot or a dynamic project tracker, integrating Feishu Sheets via Openclaw Skills ensures your agent has high-fidelity access to your most important organizational data.
Feishu Sheets Use Cases
- Automatically log daily task completions or system status updates directly into a shared Feishu spreadsheet using Openclaw Skills.
- Retrieve and analyze specific data points from large worksheets to provide context-aware answers to user queries.
- Programmatically generate new spreadsheets for monthly financial reports or project kick-offs.
- Bulk update inventory levels or CRM data by inserting or deleting rows based on real-time triggers.
- Insert complex calculations and formulas into cells to enable live data processing within the Feishu environment.
How Feishu Sheets Works
- Identification: The agent identifies the target document using a spreadsheet_token, which is extracted from the standard Feishu URL format.
- Action Selection: Depending on the task, the agent selects a specific action such as write, read, append, or get_info.
- Range Specification: For data operations, the skill uses standard A1 notation or dimension indices to target specific cells, rows, or columns.
- API Communication: The Openclaw Skills runner sends a secure request to the Feishu Open API, authenticated with the necessary permissions.
- Result Processing: The skill returns the API response, such as sheet metadata or cell values, back to the agent to inform the next step of the workflow.
Feishu Sheets Setup
To get started with Feishu Sheets, ensure your environment is configured for the feishu channel and the sheets tool is enabled. This is typically managed in your skill configuration file:
channels:
feishu:
tools:
sheets: true
Additionally, your Feishu App must be granted the following scopes in the developer console:
sheets:spreadsheet(To create and manage sheets)sheets:spreadsheet:readonly(To read data)drive:drive(To access cloud storage locations)
Feishu Sheets Data Schema & Taxonomy
The Feishu Sheets skill organizes data through tokens and IDs to ensure precise targeting. Below is a breakdown of the primary data components:
| Attribute | Description |
|---|---|
spreadsheet_token |
The unique string found in the URL after /sheets/ (e.g., shtABC123). |
sheet_id |
The specific worksheet identifier within the file (e.g., 0bxxxx). |
range |
Standard A1 notation (e.g., A1:C10) or row/column ranges (e.g., 1:5). |
values |
A 2D array of data items, supporting strings, numbers, and structured objects. |
Specialized data objects can be passed within the values array:
- Formulas:
{"type": "formula", "text": "=SUM(A1:A10)"} - Hyperlinks:
{"type": "url", "text": "Open Link", "link": "https://example.com"}
Feishu Sheets Advanced Features
- Multi-worksheet management: Dynamically add or delete specific worksheets within a single spreadsheet using Openclaw Skills.
- Dimension control: Granular control over inserting or deleting rows and columns by index to maintain sheet structure.
- Metadata Discovery: Use the get_info action to programmatically discover all available sheet_ids and titles within a document.
- Folder integration: Create new spreadsheets directly within specific Feishu Drive folders using the folder_token parameter.
- High-fidelity data support: Seamlessly handle mixed data types including numbers, strings, and rich-text links in a single operation.
SKILL.md
Loading
Related Openclaw Skills
Audos Workspace Builder
An autonomous engine that transforms a business idea into a fully functional startup workspace and landing page in under ten minutes.
SERA Lexicon & Unified Dynamics
A functional framework for shifting AI agents from simple persona-mimicry to structural, computable emergent identity using mathematical dynamics.
CC Coder
An automated development assistant that utilizes the Claude Code CLI to execute, verify, and document complex programming tasks.
Doubao Image and Video Skill
A comprehensive AI skill for generating high-quality images and videos and performing intelligent image edits via the ByteDance Doubao API.
Feishu Sheets
A comprehensive tool for AI agents to manage Feishu online spreadsheets including data manipulation and worksheet management.
Blog Automation
A professional automation skill for converting markdown content into scheduled WordPress posts via REST API.
Featured*
