Feishu Sheet Reader
Extract and return data or metadata from Feishu Sheets by parsing sheet links, reading specific ranges, entire sheets, or listing sheet tabs.
Feishu Sheet Reader
Read data from Feishu Sheets (电子表格) via the Feishu API.
URL Format
Feishu sheet URLs look like:
https://my.feishu.cn/sheets/GHOustTi8h4sVPtCFdxcoznknve?sheet=062ee8
GHOustTi8h4sVPtCFdxcoznknve= spreadsheet token (first path segment after/sheets/)062ee8= sheet ID (query paramsheet=, the tab inside the spreadsheet)
Script Usage
python3 scripts/read_feishu_sheet.py <spreadsheet_token> [sheet_id] [range]
Examples:
# Read entire first sheet
python3 scripts/read_feishu_sheet.py GHOustTi8h4sVPtCFdxcoznknve
# Read specific sheet by ID
python3 scripts/read_feishu_sheet.py GHOustTi8h4sVPtCFdxcoznknve 062ee8
# Read specific range (e.g., A1:D10)
python3 scripts/read_feishu_sheet.py GHOustTi8h4sVPtCFdxcoznknve 062ee8 A1:D10
Output is tab-separated, suitable for pasting into analysis or reformatting.
Workflow
- Parse spreadsheet token and sheet ID from the URL
- Get Feishu app credentials from gateway config via
openclaw config get - Obtain tenant access token via Feishu Auth API
- Call Sheets API:
GET /open-apis/sheets/v2/spreadsheets/{token}/values/{range} - Format and return the data
Sheet ID Detection
If sheet_id is omitted, the script queries /sheets/v2/spreadsheets/{token}/sheets/query to list all sheets and uses the first one.
API Reference
- Auth:
POST https://open.feishu.cn/open-apis/auth/v3/tenant_access_token/internal - Sheet values:
GET https://open.feishu.cn/open-apis/sheets/v2/spreadsheets/{spreadsheetToken}/values/{range} - Sheet meta:
GET https://open.feishu.cn/open-apis/sheets/v2/spreadsheets/{spreadsheetToken}/sheets/query
Related skills
- Downloads
- 857All time
- Security audit
- Review
- Last updated
- 6mo ago
- Current version
- v1.0.0
- License
- MIT-0
