> ## 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.

# Create table

> Create a native Google Sheets table with typed columns and dropdowns.

`createTable` adds Sheets' native table structure to an existing grid range.

## Example

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

export default automation("Create an order table", () => {
  onHttpRequest({ scope: "automation" })

  createTable({
    spreadsheet: "spreadsheet-id",
    sheet: "Orders",
    name: "OrdersTable",
    columns: [
      { name: "Order ID", type: "text" },
      { name: "Status", type: "dropdown", options: ["Open", "Closed"] },
      { name: "Total", type: "currency" },
    ],
    rowCount: 100,
  })
})
```

## Inputs

`spreadsheet`, `sheet`, unique `name`, and a non-empty `columns` array are
required. Column `type` is `unspecified`, `number`, `currency`, `percent`,
`date`, `time`, `dateTime`, `text`, `boolean`, `dropdown`, `file`, `person`,
`finance`, `place`, or `rating`; only dropdown columns accept and require
`options`. `startRow` and `startColumn` default to `1`. `rowCount` includes the
header, defaults to `2`, and must be at least 2. `account` selects the account.

## Output

Returns `{ tableId, name, range, columns }`. The range is zero-based and
end-exclusive. Columns include zero-based `index`, `name`, normalized `type`,
and dropdown `options`.