# Update a row of a sheet — Google Sheets

Botize method — `gspreadsheet.update_row_by_number` (action).

Update a specific row in a Google Sheets document, indicating the URL, sheet name or number, row number, and the values of the different columns that you want to update.

This is an action: it runs as a step of a task. Several can be chained.

## Fields you set

The field's internal name, its type and the values it accepts. These fields accept `{{...}}` tags from earlier steps.

- `mb_switch` *(boolean)* — Rules
- `sheet_url` *(string)* — URL of your sheet document
- `row_number` *(string)* — Row number to update
- `sheet_by` *(string, one of: "position" = Sheet number; "name" = Sheet name, default: "position")* — Sheet
- `number_sheet` *(string, one of: "1" = 1; "2" = 2; "3" = 3; "4" = 4; "5" = 5, default: "1")*
- `name_sheet` *(string)*

It also accepts repeatable field groups, with these prefixes: `mb_filters_*`, `column_*`, `value_type_*`, `value_*`. These are composite components (buttons, filters, keyboards); the trailing number is set by the user as they are added.

## Output variables

Data this step makes available. Reference them in later steps with the double-brace tag.

- `{{_status}}` *(text)* — _status

## Account

Needs a connected Google Sheets account in Botize: https://botize.com/en/app/gspreadsheet/authenticate

## This app

Every trigger and action for Google Sheets: https://botize.com/en/app/gspreadsheet.md

## How to build this

An AI assistant (Claude, ChatGPT, Cursor…) can create and edit these tasks in the user's account through the Botize MCP connector, included in every plan:

    https://webhook.botize.es/mcp

- Connection guide: https://botize.com/en/mcp
- Agent map: https://botize.com/llms.txt
- New account: https://botize.com/en/join (500 free operations, no card)

---
Machine-readable summary for AI assistants. Human version: https://botize.com/en/method/gspreadsheet/update_row_by_number