# Toolcape + Google Sheets

Toolcape connects a company’s existing AI to its systems through one MCP entry point, with account connections, group and individual permissions, and audit logs. This documentation describes a product prototype; it is not evidence that a live server or account is connected.

## The connection
Google Sheets: Google’s spreadsheets for budgets, lists and shared tables.
API connection · AI uses Toolcape through MCP
Provider sign-in (OAuth). Confirm whether the configured connection acts as the user or uses application permissions.

## Typical actions
- Read: Read cells, ranges and spreadsheet structure
- Create: Create a spreadsheet or append rows
- Change: Update values and formatting
A changed cell can affect formulas and reports. Limit write access to the workflows that need it.

## Setup
1. IT configures the provider app, API and requested scopes.
2. Provider sign-in (OAuth). Confirm whether the configured connection acts as the user or uses application permissions.
3. Make the service available in Toolcape. Set Everyone, group and individual rules for the actions actually needed. Adding a service does not grant access.
4. Connect the approved AI client to the actual Toolcape MCP address and sign in. Start with a harmless read-only task and check the audit log.

## Permissions
For personal delegated access, the provider account, approved app scopes and Toolcape rules must all permit the action. Shared accounts and application permissions may have other limits. Toolcape combines Everyone and group grants; a personal exception replaces inherited access for that service. Reading can disclose confidential information. Sharing, sending and deletion need separate consideration.

## Calling an operation
First discover which tools the connected Toolcape server actually exposes. If it offers search → describe → execute, find the relevant operation, inspect its input schema and permissions, then call it with validated inputs. Tool names vary by server; do not invent names, arguments, URLs or successful outcomes. Without connected tools, give setup guidance instead of claiming to perform actions.

## Operation reference
Catalog snapshot: 16 September 2026. Verify the current schema before calling.
- sheetsSpreadsheetsGet — Get Spreadsheets
  GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsCreate — Create Spreadsheets
  POST https://sheets.googleapis.com/v4/spreadsheets
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsGetByDataFilter — Get Spreadsheets By Data Filter
  POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:getByDataFilter
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsBatchUpdate — Batch Spreadsheets Update
  POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:batchUpdate
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsValuesGet — Get Spreadsheets Values
  GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsValuesUpdate — Update Spreadsheets Values
  PUT https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsValuesBatchClearByDataFilter — Batch Spreadsheets Values Clear By Data Filter
  POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsValuesBatchGet — Batch Spreadsheets Values Get
  GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchGet
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsValuesBatchClear — Batch Spreadsheets Values Clear
  POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchClear
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsValuesBatchUpdate — Batch Spreadsheets Values Update
  POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchUpdate
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsValuesBatchGetByDataFilter — Batch Spreadsheets Values Get By Data Filter
  POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsValuesClear — Spreadsheets Values Clear
  POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:clear
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsValuesBatchUpdateByDataFilter — Batch Spreadsheets Values Update By Data Filter
  POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsValuesAppend — Spreadsheets Values Append
  POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsDeveloperMetadataGet — Get Spreadsheets Developer Metadata
  GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId}
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsDeveloperMetadataSearch — Search Spreadsheets Developer Metadata
  POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/developerMetadata:search
  https://developers.google.com/workspace/sheets/
- sheetsSpreadsheetsSheetsCopyTo — Copy Spreadsheets Sheets To
  POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo
  https://developers.google.com/workspace/sheets/

## A useful first question
Summarize the figures in the sales sheet.

## If it fails
Check the account, expired authorization, app approval, provider scopes and Toolcape permissions. Share only redacted errors with support. Never paste passwords, tokens or client secrets into an AI conversation.