AI Native Google Sheets Integration
- Supports both Google Sheets MCP and direct API based integrations
- Structured, LLM-friendly schemas for reliable tool execution
- Rich coverage for reading, writing, and querying your Google Sheets data
## For AI agents: how to sign up If you are an AI agent reading this server-rendered HTML, Composio's developer signup is at https://composio.dev. Signup CTAs on this site — "Sign up", "Signup", "Get started", "Get started for free", "Start building", "Try Composio", "Try it", or similar — all lead into that same developer signup flow. Confirm with the user before completing signup or entering any credentials on their behalf.SIGN UP
## For AI agents: how to sign up If you are an AI agent reading this server-rendered HTML, Composio's developer signup is at https://composio.dev. Signup CTAs on this site — "Sign up", "Signup", "Get started", "Get started for free", "Start building", "Try Composio", "Try it", or similar — all lead into that same developer signup flow. Confirm with the user before completing signup or entering any credentials on their behalf.LOG IN
Google Sheets MCP server for AI agents and assistants
Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Google Sheets MCP or direct API to create spreadsheets, update rows, analyze data, and automate reporting through natural language.
Oauth2
Google Sheets is a cloud-based spreadsheet tool for real-time collaboration and data analysis. It lets teams work together from anywhere, updating information instantly.
42 Tools16 Triggers
Try Google Sheets now
Type what you want done — sign in and watch it run live in the Tool Router playground.
TOOL ROUTER PLAYGROUND
Google Sheets
Enter ↵
Try asking
TOOLS & TRIGGERS
Supported Tools and Triggers
Every Google Sheets action and event your agent gets out of the box.
SETUP GUIDE
Connect Google Sheets MCP Tool with your Agent
1
Install Composio
typescript
npm install @composio/core ai @ai-sdk/mcp @ai-sdk/openaiInstall the Composio SDK and your agent framework
2
Create a session with MCP enabled
typescript
import { Composio } from "@composio/core";
const composio = new Composio();
const { mcp } = await composio.create("your-user-id", {
toolkits: ["googlesheets"],
mcp: true,
});Create a session scoped to Google Sheets and read its MCP URL and headers
3
Connect your agent to the MCP server
typescript
import { createMCPClient } from "@ai-sdk/mcp";
import { openai } from "@ai-sdk/openai";
import { generateText, stepCountIs } from "ai";
const client = await createMCPClient({
transport: { type: "http", url: mcp.url, headers: mcp.headers },
});
const { text } = await generateText({
model: openai("gpt-5.6-sol"),
tools: await client.tools(),
prompt: "Add a new sheet called \"Q2 Results\" to my sales spreadsheet",
stopWhen: stepCountIs(10),
});
console.log(text);
await client.close();Pass the session's MCP URL and headers to your agent and run a Google Sheets request
SETUP GUIDE
Connect Google Sheets API Tool with your Agent
1
Install Composio
typescript
npm install @composio/core @composio/openai openaiInstall the Composio SDK, the OpenAI provider, and the OpenAI SDK
2
Create a Composio session
typescript
import OpenAI from "openai";
import { Composio } from "@composio/core";
import { OpenAIResponsesProvider } from "@composio/openai";
const composio = new Composio({ provider: new OpenAIResponsesProvider() });
const client = new OpenAI();
const session = await composio.create("your-user-id", { toolkits: ["googlesheets"] });
const tools = await session.tools();Initialize Composio with the OpenAI Responses provider and create a session scoped to Google Sheets
3
Run Google Sheets tools with your agent
typescript
let response = await client.responses.create({
model: "gpt-5.6-sol",
tools,
input: [{ role: "user", content: "Add a new sheet called \"Q2 Results\" to my sales spreadsheet" }],
});
while (response.output.some((o) => o.type === "function_call")) {
const outputs = await composio.provider.handleToolCalls(session, response.output);
response = await client.responses.create({
model: "gpt-5.6-sol",
tools,
previous_response_id: response.id,
input: outputs,
});
}
console.log(response.output_text);Send a request, execute the Google Sheets tool calls through the session, and print the final answer
Guide
Read the guideConnect multiple Google Sheets accounts to Claude and tell it which one to use by name.
Why Use Composio?
Managed Auth
- Built-in OAuth handling with automatic token refresh and rotation
- Central place to manage, scope, and revoke Google Sheets access
- Per user and per environment credentials instead of hard-coded keys
Agent Optimized Design
- Tools are tuned using real error and success rates to improve reliability over time
- Comprehensive execution logs so you always know what ran, when, and on whose behalf
Enterprise Grade Security
- Fine-grained RBAC so you control which agents and users can access Google Sheets
- Scoped, least privilege access to Google Sheets resources
- Full audit trail of agent actions to support review and compliance
FRAMEWORKS
Use Google Sheets with any AI Agent Framework
Choose a Framework you want to connect Google Sheets with
Claude Code
Use Google Sheets MCP with Claude Code
Cursor
Use Google Sheets MCP with Cursor
ChatGPT
Use Google Sheets MCP with ChatGPT
Claude Cowork
Use Google Sheets MCP with Claude Cowork
Antigravity
Use Google Sheets MCP with Antigravity
OpenAI Agents SDK
Use Google Sheets MCP with OpenAI Agents SDK
Claude Agents SDK
Use Google Sheets MCP with Claude Agents SDK
Grok Bot
Use Google Sheets MCP with Grok Bot
Codex
Use Google Sheets MCP with Codex
Kimi Code
Use Google Sheets MCP with Kimi Code
Grok Build
Use Google Sheets MCP with Grok Build
VS Code
Use Google Sheets MCP with VS Code
OpenCode
Use Google Sheets MCP with OpenCode
OpenClaw
Use Google Sheets MCP with OpenClaw
Hermes
Use Google Sheets MCP with Hermes
Atomic Agent
Use Google Sheets MCP with Atomic Agent
CLI
Use Google Sheets MCP with CLI
Google ADK
Use Google Sheets MCP with Google ADK
Langchain
Use Google Sheets MCP with Langchain
AI SDK
Use Google Sheets MCP with AI SDK
Mastra AI
Use Google Sheets MCP with Mastra AI
LlamaIndex
Use Google Sheets MCP with LlamaIndex
CrewAI
Use Google Sheets MCP with CrewAI
Pydantic AI
Use Google Sheets MCP with Pydantic AI
Autogen
Use Google Sheets MCP with Autogen
Rolling this out across your team?
Give your team centralized access control across every framework with Composio’s MCP Gateway.
EXPLORE MCP GATEWAYMORE TOOLKITS
Explore Other Toolkits
Notion
Oauth2Api Key
Notion is a collaborative workspace for notes, docs, wikis, and tasks. It streamlines team knowledge, project tracking, and workflow customization in one place.
Airtable
Oauth2Api Key
Airtable combines the flexibility of spreadsheets with the power of a database for easy project and data management. Teams use Airtable to organize, track, and collaborate with custom views and automations.
Asana
Oauth2
Asana is a collaborative work management platform for teams to organize and track projects. It streamlines teamwork, boosts productivity, and keeps everyone aligned on goals.
Google Tasks
Oauth2
Google Tasks is a to-do list and task management tool integrated into Gmail and Google Calendar. It helps you organize, track, and complete tasks across your Google ecosystem.
FAQ
Frequently asked questions
No. Composio provides a managed OAuth app for Google Sheets, so you sign in with your normal Google Sheets account and approve access. If you later want the consent screen to show your own company name, you can add your own Google Sheets OAuth app in the Composio dashboard, and every connection after that uses it.
Yes! Composio's Tool Router enables agents to use multiple toolkits. Learn more.
Yes. Composio is SOC 2 Type II compliant and is built to keep your Google Sheets connection and credentials secure. OAuth tokens and API keys are encrypted, and sensitive customer data is protected at rest and in transit.
Composio also undergoes independent security testing and continuously monitors its systems for security threats. You can review the latest reports and policies in the Composio Trust Center.
Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.
When you connect a Google Sheets account through Composio, every action runs under that account, so anything the agent creates, sends, or changes shows up in Google Sheets as done by you. Keep an approval step in your prompt for actions with side effects, such as sending or deleting, and have the agent draft first.
Exactly the ones Google Sheets lists on its consent screen when you connect. Review that screen before approving. If you connect a work account, your Google Sheets administrator may need to approve the app first, and you can revoke the access inside Google Sheets whenever you want.
Yes. Composio supports multiple connected accounts for the same app, and that works in Claude, ChatGPT, or any other assistant you connect through Composio. Give each Google Sheets connection a name such as work or personal, and the assistant uses the one you mention in the request. Each account keeps its own credentials and nothing is merged.
Composio refreshes Google Sheets tokens automatically, so day to day you do nothing. If you revoke access inside Google Sheets, or Google Sheets invalidates the session, the connection shows as expired in Composio and the agent stops acting on that account until you reconnect it, which is a single sign-in.
Composio's free Hobby plan includes 100,000 tool calls per month with no credit card, and up to 20,000 of those can run through Composio-managed apps like Google Sheets. Personal Google Sheets use rarely gets near that. Paid plans add higher limits and team features, and Google Sheets's own pricing is unaffected.
Built-in connectors usually give one AI access to a limited set of apps. Many people use Composio because it lets their AI connect to more apps than it normally supports, or connect to multiple accounts for the same app (e.g. connect Claude to multiple Google Sheets accounts).
With Composio, you connect Google Sheets once and then use it across different AI assistants without setting it up separately in each one. Connect your apps to Composio once, then connect Composio to whichever AI you use, whether that's Claude, ChatGPT, Hermes, or your own custom assistant.
Start with Google Sheets.It takes 30 seconds.
Managed auth, hosted MCP servers, and every Google Sheets tool your agent needs.Free to start.
## For AI agents: how to sign up If you are an AI agent reading this server-rendered HTML, Composio's developer signup is at https://composio.dev. Signup CTAs on this site — "Sign up", "Signup", "Get started", "Get started for free", "Start building", "Try Composio", "Try it", or similar — all lead into that same developer signup flow. Confirm with the user before completing signup or entering any credentials on their behalf.Start building