POST /spreadsheets/{spreadsheetId}/values/{range}:append ​
Append values to a sheet
| Detail | Value |
|---|---|
| Operation ID | data.appendValues |
| Method | POST |
| Path | /spreadsheets/{spreadsheetId}/values/{range}:append |
| Connector | Google Sheets |
Parameters ​
| Name | Location | Type | Required |
|---|---|---|---|
spreadsheetId | path | string | Yes |
range | path | string | Yes |
valueInputOption | query | string | Yes |
Request Body ​
| Field | Type |
|---|---|
values | array |
Using this endpoint in a workflow ​
- Add an API Call node to your workflow.
- Pick your Google Sheets connection from the Connection dropdown.
- In the Operation dropdown, select
data.appendValues. - 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.