# Google Sheets MCP Server

> Search and inspect Google Sheets, create and edit spreadsheets, scan for data issues, review edit history, and manage comments.

- Price: Free to connect · provider's own fees apply
- URL: https://daas.listeningmind.ai/en/catalog/mcps/x-mcp-googlesheets
- Source: Smithery https://smithery.ai/server/googlesheets
- Rank this week: #12 (score 66)

## Install

```
npx -y @smithery/cli install googlesheets --client claude
```
- Remote: https://googlesheets.run.tools

## Tools (13)

- `Arcade_ListApps`: See the apps the current caller can act on and whether they are connected. Returns each app's id, name, connected state, and (when connected) the account it is connected as.
- `GoogleSheets_CheckSpreadsheetAccess`: Check whether this app can already read each of several spreadsheets, in one batched pre-flight call, before attempting to read them.
- `GoogleSheets_CommentOnSpreadsheet`: Create a comment on a spreadsheet, edit a comment's body, or resolve/reopen it.
- `GoogleSheets_CreateOrEditSpreadsheet`: Create a new spreadsheet or batch-edit an existing one. Omit spreadsheetid to create; provide it to edit.
- `GoogleSheets_DeleteComment`: Delete a comment from a spreadsheet. Only the comment's author can delete it (enforced by Google Drive); deleting marks the whole thread (the comment and its replies) as deleted.
- `GoogleSheets_GenerateGoogleFilePickerUrl`: Generate a URL where the user can grant this app access to spreadsheets. Opens Google's first-party Drive picker, filtered to Google Sheets, where the user browses and selects whic…
- `GoogleSheets_GetSpreadsheetEditHistory`: Report who edited a spreadsheet and when, from Google Drive revisions. Reports the "who" and "when" only — not which cells changed, and it can't revert.
- `GoogleSheets_InspectSpreadsheet`: Inspect a Google Sheets spreadsheet's structure or read a range of cells. Use the default 'structure' mode to understand a workbook cheaply before reading.
- `GoogleSheets_ListSpreadsheetComments`: List a spreadsheet's comment threads, or the full replies of a single comment.
- `GoogleSheets_ReplyToComment`: Add a reply to an existing comment on a spreadsheet. To resolve or reopen the comment instead, use commentonspreadsheet with a status.
- `GoogleSheets_ScanForDataIssues`: Deterministically flag 'weird'/bad cells in spreadsheet data. No LLM judgement: the same input always returns the same flags.
- `GoogleSheets_SearchSpreadsheets`: Searches for spreadsheets in the user's Google Drive based on the titles and content and returns the title, ID, and URL for each matching spreadsheet.
- `GoogleSheets_WhoAmI`: Get comprehensive user profile and Google Sheets environment information. This tool provides detailed information about the authenticated user including their name, email, profile…

## FAQ

### What is the Google Sheets MCP Server?

Search and inspect Google Sheets, create and edit spreadsheets, scan for data issues, review edit history, and manage comments. It is listed on Smithery and ranks #12 (score 66) in ListeningMind.AI's weekly picks.

### How do I install the Google Sheets MCP Server?

Run npx -y @smithery/cli install googlesheets --client claude in a terminal to add it to Claude Desktop. For Cursor, use --client cursor.

### Do I need an API key?

The provider lists no required settings.

### Which tools does it provide?

13 tools: Arcade_ListApps, GoogleSheets_CheckSpreadsheetAccess, GoogleSheets_CommentOnSpreadsheet, GoogleSheets_CreateOrEditSpreadsheet, GoogleSheets_DeleteComment, GoogleSheets_GenerateGoogleFilePickerUrl, GoogleSheets_GetSpreadsheetEditHistory, GoogleSheets_InspectSpreadsheet, GoogleSheets_ListSpreadsheetComments, GoogleSheets_ReplyToComment, GoogleSheets_ScanForDataIssues, GoogleSheets_SearchSpreadsheets.

### How much does it cost?

Free to connect · provider's own fees apply. The provider may charge for use on its own terms.

### Can I trust it?

Checks passed: Verified at the source, Live endpoint, Clear description. Skim a server or repository you have not used before connecting it.