\r \r

Feishu Sheets Tool\r

\r Single tool feishu_sheets with action parameter for all spreadsheet operations.\r \r

Token Extraction\r

\r From URL https://xxx.feishu.cn/sheets/shtABC123 → spreadsheet_token = shtABC123\r \r

Actions\r

\r

Create Spreadsheet\r

\r

{ "action": "create", "title": "New Spreadsheet" }\r
```\r
\r
Optional folder:\r
```json\r
{ "action": "create", "title": "New Spreadsheet", "folder_token": "fldcnXXX" }\r
```\r
\r
Returns: spreadsheet_token, url, title\r
\r
### Write Values\r
\r
```json\r
{\r
  "action": "write",\r
  "spreadsheet_token": "shtABC123",\r
  "sheet_id": "0bxxxx",\r
  "range": "A1:C3",\r
  "values": [["Name", "Age", "City"], ["Alice", 25, "Beijing"], ["Bob", 30, "Shanghai"]]\r
}\r
```\r
\r
### Read Values\r
\r
```json\r
{\r
  "action": "read",\r
  "spreadsheet_token": "shtABC123",\r
  "sheet_id": "0bxxxx",\r
  "range": "A1:C10"\r
}\r
```\r
\r
### Append Values\r
\r
```json\r
{\r
  "action": "append",\r
  "spreadsheet_token": "shtABC123",\r
  "sheet_id": "0bxxxx",\r
  "values": [["Charlie", 28, "Shenzhen"]]\r
}\r
```\r
\r
### Insert Rows/Columns\r
\r
```json\r
{\r
  "action": "insert_dimension",\r
  "spreadsheet_token": "shtABC123",\r
  "sheet_id": "0bxxxx",\r
  "dimension": "ROWS",\r
  "start_index": 5,\r
  "end_index": 7\r
}\r
```\r
\r
### Delete Rows/Columns\r
\r
```json\r
{\r
  "action": "delete_dimension",\r
  "spreadsheet_token": "shtABC123",\r
  "sheet_id": "0bxxxx",\r
  "dimension": "ROWS",\r
  "start_index": 5,\r
  "end_index": 7\r
}\r
```\r
\r
### Get Spreadsheet Info\r
\r
```json\r
{ "action": "get_info", "spreadsheet_token": "shtABC123" }\r
```\r
\r
Returns: metadata including all sheet_ids and titles\r
\r
### Add Worksheet\r
\r
```json\r
{\r
  "action": "add_sheet",\r
  "spreadsheet_token": "shtABC123",\r
  "title": "Sheet2"\r
}\r
```\r
\r
### Delete Worksheet\r
\r
```json\r
{\r
  "action": "delete_sheet",\r
  "spreadsheet_token": "shtABC123",\r
  "sheet_id": "0bxxxx"\r
}\r
```\r
\r
## Range Format\r
\r
- Cell: `A1`, `B5`\r
- Range: `A1:C10`, `B2:D5`\r
- Entire column: `A:A`, `B:D`\r
- Entire row: `1:1`, `3:5`\r
- With sheet_id: `0bxxxx!A1:C10`\r
\r
## Sheet ID\r
\r
- From URL: `https://xxx.feishu.cn/sheets/shtABC123?sheet=0bxxxx`\r
- From get_info action\r
- Default first sheet often has simple id like `0bxxxx`\r
\r
## Data Types\r
\r
Values can be:\r
- String: `"Hello"`\r
- Number: `123`, `45.67`\r
- Formula: `{"type": "formula", "text": "=SUM(A1:A10)"}`\r
- Link: `{"type": "url", "text": "Click here", "link": "https://..."}`\r
\r
## Configuration\r
\r
```yaml\r
channels:\r
  feishu:\r
    tools:\r
      sheets: true  # default: true\r
```\r
\r
## Permissions Required\r
\r
- `sheets:spreadsheet` - Create and manage spreadsheets\r
- `sheets:spreadsheet:readonly` - Read spreadsheet data\r
- `drive:drive` - Access cloud storage\r
\r
## API Reference\r
\r
Base URL: `https://open.feishu.cn/open-apis/sheets/v2/spreadsheets/`\r
\r
See references/api-reference.md for detailed API documentation.\r
\r
\r
## Code Implementation\r
\r
Python实现: \feishu_sheets.py\r
\r
`python\r
from feishu_sheets import FeishuSheets\r
\r
# 创建请求\r
fs = FeishuSheets()\r
req = fs.build_create_request('New Sheet')\r
\r
# Token提取\r
token = FeishuSheets.extract_token('https://xxx.feishu.cn/sheets/shtABC123')\r
`\r