Skip to main content

​
Overview

OneCLI connects AI agents to Google Sheets through Google’s OAuth flow. Agents can read spreadsheet data, write values, create new sheets, and manage formatting. The gateway injects OAuth credentials into requests to the Google Sheets API automatically. This is useful for agents that need to extract data from spreadsheets, generate reports, populate templates, or sync data between systems.

​
Setup

1

Go to Connections

Open the OneCLI dashboard and navigate to Connections > Google Sheets.
2

Authorize

Click Connect Google Sheets. You’ll be redirected to Google to authorize OneCLI. Review the permissions and click Allow.

​
What agents can do

  • Read cell values from specific ranges (e.g., Sheet1!A1:D10)
  • Write values to individual cells or ranges
  • Append rows to the bottom of a sheet
  • Create new spreadsheets with specified titles and initial data
  • Add, rename, and delete sheets within a spreadsheet
  • Read and apply cell formatting (bold, colors, borders, number formats)
  • Create and manage named ranges
  • Read spreadsheet metadata (title, sheets, locale)
  • Clear cell contents in a specified range
  • Batch read or write multiple ranges in a single request

​
Controlling access

Access is per agent: grant the connection to each agent that needs it, choosing per tool what runs freely, what needs human approval, and what stays blocked — a read-only agent is a single grant. Organization rules add guardrails on top, like rate limits and blanket blocks. Everything is checked before credential injection, so a blocked request never reaches Google Sheets.