build_table
Write a formatted table to Google Sheets at any cell, setting headers, banding, and column number formats in one action.
Instructions
Write a titled table and format it in one shot.
anchor is where the top-left header goes: Sheet1!A1, a bare cell
(first sheet), or a sheet name (its A1). Applies a style preset
(clean/financial/report-header/input) to the header, optionally freezes
the header row, adds banding, auto-fits columns, and applies per-column
number_formats ({"Revenue": "currency"}). Set preview=True to
get the planned ranges/requests without changing anything.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| style | No | clean | |
| anchor | Yes | ||
| autofit | No | ||
| banding | No | ||
| headers | Yes | ||
| preview | No | ||
| spreadsheet | Yes | ||
| freeze_header | No | ||
| number_formats | No |