Append Values

AppendValues appends values after the last row of data in a range.

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

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.
Insert Data Option	Optional	Specify how to insert data into the spreadsheet.
Response Value Render Option	Optional	Specify how to render values in the response.
Response Date Time Render Option	Optional	Specify how to render date and time in the response.
Include Values In Response	Optional	Whether to include values 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	—
tableRange	String	—
updates	Object	The response when updating a range of values in a spreadsheet.