Note: Feishu Sheets (electronic spreadsheets) are different from Bitable (multi-dimensional tables). Use feishu-bitable tools for Bitable.
URL Format
https://xxx.feishu.cn/sheets/TOKEN?sheet=SHEET_ID
Extract spreadsheet_token from the URL path.
Tools
feishu_sheets_get_meta
Get spreadsheet metadata.
{ "spreadsheet_token": "shtcnXXX" }
feishu_sheets_list_sheets
List all worksheets with sheet_id, title, dimensions.
{ "spreadsheet_token": "shtcnXXX" }
feishu_sheets_read_range
Read cells from a range.
{
"spreadsheet_token": "shtcnXXX",
"range": "Sheet1!A1:C10"
}
Whole column: "Sheet1!A:C". Whole sheet: "Sheet1".
feishu_sheets_write_range
Write data to cells. Values is a 2D array.
{
"spreadsheet_token": "shtcnXXX",
"range": "Sheet1!A1:C2",
"values": [
["Name", "Age", "City"],
["Alice", 30, "Beijing"]
]
}
feishu_sheets_append
Append rows after existing data.
{
"spreadsheet_token": "shtcnXXX",
"range": "Sheet1!A1:C1",
"values": [
["Bob", 25, "Shanghai"],
["Carol", 28, "Shenzhen"]
]
}
feishu_sheets_set_dimension
Set column width or row height. Indices are 1-based, inclusive.
{
"spreadsheet_token": "shtcnXXX",
"sheet_id": "abc123",
"dimension": "COLUMNS",
"start_index": 1,
"end_index": 3,
"fixed_size": 200
}
Common Workflows
Read a spreadsheet
feishu_sheets_list_sheets→ get sheet names and IDsfeishu_sheets_read_range→ read data
Add data to a table
feishu_sheets_list_sheets→ get sheet structurefeishu_sheets_append→ add rows
Adjust column widths
feishu_sheets_list_sheets→ get sheet_idfeishu_sheets_set_dimensionwith COLUMNS
Value Types
| Input | Result |
|---|---|
"text" |
String cell |
123 |
Number cell |
true/false |
Boolean cell |
null |
Empty cell |
Notes
- Range format:
SheetName!A1:C10(sheet name + range) - Sheet IDs from
feishu_sheets_list_sheetsare needed forset_dimension - Max read: 5000 rows per request