Skip to content

GET /spreadsheets/{spreadsheetId}/values/{range} ​

Get cell values from a range

DetailValue
Operation IDdata.getValues
MethodGET
Path/spreadsheets/{spreadsheetId}/values/{range}
ConnectorGoogle Sheets

Parameters ​

NameLocationTypeRequired
spreadsheetIdpathstringYes
rangepathstringYes

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.getValues.
  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.