Google Sheets CustomInstall

Summary

Update values in a specified range of a Google Sheets spreadsheet using JSON-formatted data.

Inputs

• Authentication (required) — Choose between automatic token refresh via a refresh token or manual bearer token authentication.
• Custom Refresh Token — Optionally override the refresh token from credentials when using refresh token authentication.
• Spreadsheet ID (required) — The ID of the target spreadsheet to update.
• Range (required) — The starting cell address in A1 notation indicating where the update begins (e.g., 'Sheet1!A1').
• Data (required) — A JSON array of arrays representing the new values to set in the sheet starting at the specified range. Example: [["Value1", "Value2"], ["Value3", "Value4"]].

Output shape

a single item containing the API response object for the update operation

The output includes the full response from the Google Sheets API v4 update method, showing the status and details of the updated values.

Examples

Example 1: Update a block of cells in a Google Sheet

Provide the spreadsheet ID, specify the starting cell range (e.g., 'Sheet1!A1'), and input the new data as a JSON array of arrays. Choose authentication method and provide credentials accordingly.