Update Google Sheet Values with Xano

Google Sheets -> Update Values

Updates values in a specific range of a Google Sheet using the Sheets API.

Inputs

Name	Type	Required	Description
spreadsheet_id	text	Yes	The ID of the Google Spreadsheet.
range	text	Yes	The A1 notation of the range to update (e.g., 'Sheet1!A1:C10').
values	json	Yes	2D array of values to update in the sheet.
value_input_option	text	No	How the input data should be interpreted (`RAW` or `USER_ENTERED`). Default is `RAW`.
access_token	text	Yes	Google OAuth2 access token for authentication.

Function Stack

API Request
- Calls the Google Sheets API to update values in the specified range.
- Endpoint:
  PUT https://sheets.googleapis.com/v4/spreadsheets/{spreadsheet_id}/values/{range}?valueInputOption={value_input_option}
- Payload:
```
{
  "range": "Sheet1!A1:C10",
  "majorDimension": "ROWS",
  "values": [
    ["Name", "Role", "Email"],
    ["Alice", "Manager", "alice@example.com"],
    ["Bob", "Developer", "bob@example.com"]
  ]
}
```
- Authenticates using the provided access token.
Precondition
- Checks for a successful (status 200) response.
- Throws an error if the API response is not successful.
Extract Response Details
- Parses the API response for update details.

Response

Returns the full API response, including updated range, rows, columns, and cells.

Example Response

{
  "spreadsheetId": "1A2B3C4D5E",
  "updatedRange": "Sheet1!A1:C3",
  "updatedRows": 3,
  "updatedColumns": 3,
  "updatedCells": 9
}

Example Usage

Request

{
  "spreadsheet_id": "1A2B3C4D5E",
  "range": "Sheet1!A1:C3",
  "values": [
    ["Name", "Role", "Email"],
    ["Alice", "Manager", "alice@example.com"],
    ["Bob", "Developer", "bob@example.com"]
  ],
  "value_input_option": "RAW",
  "access_token": "ya29.a0AfH6SMB..."
}

Response

{
  "spreadsheetId": "1A2B3C4D5E",
  "updatedRange": "Sheet1!A1:C3",
  "updatedRows": 3,
  "updatedColumns": 3,
  "updatedCells": 9
}

Notes

The range must match the shape of the provided values.
The access token must have edit access to the spreadsheet.

References

Troubleshooting

PERMISSION_DENIED: Check your access token and spreadsheet permissions.
INVALID_ARGUMENT: Ensure all required fields are provided and valid.
NOT_FOUND: Verify the spreadsheet ID and range.
For more help, refer to the Google Sheets API documentation.

Version notes

2025-09-18 17:35:00

Current

2025-09-18T22:37:42.000+00:00

Action summary