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

# Google Sheets

> Read and write cell ranges, header-keyed rows, sheets, and native tables from TypeScript.

Import Google Sheets actions from `automate.ax/google-sheets`. Spreadsheet
references accept an immutable spreadsheet ID or a standard Google Sheets URL.

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

export default automation("Append a lead", () => {
  onHttpRequest({ scope: "automation" })

  appendRows({
    spreadsheet: "spreadsheet-id",
    source: { sheet: "Leads" },
    rows: { Name: "Ada", Email: "ada@example.com" },
  })
})
```

Use value actions for A1 matrices, row actions for records keyed by exact
headers, and table actions for Google Sheets' native table feature. Actions
accept compatible signals. `account` defaults to the project's Google account
binding.

<CardGroup cols={2}>
  <Card title="Values" href="/reference/integrations/google-sheets/actions/read-values">
    Read, write, append, clear, and transform A1 ranges.
  </Card>

  <Card title="Rows" href="/reference/integrations/google-sheets/actions/list-rows">
    Work with exact header-keyed records on sheets or native tables.
  </Card>

  <Card title="Spreadsheets and sheets" href="/reference/integrations/google-sheets/actions/get-spreadsheet">
    Create and manage spreadsheet and sheet metadata.
  </Card>

  <Card title="Native tables" href="/reference/integrations/google-sheets/actions/create-table">
    Define typed columns, dropdowns, names, and table ranges.
  </Card>
</CardGroup>