Feishu Sheets Tool

Single tool

feishu_sheets

with action parameter for all spreadsheet operations.

Token Extraction

From URL

https://xxx.feishu.cn/sheets/shtABC123

→

spreadsheet_token

=

shtABC123

Actions

Create Spreadsheet

{ "action": "create", "title": "New Spreadsheet" }

Optional folder:

{ "action": "create", "title": "New Spreadsheet", "folder_token": "fldcnXXX" }

Returns: spreadsheet_token, url, title

Write Values

{
  "action": "write",
  "spreadsheet_token": "shtABC123",
  "sheet_id": "0bxxxx",
  "range": "A1:C3",
  "values": [["Name", "Age", "City"], ["Alice", 25, "Beijing"], ["Bob", 30, "Shanghai"]]
}

Read Values

{
  "action": "read",
  "spreadsheet_token": "shtABC123",
  "sheet_id": "0bxxxx",
  "range": "A1:C10"
}

Append Values

{
  "action": "append",
  "spreadsheet_token": "shtABC123",
  "sheet_id": "0bxxxx",
  "values": [["Charlie", 28, "Shenzhen"]]
}

Insert Rows/Columns

{
  "action": "insert_dimension",
  "spreadsheet_token": "shtABC123",
  "sheet_id": "0bxxxx",
  "dimension": "ROWS",
  "start_index": 5,
  "end_index": 7
}

Delete Rows/Columns

{
  "action": "delete_dimension",
  "spreadsheet_token": "shtABC123",
  "sheet_id": "0bxxxx",
  "dimension": "ROWS",
  "start_index": 5,
  "end_index": 7
}

Get Spreadsheet Info

{ "action": "get_info", "spreadsheet_token": "shtABC123" }

Returns: metadata including all sheet_ids and titles

Add Worksheet

{
  "action": "add_sheet",
  "spreadsheet_token": "shtABC123",
  "title": "Sheet2"
}

Delete Worksheet

{
  "action": "delete_sheet",
  "spreadsheet_token": "shtABC123",
  "sheet_id": "0bxxxx"
}

Range Format

• Cell:

  A1

  ,

  B5

• Range:

  A1:C10

  ,

  B2:D5

• Entire column:

  A:A

  ,

  B:D

• Entire row:

  1:1

  ,

  3:5

• With sheet_id:

  0bxxxx!A1:C10

Sheet ID

• From URL:

  https://xxx.feishu.cn/sheets/shtABC123?sheet=0bxxxx

• From get_info action
• Default first sheet often has simple id like

  0bxxxx

Data Types

Values can be:

• String:

  "Hello"

• Number:

  123

  ,

  45.67

• Formula:

  {"type": "formula", "text": "=SUM(A1:A10)"}

• Link:

  {"type": "url", "text": "Click here", "link": "https://..."}

Configuration

channels:
  feishu:
    tools:
      sheets: true  # default: true

Permissions Required

• sheets:spreadsheet

  - Create and manage spreadsheets

• sheets:spreadsheet:readonly

  - Read spreadsheet data

• drive:drive

  - Access cloud storage

API Reference

Base URL:

https://open.feishu.cn/open-apis/sheets/v2/spreadsheets/

See references/api-reference.md for detailed API documentation.