View as Markdown
Google Docs icon

Google Docs ACTION

Format Table Cell

Set the background, borders, padding, or vertical alignment of table cells in a Google Doc. Identify the table with Find Table Text, Table Index, or leave both blank when the document has only one table. Styles every cell unless Row Index and Column Index name a starting cell. See the documentation
  • Action
  • Writes data
  • OAuth
  • SDK
  • MCP

IMPLEMENTATION

Call this tool

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

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-format-table-cell",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    google_docs: { authProvisionId: "apn_xxxxxxx" },
    documentId: "Document ID",
    find: "Find Table Text",
  },
})

console.log(result)

SCHEMA

Inputs

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

Format Table Cell 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
find Find Table Text string
Text appearing in a cell of the table to style. The action locates the table containing the first match. Only top-level tables are searched.
Optional
matchCase Match Case boolean
Case sensitive search (true) or not (false). Defaults to false
Optional
tableIndex Table Index integer
0-based position of the table in the document, in document order. An alternative to Find Table Text.
Optional
tableStartIndex Table Start Index integer
Character index the table starts at. An escape hatch for callers that already know it; prefer Find Table Text or Table Index.
Optional
tabId Tab ID string
For a multi-tab document, restrict the operation to this tab (e.g. t.0). Get tab IDs from List Tabs. Omit to search every tab for Find Text; an explicit Start Index / End Index without a Tab ID applies to the first tab only.
Optional
rowIndex Row Index integer
0-based row of the first cell to style. Omit (with Column Index) to style every cell in the table.
Optional
columnIndex Column Index integer
0-based column of the first cell to style. Omit (with Row Index) to style every cell in the table.
Optional
rowSpan Row Span integer
Number of rows to cover, starting at Row Index. Defaults to 1.
Optional
columnSpan Column Span integer
Number of columns to cover, starting at Column Index. Defaults to 1.
Optional
backgroundColor Background Color string
Cell background as a hex code, e.g. #EEEEEE.
Optional
borderColor Border Color string
Border color as a hex code, applied to all four sides. Must be set together with Border Width, since the API replaces a cell border as a whole. Borders cannot be transparent; set Border Width to 0 to hide one.
Optional
borderWidth Border Width integer
Border thickness in points, applied to all four sides (0-100). 0 hides the border. Must be set together with Border Color.
Optional
borderDashStyle Border Dash Style string
Dash pattern for the border, applied to all four sides. Defaults to SOLID when a border is set without one.
Optional
paddingTop Padding Top integer
Space between the cell's top edge and its content, in points (0-100).
Optional
paddingBottom Padding Bottom integer
Space between the cell's bottom edge and its content, in points (0-100).
Optional
paddingLeft Padding Left integer
Space between the cell's left edge and its content, in points (0-100).
Optional
paddingRight Padding Right integer
Space between the cell's right edge and its content, in points (0-100).
Optional
contentAlignment Content Alignment string
Vertical alignment of the content within the cells.
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-format-table-cell
Version
0.0.3
App
Google Docs
Authentication
OAuth
Read-only
No
Destructive
No
Open world
Yes