Sheets Pivot Create for Lark CLI | Aident Loadout

Skills Apps Actions Pricing Docs

AppsLark CLISheets Pivot Create

Lark CLI

Sheets Pivot Create

Create a pivot object via the manage_*_object tool.

Write ActionRisk level 3 of 5API key connectionFree Action

Use Sheets Pivot Create

Owner App

Required inputs

urlstring

Product

Aident Loadout Aident Playbook Editor Open-CUAK

About

Apps Skills Docs Blog Pricing Downloads Privacy Policy Terms of Service

Alternatives

vs Composio vs Zapier

llms.txtGet an AI summary of Aident Loadout

© Aident Labs, 2024-2026

Spreadsheet URL (XOR with --spreadsheet-token)

rangestring

Pivot table top-left placement (single A1 value, e.g. F1; create only), maps to `properties.range`; placed at the top-left of the target sub-sheet (a newly created one by default) when omitted. It and `--target-position` both express placement but map to different wire fields —…

sourceRequiredstring

Pivot table source range (A1 notation; format 'SheetName'!StartCell:EndCell, e.g. `'Sheet1'!A1:D100`)

propertiesRequiredobject

JSON: {"rows":[...],"columns":[...],"values":[...],"filters":[...],"show_row_grand_total":true,"show_col_grand_total":true} (data source goes through --source; do not put source here) (supports @file, - reads stdin (one flag per call; use @file for others))

targetSheetIdstring

Reference_id of the target sub-sheet where the pivot table will be placed (mutually exclusive with --target-sheet-name; takes priority when both given; when both omitted, a new sub-sheet is auto-created to host the pivot — recommended). Distinct from the data-source sheet, which…

targetPositionstring

Top-left cell within the target sub-sheet (A1 notation, e.g. A1); maps to the top-level `target_position`, default `A1` (not sent when the value is A1). It and `--range` both express placement but map to different wire fields — avoid passing conflicting values for both. (default…

targetSheetNamestring

Name of the target sub-sheet where the pivot table will be placed (mutually exclusive with --target-sheet-id; when both omitted, a new sub-sheet is auto-created to host the pivot — recommended). Distinct from the data-source sheet, which lives inside --source as a 'Sheet'-prefix…

spreadsheetTokenstring

Spreadsheet token (XOR with --url)

Observable output

No reviewed structured output summary is available.

Setup and approval

API key connection. Risk level 3 of 5.

Pricing and limits

Free Action

Unified payment: Not currently supported

Skills that use this Action

No published Skills explicitly reference this Action yet.

Official source

Provider source