Google Docs ACTION

Write Table

Create a table and fill it with data in a single step. Provide the entire table (all rows and columns, including a header row) at once. Use this instead of inserting cells or text one at a time. The action places every value in the correct cell for you. Pass Table Data as a JSON array of arrays, one inner array per row, header row first when Has Header Row is set, e.g. [["Name","Role"],["Ada","Engineer"]]. Use Find Document to resolve a document's name to its ID, or Insert Table instead if you only need an empty grid to fill in later. In a multi-tab document, set Tab ID to choose which tab receives the table — without it the table goes into the document's first tab; use List Tabs to get the IDs. Note: a table written this way is always static — the Google Docs API does not create or preserve a live link to a Google Sheet, even when this replaces a Sheets-linked table. See the documentation

Action
Writes data
OAuth
SDK
MCP

Start building

IMPLEMENTATION

Call this tool

Connect a user's Google Docs account once, then configure and run Write Table from your backend or agent.

Pipedream Connect

import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "google_docs-write-table",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    google_docs: { authProvisionId: "apn_xxxxxxx" },
    documentId: "Document ID",
    rows: "Table Data",
  },
})

console.log(result)

curl -X POST https://api.pipedream.com/v1/connect/{project_id}/actions/run \
  -H "Content-Type: application/json" \
  -H "X-PD-Environment: production" \
  -H "Authorization: Bearer {access_token}" \
  -d '{
    "external_user_id": "{external_user_id}",
    "id": "google_docs-write-table",
    "configured_props": {
      "google_docs": { "authProvisionId": "apn_xxxxxxx" },
      "documentId": "Document ID",
      "rows": "Table Data"
    }
  }'

// accessToken: mint a short-lived token with the Connect SDK — see the MCP guide
const transport = new StreamableHTTPClientTransport(
  new URL("https://remote.mcp.pipedream.net/v3"),
  {
    requestInit: {
      headers: {
        Authorization: `Bearer ${accessToken}`,
        "x-pd-project-id": "{project_id}",
        "x-pd-environment": "production",
        "x-pd-external-user-id": "{external_user_id}", // any stable ID for this user in your system
        "x-pd-app-slug": "google_docs",
      },
    },
  },
)

const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)

const { tools } = await mcp.listTools()

// listTools() hands your model this tool's input schema, so it can
// fill the arguments itself:
const result = await mcp.callTool({
  name: "google_docs-write-table",
  arguments: {
    documentId: "Document ID",
    rows: "Table Data",
  },
})

SCHEMA

Inputs

Pipedream supplies the connected account. Your application provides the operation-specific values below. Dynamic inputs are resolved against that user's account.

Write Table inputs
Property	Type	Description
`documentId` Document ID	`string`	The ID of the Google Doc. This is the long string in the document's URL: `https://docs.google.com/document/d/{DOCUMENT_ID}/edit`. Use Find Document to resolve a document's name to its ID. Required
`rows` Table Data	`string`	JSON array of rows, one inner array per row, each holding that row's cell values in column order. Header row first if Has Header Row is set. Example: `[["Name","Role"],["Ada","Engineer"],["Grace","Admiral"]]`. Rows may have different lengths; the table is sized to the widest row and shorter rows leave their remaining cells blank. Required
`hasHeaderRow` Has Header Row	`boolean`	When `true`, the first row in Table Data is treated as a header and its text is bolded. Defaults to `false`. Optional
`position` Position	`string`	Where to insert the content: `end` to append to the end of the document (default), `beginning` to insert at the start, or a numeric character index (e.g., `1`) for a specific location. Optional
`tabId` Tab ID	`string`	For a multi-tab document, the ID of the tab to write into (e.g. `t.0`). Get tab IDs from List Tabs, or use the ID returned by Create Tab. Omit to write into the document's first tab — the Google Docs API sends every untargeted edit there, so pass this whenever the document has more than one tab. Optional

REFERENCE

Tool details

Behavior hints are published with the component in the Pipedream registry and surface as MCP tool annotations, so an agent can reason about a tool before it calls it.

Registry key: google_docs-write-table
Version: 0.1.0
App: Google Docs
Authentication: OAuth
Read-only: No
Destructive: No
Open world: Yes
Source: View on GitHub ↗

Call this tool #

Inputs #

Tool details #

Call this tool

Inputs

Tool details