# Google Sheets MCP 2026: Connect Sheets to Claude or ChatGPT | Enrich Labs

> Claude and ChatGPT can both read and edit Google Sheets with official tools. How to connect each, what it can change, and when a file upload is enough.

_Source: https://www.enrichlabs.ai/blog/google-sheets-mcp_

---

## TLDR

Yes, you can connect Google Sheets to Claude or ChatGPT without a developer, and as of November 2026 both can edit a live sheet, not just read it. Each offers two official routes: a connection you turn on in the chat, and an add-on that opens the assistant in a sidebar inside Sheets.

-   **Claude, from the chat.** Claude's Google Sheets connector (in beta) creates and edits sheets in a pane beside the chat. The Google Drive connector on its own only reads them.
-   **Claude, inside Sheets.** Anthropic's Claude add-on is in beta on paid Claude plans. Open it from Extensions > Claude.
-   **ChatGPT.** The Google Drive app covers Sheets, and OpenAI's ChatGPT for Google Sheets add-on is offered on Free, Go, Plus, Pro and business plans.
-   **Google's own Sheets MCP server is for developers.** It is a developer preview that needs a Google Cloud project and a sign-up for Google's preview program.
-   **The simplest fallback still works.** Download the sheet as an Excel or CSV file and upload it.
-   **Which to pick:** for help building or cleaning one sheet, use the Claude or ChatGPT add-on. If you want your reporting tab filled from your ad, email and store accounts every week, use [Helena](/ai-marketing-agent), which reads those accounts and writes the numbers into your sheet.

We make Helena, which is one of the options covered here.

## What Google Sheets MCP is

MCP is the standard that lets an AI assistant such as Claude or ChatGPT use another app for you. "Google Sheets MCP" usually means any connection that lets the assistant open your spreadsheets, read the cells and write back.

Instead of pasting rows into a chat, you ask "Which campaigns on the Budget tab are pacing over?" and then "Add a remaining-budget column," and it works on the sheet your team already uses.

## Is there an official one?

Yes, several, and they do different things.

**Claude's Google Drive connector reads sheets only.** Its directory listing says it is made by Google and "Anthropic verified" ([Claude directory: Google Drive](https://claude.com/connectors/google-drive)). Anthropic's help page says it can "Read Sheets, Slides, PDFs, images, and MS Office files," pulling out text only. See our [Google Drive MCP](/blog/google-drive-mcp) guide for more.

**Claude's Google Sheets connector reads and edits.** Anthropic added separate Docs, Sheets and Slides connectors in beta in October 2026. They let Claude "edit files live in a pane beside the chat" and "create new Google Docs, Sheets, and Slides files," while you work in the same file ([Claude help: Google Workspace connectors](https://support.claude.com/en/articles/10166901-use-google-workspace-connectors)). The live pane works on Claude on the web in Chrome and in Claude Desktop with its built-in browser on. Claude can only open files your Google account can open, and on Team and Enterprise plans an Owner must turn the connectors on first.

**Claude for Google Sheets is an add-on inside Sheets.** Anthropic says that in Sheets, "Claude can write formulas, build pivot tables and native Sheets charts, and add new tabs." Its default "Ask before edits" mode shows each change as a card you approve ([Anthropic announcement](https://claude.com/resources/articles/claude-now-works-in-google-docs-sheets-and-slides)). It is in beta for Pro, Max, Ultra, Team and Enterprise plans ([Claude help: Claude in Google Docs, Sheets, and Slides](https://support.claude.com/en/articles/16951679-use-claude-in-google-docs-sheets-and-slides)) and published by Anthropic on the [Google Workspace Marketplace](https://workspace.google.com/marketplace/app/claude/12459801340).

**ChatGPT's Google Drive app.** OpenAI says "Google Docs, Sheets, and Slides actions are available through the Google Drive app rather than separate apps." Creating or updating a file needs the matching Google permissions and must be allowed in your workspace, and ChatGPT may ask you to confirm ([OpenAI help: Google Drive app](https://help.openai.com/en/articles/10929079-google-drive-app-and-setup-in-chatgpt)). Availability depends on your plan and workspace settings.

**ChatGPT for Google Sheets is OpenAI's add-on.** It is a sidebar that can "build, update, and explain spreadsheets directly," available to Free, Go, Plus and Pro users and to Business, Enterprise, Edu and K-12 ([OpenAI help: ChatGPT for Excel and Google Sheets](https://help.openai.com/en/articles/20001063-chatgpt-for-excel-and-google-sheets)). Its [Marketplace listing](https://workspace.google.com/marketplace/app/chatgpt/870214997678), published by OpenAI, says "Free of charge with paid features," as of November 2026.

**Google's Sheets MCP server.** Google runs one, but it is "available as part of the Google Workspace Developer Preview Program." Setup means creating a Google Cloud project and your own sign-in app ([Google for Developers](https://developers.google.com/workspace/sheets/api/guides/configure-mcp-server)), so it is not a path for most marketers yet.

## The easiest way to connect

**In Claude, editing from the chat:**

1.  Use Claude on the web in Chrome, or Claude Desktop.
2.  In a chat, click **+**, hover over **Connectors** and switch on **Google Sheets**. If it is not connected yet, Claude asks you to sign in with your Google account.
3.  Paste your sheet's link, or ask for a new one by name, such as "make a Google Sheet for our December content calendar." Asking for a "spreadsheet" without saying Google makes a downloadable file instead.
4.  The sheet opens in a pane beside the chat. Sign in to Google in the pane if asked, then approve each change.

You can manage these connectors later in **Customize > Connectors**.

**In Sheets, with Claude's add-on:** install Claude from the Google Workspace Marketplace, open your sheet, go to **Extensions > Claude > Open Claude**, click **Allow** for the Google permissions and sign in with your Claude account.

**In ChatGPT:** open **Plugins** or **Apps** (the name depends on your version), connect **Google Drive** and sign in with Google. Then paste a sheet link and ask. For the add-on, install ChatGPT from the Google Workspace Marketplace and open it from the **Extensions** menu in Sheets.

### To fill the sheet from your marketing accounts: connect through Helena

[Helena](/mcp), our AI marketing agent, works as a connector in Claude and ChatGPT.

1.  Create an Enrich Labs account and connect Google Drive, plus the accounts whose numbers you want, such as Google Ads, Klaviyo or Shopify.
2.  In Claude, open **Customize > Connectors**, find "Helena by Enrich Labs" and click **Connect**.
3.  Sign in to Enrich Labs, pick your brand and approve.
4.  Ask "Write last week's ad spend, email revenue and store orders into the Weekly tab of our reporting sheet."

It needs a paid Enrich Labs plan, from $39/month with a 3-day free trial ([setup guide](https://agent.enrichlabs.ai/docs/claude-connector)).

## The simplest fallback: upload the sheet as a file

If your work admin blocks the Google sign-in, download the sheet instead. Google says you can download a Sheets file "in Excel, PDF, CSV, ODS, or other formats" from the **File** menu ([Google Docs Editors Help](https://support.google.com/docs/answer/9331167?hl=en)).

-   **Claude** can "perform advanced analyses on uploaded data" and create Excel files with working formulas, on every plan including Free ([Claude help: create and edit files](https://support.claude.com/en/articles/12111783-create-and-edit-files-with-claude)).
-   **ChatGPT** accepts .xls, .xlsx and .csv files and can summarize trends, build tables and make charts. Its analysis tool "cannot make external web requests," so it only knows what is in the file ([OpenAI help: data analysis](https://help.openai.com/en/articles/8437071-data-analysis-with-chatgpt)).

The catch: you work on a copy, and nothing reaches the live sheet unless you upload it yourself.

## What you can ask it

1.  "Read the Budget tab. Which campaigns have spent more than 60% of their monthly budget with half the month left?"
2.  "In the Content Calendar tab, list every post due next week with no owner or no caption."
3.  "Find rows in the UTM list where utm\_source or utm\_medium are not lowercase, and fix them."
4.  "Add a cost-per-order column to Campaign Results and highlight anything above $40."

## What to watch for

**It edits the real sheet.** A misread request can overwrite a column your team relies on. Keep Claude's add-on in "Ask before edits," review each change before you approve, and for big edits follow OpenAI's advice to "duplicate the file first so you can revert if needed."

**It does not fetch your numbers on its own.** The add-ons work with what is in the sheet, attached files and any apps you connect. Anthropic says its add-on cannot create triggers, custom menus or scheduled refreshes.

**Some sheets are off limits.** Claude's add-on cannot read or edit Connected Sheets tabs that pull from BigQuery, and one operation stops after six minutes.

## Your options compared

Option

Who it is for

Setup effort

Can it change the sheet

Cost

Claude's Google Drive connector

Finding and reading sheets in Claude

A few clicks

No, reads only

Included with Claude

Claude's Google Sheets connector (beta)

Creating and editing sheets from a Claude chat

A few clicks

Yes, live in a pane

Included with Claude; no plan named

Claude for Google Sheets add-on (beta)

Formulas, pivots and charts inside one sheet

Install from the Marketplace

Yes, with approval cards by default

Pro, Max, Ultra, Team or Enterprise plan

ChatGPT for Google Sheets add-on

ChatGPT users working inside one sheet

Install from the Marketplace

Yes

Free to install, with paid features

Google's Sheets MCP server

Developers in Google's preview program

Needs a developer

Yes

Not stated

Upload an Excel or CSV file

Quick analysis, or when connections are blocked

Download and upload

No, you get a new file

Works on Claude's Free plan

[Helena by Enrich Labs](/mcp) (ours)

Marketers filling sheets from ad, email and store accounts

A few clicks, after connecting accounts

Yes; review before you approve

From $39/month, 3-day free trial ([pricing](/pricing))

## Filling sheets from your marketing accounts? Use Helena

For formulas, cleanup or a chart in one sheet, the add-ons above are enough. Helena earns its place when the numbers come from other tools. Once Google Drive is connected inside Enrich Labs, Helena can create a Google Sheet, read it, update values, find and replace text, format cells and read comments. Because it is also connected to your marketing accounts, it can fill the sheet for you:

-   "Every Monday, write last week's Google Ads and Meta Ads spend, Klaviyo email revenue and Shopify orders into the Weekly tab."
-   "Read our content calendar sheet, draft the posts due next week and schedule them."

On the entry plan Helena reads and reports on ads and email; creating or changing ad and email campaigns is on the Pro plan. It runs scheduled tasks and sends reports by email, or to Slack on the Pro plan. Image, video and audio generation are not available through the connector.

Plans start at $39/month with a 3-day free trial ([sign up](https://agent.enrichlabs.ai/marketing/register)). If you track campaigns in a base instead of a sheet, see our [Airtable MCP](/blog/airtable-mcp) guide. For traffic numbers, see the [Google Analytics MCP](/blog/google-analytics-mcp), or browse the [Best Claude Connectors for Marketing](/blog/best-claude-connectors-for-marketing).

## FAQ

### Is there a Google Sheets MCP server?

Yes. Google runs an official one, but as of November 2026 it is a developer preview that needs a Google Cloud project and membership in Google's preview program.

### Can Claude edit Google Sheets?

Yes. Claude's Google Sheets connector (in beta) edits sheets in a pane beside the chat, and Anthropic's add-on edits the sheet you have open. The Google Drive connector alone only reads sheets.

### How do I connect Claude to Google Sheets?

In a chat, click +, hover over Connectors, switch on Google Sheets, sign in with Google and paste your sheet's link. Or install the Claude add-on and open it from Extensions > Claude in Sheets.

### What is Claude for Sheets?

Anthropic's add-on that opens Claude in a sidebar inside Google Sheets, Docs and Slides. In Sheets it writes formulas, builds pivot tables and charts, and adds tabs. It is in beta on paid Claude plans.

### Can ChatGPT edit Google Sheets?

Yes. OpenAI's ChatGPT for Google Sheets add-on builds and updates sheets from a sidebar, and the Google Drive app can work with Sheets from the chat when your permissions and workspace allow edits.

### Can Claude or ChatGPT update my sheet every week on their own?

Not from inside the sheet. Anthropic says its add-on cannot create triggers or scheduled refreshes. Helena can write numbers from your connected ad, email and store accounts into a sheet on a schedule.

## The bottom line

Claude and ChatGPT can both read and edit Google Sheets with official tools, from the chat or from a sidebar in Sheets, with no developer needed. Start with the add-on for the assistant you already use, and keep edits on approval. If you want your reporting tab filled from your ads, email and store every week, use [Helena](/ai-marketing-agent).
