Format a Google Sheet
format_sheetBold headers, freeze top rows, and auto-size columns to make exported spreadsheets readable. Apply these formatting fixes post-export so nothing gets cut off or scrolled away.
Instructions
Make an exported sheet readable: bold the header row, FREEZE it so it stays visible while scrolling, and auto-size the columns so nothing is cut off. Worth calling right after create_sheet — a raw export with unsized columns and a header that scrolls away is the difference between a spreadsheet someone reads and one they close. Changes no cell VALUE, so it is never gated. The defaults do all three on the first tab; pass tab to pick another, freezeRows:0 to skip freezing, boldHeader:false or autoResize:false to skip those.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tab | No | tab title or numeric sheetId (default: the first tab) | |
| sheetUrl | No | ||
| autoResize | No | ||
| boldHeader | No | ||
| freezeRows | No | how many top rows to freeze (default 1, 0 = none) | |
| spreadsheetId | No |