Google Workspace: Actions/write Table

Write rows and columns to a new tab in an existing Google Sheet, including from a running Play.

Tool ID: google_workspace_write_table

Run this action

Use the TypeScript SDK for one call. Use ctx.tools.execute(...) inside a Play for durable calls, scheduled calls, or CSV processing.

import { Deepline } from 'deepline';

const deepline = await Deepline.connect();
const result = await deepline.tools.execute(
  'google_workspace_write_table',
  {
    "spreadsheet_id": "spreadsheet_123",
    "tab_name": "Example",
    "columns": [
      "example"
    ],
    "rows": [
      [
        "example"
      ]
    ],
    "operation_key": "examplex"
  },
);

console.log(result.toolResponse.raw);

CLI

deepline tools execute google_workspace_write_table --input '{
  "spreadsheet_id": "spreadsheet_123",
  "tab_name": "Example",
  "columns": [
    "example"
  ],
  "rows": [
    [
      "example"
    ]
  ],
  "operation_key": "examplex"
}' --json

Example response

The SDK returns this shape at result.toolResponse.raw. The example values illustrate the response.

{
  "spreadsheet_id": "spreadsheet_123",
  "spreadsheet_url": "https://example.com",
  "tab_id": 123,
  "tab_name": "Example",
  "row_count": 123,
  "column_count": 123,
  "operation_key": "example",
  "replayed": true
}

Use deepline describe google_workspace_write_table --json for the latest machine-readable contract.

Input reference

Write ordered columns and rows to a new tab in an existing workspace-owned spreadsheet, including during a running Play. Up to 10,000 data rows, 200 columns, 250,000 cells including headers, and an 8 MiB Google request. Strings are literal. Tab creation, values, and retry receipt commit atomically. Reuse an operation key only for the identical table. retries never overwrite collaborator edits.

Name	Type	Required	Default	Details
`payload.spreadsheet_id`	`string`	Yes	—	Minimum length: 1. Pattern: `\S`.
`payload.tab_name`	`string`	Yes	—	Minimum length: 1. Maximum length: 100. Pattern: `\S`.
`payload.columns`	`array`	Yes	—	Minimum items: 1. Maximum items: 200. Items must be unique.
`payload.rows`	`array`	Yes	—	Maximum items: 10000.
`payload.operation_key`	`string`	Yes	—	Minimum length: 8. Pattern: `\S`.

Output reference

Name	Type	Required	Default	Details
`result.spreadsheet_id`	`string`	Yes	—	—
`result.spreadsheet_url`	`string`	Yes	—	—
`result.tab_id`	`integer`	Yes	—	—
`result.tab_name`	`string`	Yes	—	—
`result.row_count`	`integer`	Yes	—	—
`result.column_count`	`integer`	Yes	—	—
`result.operation_key`	`string`	Yes	—	—
`result.replayed`	`boolean`	Yes	—	—

Deepline cost

Pricing model: fixed (per call).
Estimated Deepline credits: 0 per pricing unit.
Provider-native pricing may still exist outside Deepline credit billing.

​Run this action

​CLI

​Example response

​Input reference

​Output reference

​Deepline cost

​Related documentation

Run this action

CLI

Example response

Input reference

Output reference

Deepline cost

Related documentation