Create table

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

Example

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.

⌘I

Get started

Concepts

Reference

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output