Google Sheets ​
Read, write, and manage spreadsheet data via the Google Sheets API.
| Detail | Value |
|---|---|
| Category | Data & Productivity |
| Base URL | https://sheets.googleapis.com/v4 |
| Authentication | OAuth2 Client Credentials |
| Endpoints | 5 |
| Connector key | google_sheets |
Using Google Sheets in a workflow ​
- Go to Connections and click New Connection.
- Pick Google Sheets from the marketplace.
- Enter your credentials (see Authentication above for what's expected).
- In a workflow, drop an API Call node and select this connection.
- Pick the operation you need from the Operation dropdown — see the table 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 has its own page with parameter details, an example
API Callnode configuration, and the response shape.