Update Values

UpdateValues writes values to a range.

It calls PUT https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}.

The activity has 4 tabs: Configuration, Auth, Input, and Output.

Configuration

Field	Required	Description
Name	Optional	Name of the step, should be unique within this workflow.
Description	Optional	Describe the purpose or function of this step.
Spreadsheet Id	Optional	Enter the ID of the spreadsheet to access.
Range	Optional	Specify the range of cells to access in the spreadsheet.
Value Input Option	Optional	Specify how the input data should be interpreted.
Include Values In Response	Optional	Indicate if the response should include the values of the cells.
Response Value Render Option	Optional	Specify how the response values should be rendered.
Response Date Time Render Option	Optional	Specify how date and time values should be rendered in the response.

Auth

Field	Required	Description
Auth Type	Optional	The authentication method for the request. OAuth 2 is the only option, and the default.
Auth Resource	Optional	OAuth resource containing credentials.

Input

This activity is built on the REST Client, so the Input tab is the generic HTTP request rather than a Google Sheets-shaped payload.

Field	Required	Data Type	Description
Target	Required	Object	The HTTP request.

Output

The activity returns an httpResponse object.

Field	Data Type	Description
status.code	Integer	Numeric HTTP status code.
status.message	String	Short message associated with the HTTP status.
headers	Object	HTTP response headers.
body	Object	Parsed body of the response.

The response body carries:

Field	Data Type	Description
spreadsheetId	String	—
updatedRange	String	—
updatedRows	Integer	—
updatedColumns	Integer	—
updatedCells	Integer	—
updatedData	Object	Data within a range of the spreadsheet.