> ## Documentation Index
> Fetch the complete documentation index at: https://docs.automate.ax/llms.txt
> Use this file to discover all available pages before exploring further.

> ## Agent Instructions
> Automate.ax automations are TypeScript programs.
> Use Bun for installation and command examples.
> Use Automate.ax for the product name and automate.ax for the package, CLI, and domain.
> Treat documented public APIs as current; do not invent transitional or deprecated names.

# Update sheet

> Update a Google sheet's title, position, visibility, direction, or grid size.

`updateSheet` patches common sheet properties and returns refreshed metadata.

## Example

```ts theme={null}
import { automation, onHttpRequest } from "automate.ax"
import { updateSheet } from "automate.ax/google-sheets"

export default automation("Freeze the header", () => {
  onHttpRequest({ scope: "automation" })

  updateSheet({
    spreadsheet: "spreadsheet-id",
    sheet: "Orders",
    frozenRowCount: 1,
  })
})
```

## Inputs

`spreadsheet` and `sheet` (exact title or numeric sheet ID) are required.
Provide at least one property from [Create sheet](/reference/integrations/google-sheets/actions/create-sheet#inputs): `title`, counts, zero-based `index`, `hidden`, or `rightToLeft`. `account` selects the Google account.

## Output

Returns current `Sheet` metadata. Shrinking row or column allocation can discard
cells outside the new grid; Google also rejects duplicate titles and invalid
frozen counts.