Skip to main content
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 ecosystem and uses OAuth authentication for Apps connectors.

​
Prerequisites

  • A Google account with access to the spreadsheets you need.
  • Permission to authorize Google Sheets OAuth scopes.

​
How to connect

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.
1

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.
PRINT: (Connectors panel with Google Sheets highlighted and the Connect button visible)
2

Find Google Sheets and click Connect

Under Apps, locate Google Sheets and click Connect to start authentication.
PRINT: (Provider authorization / consent screen for Google Sheets)
3

Authorize access

Sign in with the account you want to use and review the requested permissions before confirming.
4

Confirm it is active

Back in Tess, Google Sheets should appear under Connected, ready for chats and agents.
PRINT: (Tess callback or Connectors list showing Google Sheets as Connected with a success state)

​
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

Reconnect and confirm the Google account can authorize Sheets. Workspace admins may need to allow the app.
Reconnect Google Sheets in Connectors after credential or policy changes.
The connected account may be viewer-only. Use an account with edit access.
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.