> ## Documentation Index
> Fetch the complete documentation index at: https://veryfront.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets

> Read, write, and manage Google Sheets spreadsheets

## At a glance

* **Availability**: Enabled by default.
* **Auth**: OAuth 2.0.
* **Connection**: A user authorizes the connection in the provider's consent screen.
* **Scopes**: `https://www.googleapis.com/auth/spreadsheets`, `https://www.googleapis.com/auth/drive.readonly`, `https://www.googleapis.com/auth/drive.file`.

## Credentials

Set these per environment. See [Connect an integration](/cloud/integrations).

With a managed OAuth app, Connect works without these variables; set them to use your own OAuth app instead.

| Variable               | Required | Description                                                                           |
| ---------------------- | -------- | ------------------------------------------------------------------------------------- |
| `GOOGLE_CLIENT_ID`     | Yes      | Google OAuth Client ID [Docs](https://console.cloud.google.com/apis/credentials).     |
| `GOOGLE_CLIENT_SECRET` | Yes      | Google OAuth Client Secret [Docs](https://console.cloud.google.com/apis/credentials). |

## Tools

| Tool                | Access | Description                                                                      |
| ------------------- | ------ | -------------------------------------------------------------------------------- |
| List Spreadsheets   | Read   | List recent Google Sheets spreadsheets from Drive                                |
| Get Spreadsheet     | Read   | Get spreadsheet metadata including sheet names and properties                    |
| Read Range          | Read   | Read cell data from a spreadsheet range                                          |
| Write Range         | Write  | Write data to a spreadsheet range                                                |
| Create Spreadsheet  | Write  | Create a new spreadsheet with optional initial data                              |
| Append Rows         | Write  | Append rows to a spreadsheet range                                               |
| Clear Range         | Write  | Clear values from a spreadsheet range                                            |
| Batch Update        | Write  | Run raw Google Sheets batchUpdate requests for formatting and structural changes |
| Add Sheet           | Write  | Add a new sheet/tab to a spreadsheet                                             |
| Delete Sheet        | Write  | Delete a sheet/tab from a spreadsheet by sheet ID                                |
| Rename Sheet        | Write  | Rename a sheet/tab by sheet ID                                                   |
| Delete Spreadsheet  | Write  | Move an app-accessible spreadsheet file to trash                                 |
| Find and Replace    | Write  | Find and replace text in a spreadsheet or sheet                                  |
| Copy Sheet          | Write  | Copy a sheet/tab to another spreadsheet                                          |
| Create Chart        | Write  | Create an embedded chart using a Sheets API chart specification                  |
| Set Data Validation | Write  | Set data validation rules on a sheet range                                       |

## Example prompts

* Read and analyze data from a Google Sheets spreadsheet. Provide insights, trends, and statistics.
* Create a new Google Sheets spreadsheet with formatted data, headers, and calculations.
* Update a tracking spreadsheet with new data. Add rows, update values, or calculate totals.