PlugWiki
Google Sheets logo

Google Sheets MCP servers: which one to use

Use Google's own Sheets server if you are in its preview. Otherwise pick mcp-google-sheets (service account) or google_workspace_mcp (adds Gmail, Drive).

Servers
32
active
Hosted
10
nothing to install
Local
17
runs on your machine

Google publishes a hosted Sheets MCP server, but it is a Developer Preview and needs a Google Cloud project and your own OAuth client. If that is too much setup, community servers run on your computer and use a service account or a Google sign-in. Whichever you pick, the assistant can edit any sheet it can reach. Share only the spreadsheets it needs with the service account, or use a read-only scope.

Good for

  • Anyone who wants Claude to answer questions from a spreadsheet
  • Teams who want an assistant to append rows or update a tracker
  • Google Workspace admins already in Google's Developer Preview program
  • People who also need Gmail, Drive and Calendar in the same server

Which Google Sheets MCP server to use

Use Google's server if you are in the Developer Preview and want no third-party code. Otherwise pick mcp-google-sheets for the simplest service-account setup, or google_workspace_mcp when you also need Gmail, Drive and Calendar.

ServerOfficialRunsSign-inRead-only optionGitHub stars
For Google Sheets
Google Sheets MCPThis pageOfficialHostedGoogle OAuthRead-only scope–
mcp-google-sheetsCommunityLocalService account–1K
mcp-gsheetsCommunityLocalService account–104
Google Sheets (domdomegg)CommunityLocalGoogle OAuth–2
Other tools for the same job
google_workspace_mcpCommunityLocalGoogle OAuthFlag3.5K

All Google Sheets MCP servers

32 active · official first, then by GitHub stars

Show all 32

Questions

Is there an official Google Sheets MCP server?

Yes. Google runs a hosted Google Sheets MCP server at https://sheetsmcp.googleapis.com/mcp/v1. It is part of the Google Workspace Developer Preview Program, so you need to be a member.

What do I need to set up Google's Sheets server?

A Google Cloud project with the Sheets API and the Sheets MCP API turned on, plus an OAuth consent screen and OAuth client you create yourself. Google's page walks through each step.

Can I make it read-only?

Yes for Google's server. Its docs list a read-only Sheets scope next to the read-write one, so you can grant only the read scope. google_workspace_mcp also has a --read-only option.

Does it work in Claude?

Yes. Google's docs name Claude as a client for the Workspace MCP servers. google_workspace_mcp documents Claude Desktop connectors and Claude Code, and mcp-gsheets documents Claude Code, Claude Desktop and Cursor.

Does it work in ChatGPT?

Only google_workspace_mcp documents ChatGPT, through Developer Mode.

Service account or Google sign-in?

With a service account, the assistant only sees sheets you share with that account's email, which limits what it can reach. A Google sign-in acts as you, so it can reach everything you can. mcp-google-sheets recommends the service account route.

Can it delete or overwrite my data?

Yes. These servers write cells, add and remove sheets, and share files, so a wrong prompt can overwrite data. Keep a copy of important sheets and use a read-only scope when you only need answers.

Which server has the most tools?

google_workspace_mcp lists more than 120 tools across twelve Google services. mcp-gsheets lists 44 Sheets tools and mcp-google-sheets lists 19. Fewer tools use less of the assistant's working memory.

Are the community servers free?

Yes, the software is free. google_workspace_mcp, mcp-google-sheets and mcp-gsheets are MIT-licensed on GitHub, and google-sheets-mcp declares MIT in its package.json. You still need your own Google Cloud project and credentials.

Server facts from the official MCP registry, GitHub, npm, PyPI and the Docker catalog. Archived servers are not listed.