Google Sheets ACTION

Add Rows

Append one or more rows to a Google Sheets worksheet. Pass rows as a JSON array. Preferred format: array of objects with column header keys (e.g., [{"Name": "Alice", "Email": "alice@example.com"}]). Use Get Spreadsheet Info first to discover the exact column header names — keys must match headers exactly (case-sensitive). Alternatively, pass rows as arrays of positional values matching column order. New rows are appended after the last row with data.

Action
Writes data
OAuth
SDK
MCP

Start building

IMPLEMENTATION

Call this tool

Connect a user's Google Sheets account once, then configure and run Add Rows 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_sheets-add-rows",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    google_sheets: { authProvisionId: "apn_xxxxxxx" },
    spreadsheetId: "Spreadsheet ID",
    sheetName: "Worksheet Name",
  },
})

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_sheets-add-rows",
    "configured_props": {
      "google_sheets": { "authProvisionId": "apn_xxxxxxx" },
      "spreadsheetId": "Spreadsheet ID",
      "sheetName": "Worksheet Name"
    }
  }'

// 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_sheets",
      },
    },
  },
)

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_sheets-add-rows",
  arguments: {
    spreadsheetId: "Spreadsheet ID",
    sheetName: "Worksheet Name",
  },
})

SCHEMA

Inputs

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

Add Rows inputs
Property	Type	Description
`spreadsheetId` Spreadsheet ID	`string`	The spreadsheet ID from the Google Sheets URL. Required
`sheetName` Worksheet Name	`string`	The worksheet (tab) name. Use Get Spreadsheet Info to discover worksheet names. Required
`rows` Rows	`string`	JSON array of rows to append. Each row can be an object with column header keys or an array of positional values. Example (objects): `[{"Name": "Alice", "Email": "alice@example.com"}, {"Name": "Bob", "Email": "bob@example.com"}]`. Example (arrays): `[["Alice", "alice@example.com"], ["Bob", "bob@example.com"]]`. Required
`hasHeaders` Has Headers	`boolean`	Whether row 1 contains column headers. Required when passing rows as objects. Default: `true`. 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_sheets-add-rows
Version: 0.0.4
App: Google Sheets
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