
How to Connect Claude to Google Sheets (and Is It Safe?)
Claude edits Google Sheets through a connector beside the chat or a sidebar (beta) inside Sheets. Google Drive lets it read sheets too.
To use Claude with Google Sheets, turn on the Google Sheets connector from the + menu in a chat and sign in with Google. Claude opens your sheet in a pane beside the chat and edits it live while you keep working in it.
It works in Claude on the web in Chrome, and in Claude Desktop with the built-in browser on. The Google Drive connector reads sheets as plain CSV text, with every tab included.
Know this first: Claude can change any sheet your Google account can open, so check what it did before you share the file.
Good for
- People who want Claude to fill in and clean up a tracker, budget or report in Sheets
- Anyone who wants Claude to find the right sheet in Drive and summarize it
- Team and Enterprise Owners deciding whether to turn on Google connectors
- Developers who need cell-level access through an MCP server
Install Claude
Claude app
- 1
In Claude on the web (in Chrome) or Claude Desktop, open a chat and select + at the lower left of the message box.
- 2
Hover over Connectors and turn on Google Sheets. If it is not connected yet, Claude prompts you to sign in to Google.
- 3
Paste a Google Sheets link, or ask Claude to create a Google sheet by name.
- 4
The sheet opens in a pane beside the chat. Claude edits it live while you keep working in it.
- 5
On Claude Desktop, turn on the built-in browser and sign in to Google in the pane.
Requires A Claude account and a Google account, Team or Enterprise: an Owner enables Google connectors first.
Read-only mode: There is no read-only switch. Under Customize > Connectors > Tool permissions, set tools that change files to Needs approval or Blocked. With Google's server, grant only the read-only Sheets scope.
Anthropic offers three routes. The Google Sheets connector opens the sheet in a pane beside the chat at claude.ai. The Claude for Google Workspace sidebar (beta) runs inside Docs, Sheets and Slides and works only on the open file. The Drive connector reads sheets. Google's preview server suits you only if you want scripted access with your own sign-in client.
From the vendor's docs. Source.
Connect Google and edit your first sheet with Claude
Claude
- 1
Check where you are working
Use Claude on the web in Chrome, or Claude Desktop with the built-in browser on. On Team and Enterprise, an Owner or Primary Owner enables the Google connectors first.
- 2
Turn on Google Sheets
In a chat, select + at the lower left, hover over Connectors and turn on Google Sheets. If it is not connected, Claude prompts you to sign in to Google.
- 3
Open a sheet
Paste a Google Sheets link, or ask for a new Google sheet by name. If you ask for a spreadsheet without saying Google, Claude makes a file to download instead.
- 4
Ask for a change
The sheet opens in a pane next to the chat and you can keep working in it while Claude edits.
PromptIn the 'Q3 tracker' sheet, add a Status column and mark every row with a past due date as Overdue. - 5
Read a sheet instead
With Google Drive connected, select + > Add from Google Drive and pick the file. Claude receives it as CSV with every tab. Over about 10 MB, it gets only the name and details.
PromptRead the Q3 budget spreadsheet and tell me which lines are over plan. - 6
Find a file first
Drive search lists recent files and who they are shared with.
PromptWhat files have I worked on in the last week?Tip: Drive connector tools that share, move or trash files ask for your approval by default. Keep that on.
Permissions
Medium risk
Claude can read any file your Google account can open and edit any sheet you point it at, and the Drive tools can also share, move and trash files. Keep the approval prompts on, and keep a copy of sheets you care about.
What it can do
- Read your data
- Create and change things
- Delete things
- Read-only mode
Watch out for
Claude can change any sheet you can open
It edits live, and you can work in the same file at the same time. Check the changes before you share the sheet, and keep a copy of anything important. support.claude.com
It can read every file your account reaches
Google sharing rules apply, but that is your whole Drive, not one sheet. What Claude reads goes into the chat and is stored with it on Anthropic servers. support.claude.com
Drive tools can share, move and trash files
Anthropic says Claude asks for your approval before each of these actions by default. Our advice: do not choose Always allow for these, and on Team and Enterprise ask your Owner how approvals are set. support.claude.com
Server tools can overwrite or delete data
Google's preview server can write to cells when you grant the read-write Sheets scope. Our server pages say google_workspace_mcp can delete files and events and mcp-google-sheets can delete rows and columns. Keep a copy of important sheets. developers.google.com
Google may block Claude until an admin allows it
If you see Access blocked, your Google Workspace admin has to mark Claude as a trusted app in the Admin console. support.claude.com
Security advisories
No published security advisories as of Nov 3, 2026.
Technical details
| Turning on read-only | There is no read-only switch. Set write tools to Needs approval or Blocked under Customize > Connectors > Tool permissions. With Google's Sheets server, grant only the read-only scope. |
|---|---|
| Talks to | Google's Drive and Sheets services. Anthropic, which receives the file content Claude reads |
| Sign-in and keys | You sign in with Google. Claude keeps the connection until you select Disconnect or remove its access in your Google Account. |
| Data retention | Data Claude retrieves is stored on Anthropic servers with its chat, so deleting the chat deletes it. |
Where it works
| Where | Status | Note |
|---|---|---|
| Claude on the web | Native connector | Google Sheets connector opens the sheet in a pane. Needs Chrome. Google Drive reads sheets. |
| Claude desktop app | Native connector | Same connector. Turn on the built-in browser and sign in to Google in the pane. |
| Claude for Google Workspace sidebar (beta) | Official app | Runs inside Docs, Sheets and Slides. Pro, Max, Ultra, Team or Enterprise. Not in Firefox. |
| Google's Sheets MCP server | Official server | Hosted by Google as a custom connector. Developer Preview only; needs your own Cloud project. |
| google_workspace_mcp (community) | Community server | Runs on your computer. Covers Sheets, Gmail, Drive, Calendar and more; has a read-only option. |
| mcp-google-sheets (community) | Community server | Runs on your computer with a service account, so it sees only sheets you share with it. |
| ChatGPT for Google Sheets | Official app | Install from the Google Workspace Marketplace, then open it from Extensions. Free, Go, Plus, Pro, Business, Enterprise and Edu plans. |
Top picks
Ranked by GitHub stars.
- 1
google_workspace_mcpLocalOAuthEdits Sheets and also reaches Gmail, Drive, Calendar and Docs. It has 113 tools, so turn on read-only mode or pick a few services.
3,451 GitHub stars - 2
mcp-google-sheetsLocaltoken in envReads, writes and charts in Sheets. A service account keeps it to the sheets you share, but it has no read-only switch.
1,016 GitHub stars
Verdict
Our advice: use the Google Sheets connector for most work; it needs Chrome or Claude Desktop and can change any sheet you can open. To stay inside Sheets, try the beta sidebar, which touches only the open file. Use a server only for scripted work.
Our pick: Claude
Use Claude's Google Sheets connector for most work: it edits live beside the chat and needs only a Google sign-in. It needs Chrome or Claude Desktop and can change any sheet you can open.
MoreLess
Pick a server only for scripted work or a service account limited to shared sheets.
Best for
- Cleaning up and filling in a tracker or budget
- Reading a sheet and summarizing it
- Working in the same file at the same time as Claude
Skip it if
- You cannot use Chrome or Claude Desktop (the connector pane), or Firefox (the sidebar)
- You do not want an AI to change sheets you can open
- You need Claude to reach only one named sheet: the sidebar works only on the open file
Questions
Can Claude edit Google Sheets?
Yes. Turn on the Google Sheets connector in a chat and Claude opens the sheet in a pane beside the chat and edits it live. It works in Claude on the web in Chrome and in Claude Desktop with the built-in browser on.
How do I connect Claude to Google Sheets?
In a chat, select + at the lower left, hover over Connectors and turn on Google Sheets. Sign in to Google when Claude asks. The setup box above has the steps.
Can Claude read a Google Sheet without editing it?
Yes. Connect Google Drive and add the sheet with Add from Google Drive. Claude receives it as CSV with every tab. Google caps exports at about 10 MB, and over that Claude gets only the name and details.
Is there a Claude add-on inside Google Sheets?
Yes, in beta. Claude for Google Workspace adds a Claude sidebar to Docs, Sheets and Slides under Extensions > Claude, for Pro, Max, Ultra, Team and Enterprise plans. It works only on the file you open it in and does not run in Firefox.
Can Claude also work with Google Docs?
Yes. Turn on the Google Docs connector to edit Docs live, and Claude can read comments and suggestions in Docs. Claude can read Slides through Drive, but it cannot add charts to Slides.
Which Claude plans can use the Google connectors?
Anthropic says the Google Workspace connectors are available for all users on Claude and Claude Desktop. On Team and Enterprise, an Owner or Primary Owner must enable them for the organization first.
Why does it say access blocked by my admin?
Your Google Workspace admin has to set Claude as a trusted app in the Admin console under Security > Access and data control > API controls > Manage third-party app access. Anthropic says the policy takes about 15 minutes to apply.
Does Anthropic train on my Google Drive data?
Anthropic says it does not train its models on Gmail, Drive or Calendar connector data. Content you copy and paste from them into chats may be used if you allowed chat training on a consumer plan.
How do I disconnect Google from Claude?
Go to Customize > Connectors, select the Google connector and choose Disconnect. If it still has trouble, remove Claude at myaccount.google.com/connections.
Is there a Google Sheets MCP server instead?
Yes. Google runs a hosted Sheets server in its Developer Preview, and community servers such as google_workspace_mcp and mcp-google-sheets run on your computer. See the Google Sheets MCP server comparison.
Information
updated Nov 3, 2026
- Made by
- Anthropic
- Connector directory
- claude.ai/directory
Sources
Docs, issue trackers and discussions this page is built from.
Show all 7Hide
- Use Google Workspace connectors · support.claude.com
- Google Drive connector · claude.com
- Configure Google Workspace MCP servers · developers.google.com
- Use Claude in Google Docs, Sheets, and Slides · support.claude.com
- mcp-google-sheets · github.com
- google_workspace_mcp · github.com
- ChatGPT for Excel and Google Sheets · help.openai.com