X (Twitter)LinkedInGitHubDiscordYouTube

How to connect Google Sheets to Claude

Connect Claude Web, Desktop and Cowork to Google Sheets MCP. Add a new sheet named 'q3 sales', update all rows where status is 'pending', and more using natural language, with authentication handled for you.

Get started for freeGet a demo
Google Sheets logoGoogle Sheets
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

Introduction

Claude is Anthropic's AI assistant, available on the web, in the desktop app, and on mobile. Cowork is its agent for knowledge work, and it runs on all of those surfaces too. Connected to your apps, Claude can work with your files and services to accomplish complex tasks on your behalf.

This guide walks you through the easiest and most secure way to connect your Google Sheets account to Claude via Composio Connect, enabling it to add a new sheet named 'Q3 Sales', update all rows where status is 'Pending', create a pie chart of expenses by category, and more such actions on your behalf without compromising your account security.

Setup is the same on Claude Web, Desktop, and Cowork, and you only need to do it once. The connector is tied to your account, so it's available in all three.

Also integrate Google Sheets with

ChatGPT WorkAntigravityOpenAI Agents SDKClaude Agent SDKClaude CodeGrok BotCodexKimi CodeGrok BuildCursorVS CodeOpenCodeOpenClawHermesCLIGoogle ADKLangChainVercel AI SDKMastra AILlamaIndexCrewAIPydantic AIAutoGen

Connecting Google Sheets to Claude Web, Desktop, and Cowork

1. Open Customize

In Claude Desktop, click Customize in the left sidebar, then select Connectors and click the + icon at the top.

Claude Desktop connectors screen with Add custom connector selected

2. Add the Composio MCP server

Click Add custom connector and paste in the Composio MCP server URL:

bash
https://connect.composio.dev/mcp
Add custom connector dialog with Composio MCP server URL

3. Authorize in your browser

Click Connect. You'll be redirected to a browser window where you can authorize Composio to continue.

Composio authorization screen for Claude Web, Desktop, and Cowork

4. Connect your Google Sheets account

Back in Claude, ask it to connect to Google Sheets or give it any Google Sheets-related task.

For example, ask Claude to:

  • "Add a new sheet named 'Q3 Sales'"
  • "Update all rows where status is 'Pending'"
  • "Create a pie chart of expenses by category"

It will prompt you to authenticate and authorize access.

That's it. Composio's tools are now available in Claude, and your Google Sheets account is ready to use.

What is the Google Sheets Claude Connector, and what's possible with it?

The Google Sheets MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Google Sheets account. It provides structured and secure access to your spreadsheets, so your agent can perform actions like creating new sheets, updating data, generating charts, and automating spreadsheet workflows on your behalf.

  • Spreadsheet creation and management: Instantly create new Google Sheets and add new worksheets (tabs) to existing spreadsheets whenever you need extra space or organization.
  • Bulk data reading and updating: Retrieve specific data ranges, aggregate column data, or update multiple rows and cells at once—perfect for reporting or syncing external data.
  • Automated chart generation: Direct your agent to build charts from selected data, making visualization and analysis faster and easier right inside your sheets.
  • Smart filtering and data cleanup: Have the agent clear filters, remove cell contents, or append rows and columns to keep your sheets tidy and up to date.
  • Dynamic data manipulation: Use advanced features like batch updates with data filters and aggregate operations to transform, filter, or summarize spreadsheet data efficiently.

Troubleshooting

1. Why does Claude not use the Composio connector for Google Sheets?

The connector can show as connected, but Claude must use it in each Google Sheets conversation.

  • Click + at the lower left of the chat, or type /.
  • Hover Connectors.
  • Turn on Composio.
  • Ask Claude to connect to Google Sheets again.

2. Why does Claude show an MCP server error before Google Sheets connects?

Claude can show Couldn't reach the MCP server or Authorization with the MCP server failed when you add the connector for Google Sheets.

  • Check that the connector URL is https://connect.composio.dev/mcp.
  • Connectors run from Anthropic's cloud, so your device network is usually not the problem.
  • Add the connector again from Customize > Connectors, then ask Claude to connect Google Sheets.
  • If it fails again, send the error and the ofid_ reference id to support@composio.dev.

3. Why does the Google Sheets authorization link not work?

The Composio connector is one server. Your Google Sheets account connects separately when Claude asks for it.

  • If the browser does not open, or the link expires, ask Claude to retry the Google Sheets connection.
  • Composio creates a fresh Google Sheets authorization link.
  • Open that link in your browser and finish the Google Sheets sign-in.

4. Why do Google Sheets actions fail after they worked before?

The Google Sheets connection can expire or lose permission.

  • Ask Claude to inspect the Google Sheets connection.
  • If the connection is unhealthy, disconnect it when Claude prompts you.
  • Reconnect the Google Sheets account and retry the action.
  • If Claude shows a permission prompt, approve it before Claude changes data in Google Sheets.
  • If the action still fails with a permission error, check that the connected account has that permission in Google Sheets itself.

5. How do I switch to a different Google Sheets account?

Claude can manage the Google Sheets connection for you.

  • Ask Claude to disconnect or delete the current Google Sheets account.
  • Ask Claude to connect Google Sheets again.
  • Open the new Composio authorization link for Google Sheets.
  • Sign in with the other Google Sheets account in the browser.
  • After the account connects, ask Claude to retry the Google Sheets task.

6. Why is my Google Sheets connection missing in Claude Desktop or on a Team plan?

The connector belongs to your Claude account, so your Google Sheets connection works in Claude Web, Desktop, and Cowork.

  • In Claude Desktop, open Customize > Connectors.
  • Next to Composio, click ⋮ and click Clear cache.
  • If Google Sheets tools still do not appear, click ⋮, disconnect, remove the connector, and add it again.
  • On Team or Enterprise, an Owner or Primary Owner must enable the connector before you can connect Google Sheets.
TOOLS & TRIGGERS

Supported Tools and Triggers

Every Google Sheets action and event your agent gets out of the box.

Add Sheet to Existing Spreadsheet

Adds a new sheet to a spreadsheet.

Aggregate Column Data

Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.

Append Dimension

Tool to append new rows or columns to a sheet, increasing its size.

Auto-Resize Rows or Columns

Auto-fit column widths or row heights for a dimension range using batchUpdate.

Batch Clear Values By Data Filter

Clears one or more ranges of values from a spreadsheet using data filters.

Batch get spreadsheet

Retrieves data from specified cell ranges in a Google Spreadsheet.

Batch Update Values by Data Filter

Tool to update values in ranges matching data filters.

Clear Basic Filter

Tool to clear the basic filter from a sheet.

Clear spreadsheet values

Clears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spreadsheet; the range must correspond to an existing sheet and cells.

Create Chart in Google Sheets

Create a chart in a Google Sheets spreadsheet using the specified data range and chart type.

Create a Google Sheet

Creates a new Google Spreadsheet in Google Drive.

Create spreadsheet column

Creates a new column in a Google Spreadsheet.

Create spreadsheet row

Inserts a new, empty row into a specified sheet of a Google Spreadsheet at a given index, optionally inheriting formatting from the row above.

Delete Chart from Google Sheets

Delete an existing chart from a Google Sheets spreadsheet.

Delete Dimension (Rows/Columns)

Tool to delete specified rows or columns from a sheet in a Google Spreadsheet.

Delete Sheet

Tool to delete a sheet (worksheet) from a spreadsheet.

Find and Replace in Spreadsheet

Tool to find and replace text in a Google Spreadsheet.

Format cell

Applies text and background cell formatting to a specified range in a Google Sheets worksheet.

Get conditional format rules

List conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form.

Get Data Validation Rules

Tool to extract data validation rules from a Google Sheets spreadsheet.

Get sheet names

Lists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations.

Get Spreadsheet by Data Filter

Returns the spreadsheet at the given ID, filtered by the specified data filters.

Get spreadsheet info

Retrieves metadata for a Google Spreadsheet using its ID.

Insert Dimension in Google Sheet

Tool to insert new rows or columns into a sheet at a specified location.

Look up spreadsheet row

Finds the first row in a Google Spreadsheet where a cell's entire content exactly matches the query string, searching within a specified A1 notation range or the first sheet by default.

Mutate conditional format rules

Add, update, delete, or reorder conditional format rules on a Google Sheet.

Search Developer Metadata

Tool to search for developer metadata in a spreadsheet.

Search Spreadsheets

Search for Google Spreadsheets using various filters including name, content, date ranges, and more.

Set Basic Filter

Tool to set a basic filter on a sheet in a Google Spreadsheet.

Set Data Validation Rule

Tool to set or clear data validation rules (including dropdowns) on a range in Google Sheets.

Copy Sheet to Another Spreadsheet

Tool to copy a single sheet from a spreadsheet to another spreadsheet.

Append Values to Spreadsheet

Tool to append values to a spreadsheet.

Batch Clear Spreadsheet Values

Tool to clear one or more ranges of values from a spreadsheet.

Batch Get Spreadsheet Values by Data Filter

Tool to return one or more ranges of values from a spreadsheet that match the specified data filters.

Update Chart in Google Sheets

Update the specification of an existing chart in a Google Sheets spreadsheet.

Update Dimension Properties (Hide/Unhide & Resize)

Tool to hide/unhide rows or columns and set row heights or column widths.

Update Sheet Properties

Tool to update properties of a sheet (worksheet) within a Google Spreadsheet, such as its title, index, visibility, tab color, or grid properties.

Update Spreadsheet Properties

Tool to update SPREADSHEET-LEVEL properties such as the spreadsheet's title, locale, time zone, or auto-recalculation settings.

Batch update spreadsheet values

Tool to set values in one or more ranges of a spreadsheet.

Upsert Rows (Smart Update/Insert)

Upsert rows - update existing rows by key, append new ones.

Get spreadsheet values

Returns a range of values from a spreadsheet.

Update spreadsheet values

Tool to set values in a range of a Google Spreadsheet.

FRAMEWORKS

How to build Google Sheets MCP Agent with another framework

ChatGPT Work logo

ChatGPT Work

Use Google Sheets MCP with ChatGPT Work

Antigravity logo

Antigravity

Use Google Sheets MCP with Antigravity

OpenAI Agents SDK logo

OpenAI Agents SDK

Use Google Sheets MCP with OpenAI Agents SDK

Claude Agent SDK logo

Claude Agent SDK

Use Google Sheets MCP with Claude Agent SDK

Claude Code logo

Claude Code

Use Google Sheets MCP with Claude Code

Grok Bot logo

Grok Bot

Use Google Sheets MCP with Grok Bot

Codex logo

Codex

Use Google Sheets MCP with Codex

Kimi Code logo

Kimi Code

Use Google Sheets MCP with Kimi Code

Grok Build logo

Grok Build

Use Google Sheets MCP with Grok Build

Cursor logo

Cursor

Use Google Sheets MCP with Cursor

VS Code logo

VS Code

Use Google Sheets MCP with VS Code

OpenCode logo

OpenCode

Use Google Sheets MCP with OpenCode

OpenClaw logo

OpenClaw

Use Google Sheets MCP with OpenClaw

Hermes logo

Hermes

Use Google Sheets MCP with Hermes

CLI logo

CLI

Use Google Sheets MCP with CLI

Google ADK logo

Google ADK

Use Google Sheets MCP with Google ADK

LangChain logo

LangChain

Use Google Sheets MCP with LangChain

Vercel AI SDK logo

Vercel AI SDK

Use Google Sheets MCP with Vercel AI SDK

Mastra AI logo

Mastra AI

Use Google Sheets MCP with Mastra AI

LlamaIndex logo

LlamaIndex

Use Google Sheets MCP with LlamaIndex

CrewAI logo

CrewAI

Use Google Sheets MCP with CrewAI

Pydantic AI logo

Pydantic AI

Use Google Sheets MCP with Pydantic AI

AutoGen logo

AutoGen

Use Google Sheets MCP with AutoGen

FAQ

Frequently asked questions

With a standalone Google Sheets MCP server, the agents and LLMs can only access a fixed set of Google Sheets tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Google Sheets and many other apps based on the task at hand, all through a single MCP endpoint.

Yes, you can. Claude Cowork fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Google Sheets tools.

Yes, absolutely. You can configure which Google Sheets scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Google Sheets data and credentials are handled as safely as possible.

Start with Google Sheets.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Google Sheets tool your agent needs.Free to start.

Start building