sheets

Lark Sheets Skill

Read and query Lark Sheets (spreadsheets) via the lark CLI.

Tool Location

tools/bin/lark

Run from the vault root directory with required env var:

LARK_CONFIG_DIR=tools/lark/.lark tools/bin/lark sheet <command>

Commands Reference

List Sheets in a Spreadsheet

tools/bin/lark sheet list <spreadsheet_token>

Lists all sheets (tabs) within a Lark spreadsheet. Returns sheet IDs, titles, dimensions, and hidden status.

Output:

{
  "spreadsheet_token": "T4mHsrFyzhXrj0tVzRslUGx8gkA",
  "sheets": [
    {
      "sheet_id": "abc123",
      "title": "Sheet1",
      "index": 0,
      "row_count": 100,
      "column_count": 10
    },
    {
      "sheet_id": "def456",
      "title": "Sheet2",
      "index": 1,
      "hidden": true,
      "row_count": 50,
      "column_count": 5
    }
  ],
  "count": 2
}

Fields:

• sheet_id: The unique ID of the sheet (use this with --sheet flag)
• title: Display name of the sheet
• index: Position of the sheet (0-indexed)
• hidden: Whether the sheet is hidden in the UI
• row_count / column_count: Dimensions of the sheet

Read Sheet Data

tools/bin/lark sheet read <spreadsheet_token> [--sheet <sheet_id>] [--range A1:Z100]

Reads cell values from a Lark spreadsheet.

Options:

• --sheet: Sheet ID to read from (default: first sheet by index)
• --range: Cell range to read (e.g., A1:Z100). Default: all data up to 1000 rows

Output:

{
  "spreadsheet_token": "T4mHsrFyzhXrj0tVzRslUGx8gkA",
  "sheet_id": "abc123",
  "range": "abc123!A1:D10",
  "row_count": 10,
  "column_count": 4,
  "values": [
    ["Header1", "Header2", "Header3", "Header4"],
    ["Value1", "Value2", 123, true],
    ["Row2Val1", null, 456, false]
  ]
}

Note: Cell values preserve their types (string, number, boolean). Empty cells may appear as null or be omitted from rows. Some cells with rich formatting may return structured objects instead of plain values.