---
title: 'PUT /spreadsheets/{spreadsheetId}/values/{range}'
description: 'Update cell values in a range'
---

# PUT /spreadsheets/{spreadsheetId}/values/{range}

Update cell values in a range

| Detail | Value |
|---|---|
| Operation ID | `data.updateValues` |
| Method | `PUT` |
| Path | `/spreadsheets/{spreadsheetId}/values/{range}` |
| Connector | [Google Sheets](./) |

## Parameters

| Name | Location | Type | Required |
|---|---|---|---|
| `spreadsheetId` | path | string | **Yes** |
| `range` | path | string | **Yes** |
| `valueInputOption` | query | string | **Yes** |

## Request Body

| Field | Type |
|---|---|
| `values` | array |


## Using this endpoint in a workflow

1. Add an **API Call** node to your workflow.
2. Pick your Google Sheets connection from the Connection dropdown.
3. In the Operation dropdown, select `data.updateValues`.
4. Fill in the parameter fields that appear. Use `{{...}}` to reference upstream values.

**Required fields are marked — fill them or the call will fail at runtime.**

## What it returns

The `API Call` node writes the response to the workflow context:

```
{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}
```

Reference response fields downstream as <code v-pre>{{nodeId.data.path}}</code>. The exact response shape is documented on the upstream Google Sheets API reference.