Update table - Automate.ax

updateTable patches common structural properties of a native table.

Example

import { automation, onHttpRequest } from "automate.ax"
import { updateTable } from "automate.ax/google-sheets"

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

  updateTable({
    spreadsheet: "spreadsheet-id",
    table: "OrdersTable",
    name: "CurrentOrders",
  })
})

Inputs

spreadsheet and existing table name or ID are required. Provide at least one of new name, a complete replacement columns array using Create table, or structured range with sheet and optional one-based inclusive row/column bounds. account selects the Google account.

Output

Returns refreshed { tableId, name, range, columns }. Replacing columns is a structural operation; align the column count with the target range and existing data.

⌘I