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

# Google Sheets

The **Google Sheets** connector integrates Tess with Google Sheets. Once connected, the AI can consult spreadsheet data, help structure reports, and support operational updates inside chats and agents.

Google Sheets is part of the Tess [Connectors](/en/connectors) ecosystem and uses **OAuth** authentication for Apps connectors.

## Prerequisites

<Info>
  * A Google account with access to the spreadsheets you need.
  * Permission to authorize Google Sheets OAuth scopes.
</Info>

## How to connect

<Tip>
  On some Apps connectors, the OAuth consent screen may show a third-party connection bridge name rather than Tess. That is normal—review the requested permissions and continue if they match what you expect.
</Tip>

<Steps>
  <Step title="Open the Connectors panel">
    In chat, click the **+** next to the message box and select **Connectors**. You can also manage connectors while editing an agent in Agent Studio.

    <Frame>
      <img src="https://mintlify.s3.us-west-1.amazonaws.com/tess-dfe1edf0/images/connectors/google-sheets/01-connect-panel.png" alt="PRINT: (Connectors panel with Google Sheets highlighted and the Connect button visible)" />
    </Frame>
  </Step>

  <Step title="Find Google Sheets and click Connect">
    Under **Apps**, locate **Google Sheets** and click **Connect** to start authentication.

    <Frame>
      <img src="https://mintlify.s3.us-west-1.amazonaws.com/tess-dfe1edf0/images/connectors/google-sheets/02-oauth-consent.png" alt="PRINT: (Provider authorization / consent screen for Google Sheets)" />
    </Frame>
  </Step>

  <Step title="Authorize access">
    Sign in with the account you want to use and review the requested permissions before confirming.
  </Step>

  <Step title="Confirm it is active">
    Back in Tess, **Google Sheets** should appear under **Connected**, ready for chats and agents.

    <Frame>
      <img src="https://mintlify.s3.us-west-1.amazonaws.com/tess-dfe1edf0/images/connectors/google-sheets/03-connected.png" alt="PRINT: (Tess callback or Connectors list showing Google Sheets as Connected with a success state)" />
    </Frame>
  </Step>
</Steps>

## What you can do

* **Read spreadsheet data** from accessible files and tabs
* **Analyze metrics and trends** to produce summaries
* **Update cells or append rows** when write access is available
* **Support operational reporting** from live sheet data
* **Help teams turn tables into decisions** faster

## Example prompts

> 1. Analyze the leads spreadsheet and tell me which contacts had no follow-up in the last 7 days.
> 2. Read the monthly metrics sheet and generate an executive summary of the main deviations.
> 3. Append a row with today's sales total to the Daily Close tab.
> 4. Which columns look incomplete in the onboarding tracker?

## Best practices

* Share the spreadsheet name or link context when several files look similar.
* Ask for a preview before bulk writes.
* In agents, define whether Sheets is for analysis, reporting, or data entry.

## Troubleshooting

<AccordionGroup>
  <Accordion title="App blocked / API access error" icon="circle-question">
    Reconnect and confirm the Google account can authorize Sheets. Workspace admins may need to allow the app.
  </Accordion>

  <Accordion title="401 / connection dropped" icon="circle-question">
    Reconnect Google Sheets in Connectors after credential or policy changes.
  </Accordion>

  <Accordion title="Cannot edit a sheet" icon="circle-question">
    The connected account may be viewer-only. Use an account with edit access.
  </Accordion>
</AccordionGroup>

<Note>
  Tess uses the permissions of the connected account. It does not expand access beyond what that account can already do.

  Connectors involve access to external systems. Only connect accounts that fit the usage context, and review permissions carefully.
</Note>