Google Sheets

Read, write, and manage spreadsheet data via the Google Sheets API.

Detail	Value
Category	Productivity
Base URL	https://sheets.googleapis.com/v4
Authentication	OAuth2 Client Credentials
Endpoints	5
Connector key	google_sheets

Using Google Sheets in a workflow

1. Go to Connections and click New Connection.
2. Pick Google Sheets from the marketplace.
3. Enter your credentials (see Authentication above for what's expected).
4. In a workflow, drop an API Call node and select this connection.
5. Pick the operation you need from the Operation dropdown — the full list is below.

Available endpoints

Endpoint	Summary
GET /spreadsheets/{spreadsheetId}	Get spreadsheet metadata
GET /spreadsheets/{spreadsheetId}/values/{range}	Get cell values from a range
PUT /spreadsheets/{spreadsheetId}/values/{range}	Update cell values in a range
POST /spreadsheets/{spreadsheetId}/values/{range}:append	Append values to a sheet
POST /spreadsheets/{spreadsheetId}/values:batchGet	Get multiple ranges of values

Each endpoint is documented in full below. Use the outline on the right to jump to one.

GET /spreadsheets/{spreadsheetId}

Get spreadsheet metadata

Detail	Value
Operation ID	data.getSpreadsheet
Method	GET
Path	/spreadsheets/{spreadsheetId}

Parameters

Name	Location	Type	Required
spreadsheetId	path	string	Yes

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

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

Get cell values from a range

Detail	Value
Operation ID	data.getValues
Method	GET
Path	/spreadsheets/{spreadsheetId}/values/{range}

Parameters

Name	Location	Type	Required
spreadsheetId	path	string	Yes
range	path	string	Yes

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.

PUT /spreadsheets/{spreadsheetId}/values/{range}

Update cell values in a range

Detail	Value
Operation ID	data.updateValues
Method	PUT
Path	/spreadsheets/{spreadsheetId}/values/{range}

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

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

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

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

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.

POST /spreadsheets/{spreadsheetId}/values:batchGet

Get multiple ranges of values

Detail	Value
Operation ID	data.batchGetValues
Method	POST
Path	/spreadsheets/{spreadsheetId}/values:batchGet

Parameters

Name	Location	Type	Required
spreadsheetId	path	string	Yes
ranges	query	string	Yes

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