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

# Google Sheets

> Read and write spreadsheet data from your agent

## Setup

<Steps>
  <Step title="Create OAuth credentials">
    Same as Google Calendar — create OAuth 2.0 credentials and enable the Google Sheets API.
  </Step>

  <Step title="Add credentials in Orova">
    Go to **Settings → Integrations → Google Sheets** and enter your Client ID, Client Secret, and Refresh Token.
  </Step>

  <Step title="Create tool and assign">
    **Tools → Create Tool** → select **Google Sheets** → assign to your agent.
  </Step>
</Steps>

## Available tools

| Tool                | Description                 |
| ------------------- | --------------------------- |
| `list_spreadsheets` | List available spreadsheets |
| `read_sheet`        | Read data from a sheet      |
| `write_sheet`       | Write data to a sheet       |
| `append_row`        | Append a row to a sheet     |