View as Markdown
Google Sheets icon

Google Sheets ACTION

Update Rows

Update specific rows in a Google Sheets worksheet. Pass an array of updates, each with a row number and values. Example: [{"row": 3, "values": {"Status": "Complete", "Score": 95}}]. Use Find Rows or Read Rows to discover row numbers first. Use Get Spreadsheet Info to discover column header names. Only specified columns are updated when using object values — unspecified columns are left unchanged.
  • Action
  • Writes data
  • OAuth
  • SDK
  • MCP

IMPLEMENTATION

Call this tool

Connect a user's Google Sheets account once, then configure and run Update Rows 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_sheets-update-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)

SCHEMA

Inputs

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

Update 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
updates Updates string
JSON array of update objects. Each object has row (1-indexed row number) and values (object with header keys or array of positional values). Example: [{"row": 3, "values": {"Status": "Complete"}}].
Required
hasHeaders Has Headers boolean
Whether row 1 contains column headers. 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-update-rows
Version
1.0.0
App
Google Sheets
Authentication
OAuth
Read-only
No
Destructive
No
Open world
Yes