Skip to content

POST /spreadsheets/{spreadsheetId}/values/{range}:append ​

Append values to a sheet

DetailValue
Operation IDdata.appendValues
MethodPOST
Path/spreadsheets/{spreadsheetId}/values/{range}:append
ConnectorGoogle Sheets

Parameters ​

NameLocationTypeRequired
spreadsheetIdpathstringYes
rangepathstringYes
valueInputOptionquerystringYes

Request Body ​

FieldType
valuesarray

Using this endpoint in a workflow ​

  1. Add an API Call node to your workflow.
  2. Pick your Google Sheets connection from the Connection dropdown.
  3. In the Operation dropdown, select data.appendValues.
  4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

Required fields are marked — fill them or the call will fail at runtime.

What it returns ​

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Google Sheets API reference.