Skip to main content
HTTP API connector An HTTP API described by an OpenAPI spec, not an MCP server. Calls go to https://sheets.googleapis.com and carry an OAuth 2.0 token obtained with Sign in with Google on the cloud edition, or an API key or custom header on a self-hosted installation, which offers no sign-in flow.

​
What the skill can do

API connector: 17 actions, as they appear in the skill panel. 13 of them create, change or delete something in Google Sheets; mark those under These actions need approval when you add the skill to an agent.
  • Values management (5): Append Values To Range, Get Values From Range, Set Values In Range, Get Values From Multiple Ranges, Spreadsheets Management Batch Update Spreadsheet
  • Spreadsheets management (4): Create New Spreadsheet, Get Spreadsheet By Id, Values Management Get Values By Data Filter, Values Management Update Values In Multiple Ranges
  • Cellcontent management (3): Cell Content Clear Values From Range, Cell Content Clear Values From Multiple Ranges, Cell Content Clear Values By Data Filter
  • Developermetadata management (2): Metadata Management Get Developer Metadata By Id, Metadata Management Search Developer Metadata
  • Datafilter management (2): Values Management Update Values By Data Filter, Spreadsheets Management Get Spreadsheet By Data Filter
  • Sheets management (1): Copy Sheet To Another Spreadsheet

​
Authentication Options

The simplest way to connect Google Sheets is by using xpander’s built-in authentication:
  1. In Xpander Chat, open the agent’s settings and click Add skill.
  2. Search for Google Sheets and select it.
  3. Click Sign in with Google Sheets.
  4. Grant xpander permission to access your account.
  5. Your Google Sheets integration is now ready to use.
This method is recommended for most users. xpander securely manages your OAuth tokens without exposing any credentials.

​
Give an agent the Google Sheets skill

Once Google Sheets is connected, any agent you can edit may be given the skill: open the agent’s settings, click Add skill, and choose Google Sheets. The skill panel lists the Google Sheets actions by group. Enable only the groups the agent needs, and mark the actions that should wait for a named person’s sign-off under These actions need approval. Which skills exist for your organization, and who may add them, is decided by your admins; see Skills.