---
title: 'Google Sheets'
description: 'Read, write, and manage spreadsheet data via the Google Sheets API.'
---

# 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 — see the table below.

## Available Endpoints

| Endpoint | Summary |
|---|---|
| [GET /spreadsheets/{spreadsheetId}](./get_spreadsheets_spreadsheetid_data_getspreadsheet) | Get spreadsheet metadata |
| [GET /spreadsheets/{spreadsheetId}/values/{range}](./get_spreadsheets_spreadsheetid_values_range_data_getvalues) | Get cell values from a range |
| [PUT /spreadsheets/{spreadsheetId}/values/{range}](./put_spreadsheets_spreadsheetid_values_range_data_updatevalues) | Update cell values in a range |
| [POST /spreadsheets/{spreadsheetId}/values/{range}:append](./post_spreadsheets_spreadsheetid_values_range_append_data_appendvalues) | Append values to a sheet |
| [POST /spreadsheets/{spreadsheetId}/values:batchGet](./post_spreadsheets_spreadsheetid_values_batchget_data_batchgetvalues) | Get multiple ranges of values |

> Each endpoint has its own page with parameter details, an example
> `API Call` node configuration, and the response shape.