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

# Google Sheets

> Read, write, and update spreadsheet data

Connect your Google account to let selected agents read and write cells, create spreadsheets, and work with the Sheets
you approve.

***

## What you unlock

<CardGroup cols={2}>
  <Card title="Spreadsheet data access" icon="table-cells">
    Read, write, and update cell values across any spreadsheet — your agent can pull data or push changes on demand.
  </Card>

  <Card title="Sheet management" icon="table-columns">
    Create new spreadsheets and sheets, add or remove rows and columns, and manage sheet properties.
  </Card>

  <Card title="SQL queries and formulas" icon="database">
    Run SQL queries against your spreadsheet data and aggregate column values without writing formulas by hand.
  </Card>

  <Card title="15+ agent tools" icon="wrench">
    Give your AI agent full read/write access to spreadsheets, values, formatting, charts, and data validation.
  </Card>
</CardGroup>

***

## Connect Google Sheets

<Steps>
  <Step title="Open Settings → Integrations">
    In any workspace go to **Settings → Integrations** and select **Google Sheets**.
  </Step>

  <Step title="Authorize with Google">
    Click **Connect** — you'll be redirected to Google's OAuth consent screen. Sign in with your Google account and
    grant spreadsheet access.
  </Step>

  <Step title="Start using Google Sheets in agents">
    Open the agent and enable only the Google Sheets actions it needs. Access is limited by the connected Google
    account.
  </Step>
</Steps>

***

## Agent tools

Add Google Sheets tools to agents that need them. Their access is limited by the connected Google account and selected
tools.

### Spreadsheets

| Tool                 | Description                                         |
| -------------------- | --------------------------------------------------- |
| Create spreadsheet   | Create a new Google Sheets spreadsheet              |
| Search spreadsheets  | Find spreadsheets by name or keyword                |
| Get spreadsheet info | Retrieve metadata and sheet names for a spreadsheet |

### Values

| Tool          | Description                                          |
| ------------- | ---------------------------------------------------- |
| Get values    | Read cell values from a specified range              |
| Update values | Write values to a specified range                    |
| Append values | Append rows of data to the end of a sheet            |
| Batch get     | Read values from multiple ranges in a single request |
| Batch update  | Write values to multiple ranges in a single request  |
| Clear values  | Clear cell contents in a specified range             |

### Rows and columns

| Tool             | Description                                     |
| ---------------- | ----------------------------------------------- |
| Lookup row       | Find a row by matching a column value           |
| Create row       | Insert a new row with specified values          |
| Insert dimension | Add new rows or columns at a specified position |
| Delete dimension | Remove rows or columns from a sheet             |

### Data and formatting

| Tool             | Description                                      |
| ---------------- | ------------------------------------------------ |
| Execute SQL      | Run a SQL query against spreadsheet data         |
| Find and replace | Search for and replace text across cells         |
| Format cell      | Apply formatting (bold, color, borders) to cells |
| Create chart     | Generate a chart from spreadsheet data           |

***

## Triggers

<Note>
  Triggers are not yet available for Google Sheets. Tools are fully supported — connect and start using them in any
  agent.
</Note>

***

## Example use cases

<AccordionGroup>
  <Accordion title="Pull a weekly metrics report">
    Ask your agent to read the latest row from your KPI spreadsheet, summarize the numbers, and post a formatted digest
    to your team channel — every Monday morning.
  </Accordion>

  <Accordion title="Log data from chat into a spreadsheet">
    When someone shares feedback or a data point in chat, tell your agent to append it as a new row in a tracking
    spreadsheet — complete with timestamp and source.
  </Accordion>

  <Accordion title="Query spreadsheet data with SQL">
    Ask your agent to run a SQL query against your spreadsheet to find all records matching specific criteria, then
    summarize the results in chat without opening the sheet.
  </Accordion>
</AccordionGroup>

***

## Troubleshooting

<AccordionGroup>
  <Accordion title="OAuth consent screen doesn't appear">
    Make sure pop-ups are not blocked in your browser. If the Google sign-in page doesn't open, try again with pop-ups
    allowed or use a different browser.
  </Accordion>

  <Accordion title="Agent can't find my spreadsheet">
    Search uses the name of the spreadsheet. Make sure the file is accessible to the authenticated Google account —
    check sharing settings in Google Drive if needed.
  </Accordion>

  <Accordion title="Write operations fail with a permission error">
    Confirm that the authenticated account has edit access to the spreadsheet. View-only access allows reads but blocks
    writes.
  </Accordion>

  <Accordion title="Authorization expired">
    Google OAuth tokens can expire. Go to **Settings → Integrations → Google Sheets**, disconnect, and reconnect to
    refresh your authorization.
  </Accordion>
</AccordionGroup>

***

<Card title="Back to Integrations" icon="plug" href="/integrations/overview">
  View all available integrations
</Card>