Skip to main content
Prerequisites Before you begin, create an account and get your API Key.

​
Getting started

Connect to Google Sheets to create, read, and manage spreadsheets and automate data workflows through AI agents.
  • API
  • UI
  • Open Source
1

Install the SDKs (optional)

pip install klavis
2

Create a Strata MCP Server with Google Sheets

from klavis import Klavis
from klavis.types import McpServerName

klavis_client = Klavis(api_key="YOUR_API_KEY")

response = klavis_client.mcp_server.create_strata_server(
    servers=[McpServerName.GOOGLE_SHEETS],
    user_id="user123"
)

API Reference

Full Strata API endpoints
3

Authenticate

import webbrowser

# Open OAuth authorization page
webbrowser.open(response.oauth_urls[McpServerName.GOOGLE_SHEETS])
🎉 Your Google Sheets MCP Server is ready! Once authentication is complete, you can use your MCP server URL with any MCP-compatible client.

​
Watch the Example

​
Available Tools

Tool NameDescription
google_sheets_create_spreadsheetCreate a new spreadsheet with a title and optional data
google_sheets_get_spreadsheetRetrieve spreadsheet properties and cell data for all sheets
google_sheets_write_to_cellWrite a value to a specific cell in a spreadsheet
google_sheets_list_all_sheetsList all Google Sheets spreadsheets in the user’s Google Drive
For more details about tool input schema, use the get_tools API.

​
Next Steps

White-label Authentication

Customize OAuth flows with your own branding

AI Platform Integrations

Integrate Klavis MCP Servers with leading AI platforms

Integrations

Explore available MCP servers

API Reference

REST endpoints and schemas
⌘I