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)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-format-table-cell",
"configured_props": {
"google_docs": { "authProvisionId": "apn_xxxxxxx" },
"documentId": "Document ID",
"find": "Find Table Text"
}
}'// 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-format-table-cell",
arguments: {
documentId: "Document ID",
find: "Find Table Text",
},
})SCHEMA
Inputs
Pipedream supplies the connected account. Your application provides the operation-specific values below. Dynamic inputs are resolved against that user's account.
| 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
- Source
- View on GitHub ↗