create_pivot_table
Create a Google Sheets pivot table from a source range, specifying row and value columns, optional column grouping, and summary function.
Instructions
Create a native Google Sheets pivot table from a bounded source range.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| row_columns | Yes | ||
| show_totals | No | ||
| target_cell | Yes | ||
| source_range | Yes | ||
| value_columns | Yes | ||
| column_columns | No | ||
| spreadsheet_id | Yes | ||
| summarize_function | No | SUM |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||