---
title: "Updates values in a specified range of a Google Sheet."
method: POST
path: "/updateValues"
---

# Updates values in a specified range of a Google Sheet.

`POST /updateValues`

This function updates the values in a specified range of a Google Sheet with the provided data. It takes an input object containing the range and values to update, along with an optional parameter to specify how the input data should be interpreted. The function returns a promise that resolves to an object containing information about the update operation.

## Request body

- object
  - `body` object — Body of the updateValues sls call
    - `arguments` unknown[], required
      - unknown
    - `auth` object — Authentication object
      - `strategy` 'oauth2' — Authentication strategy
      - `variables` unknown[] — Variables for the authentication strategy
        - unknown
    - `packageName` string — @microfox/google-sheets

## Response `200`

Successful operation

- object
  - `spreadsheetId` string, required — The ID of the spreadsheet
  - `updatedRange` string — The range that was updated
  - `updatedRows` number — The number of rows updated
  - `updatedColumns` number — The number of columns updated
  - `updatedCells` number — The number of cells updated
  - `clearedRange` string — The range that was cleared

## Other responses

- `400` — Bad request
- `403` — Forbidden - Insufficient permissions
- `404` — Not Found - Sheet or range not found
- `500` — Internal server error

## Changes

- **2025-05-29** `470b95f73df9` — 2 info
  - added the non-success response with the status `403`
  - added the non-success response with the status `404`
- **2025-05-28** `77260ff78232` — 2 info
  - removed the non-success response with the status `403`
  - removed the non-success response with the status `404`

[Change history](https://skmtc.dev/microfox-ai/apis/google-sheets-sdk-api/changes/updateValues/post.md)

---

[API](https://skmtc.dev/microfox-ai/apis/google-sheets-sdk-api.md) · [All operations](https://skmtc.dev/microfox-ai/apis/google-sheets-sdk-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/microfox-ai/google-sheets-sdk-api/revisions/85db428f2808/schema)