Google Sheets

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

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.

Values

Read, write, append, clear, and transform A1 ranges.

Rows

Work with exact header-keyed records on sheets or native tables.

Spreadsheets and sheets

Create and manage spreadsheet and sheet metadata.

Native tables

Define typed columns, dropdowns, names, and table ranges.

⌘I

Get started

Concepts

Reference

Values

Rows

Spreadsheets and sheets

Native tables