Skip to content
Back to search

sheets-mcp

A general-purpose MCP server for Google Sheets

Safety scan

A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.

Checked today

Check it deeper on your machine

It has changed since its scan on 19 Nov 2026.

As a Claude Code plugin, install it and then ask Claude Code:

/plugin marketplace add keithmackay/mackayi/plugin install scanskillsafety@mackayiDo a deep scan of https://github.com/bissli/sheets-mcp with scanskillsafety

Or from a terminal, clone it and run it:

git clone https://github.com/keithmackay/scanskillsafety-skill ~/.claude/skills/scanskillsafetynode ~/.claude/skills/scanskillsafety/cli.cjs --deep 'https://github.com/bissli/sheets-mcp'

It checks the exact commit: every file, its packages against OSV (api.osv.dev), how it compares with this page's scan (findsafeskills.com receives the repository's address), and, if you agree, Claude reading every file with your own Claude subscription. It never runs the code.

Badge for your README
findsafeskills safety rating

Markdown

[![findsafeskills safety rating](/api/listings/bissli--sheets-mcp/badge.svg)](/listings/bissli--sheets-mcp)

HTML

<a href="/listings/bissli--sheets-mcp"><img src="/api/listings/bissli--sheets-mcp/badge.svg" alt="findsafeskills safety rating" /></a>

Install

i

Install instructions from the README

As written by the repo's author. findsafeskills has not verified these steps.

pipx install 'sheets-mcp[server] @ git+https://github.com/bissli/sheets-mcp'

Without the `server` extra, the package installs as a library with no `mcp` dependency: every module but `sheets_mcp.server` and `sheets_mcp.__main__` imports.

What was scanned

The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.

README.md · README · 109 lines
  1. # sheets-mcp
  2. A general-purpose [MCP](https://modelcontextprotocol.io) server for Google
  3. Sheets. It lets an MCP client such as Claude find, create, copy, move,
  4. share, import, export and delete spreadsheets; add, edit, copy and delete
  5. tabs; read, write, append and clear values; insert, move, resize and delete
  6. rows and columns; and format cells.
  7. ## Tools
  8. | Object | Tools |
  9. | -------------- | ----------------------------------------------------------------------------------------------------- |
  10. | Files | `list_files`, `create_spreadsheet`, `copy_spreadsheet`, `update_file`, `delete_file`, `create_folder` |
  11. | Sharing | `share_file`, `list_permissions` |
  12. | Import, export | `import_file`, `export_spreadsheet` |
  13. | Tabs | `describe_spreadsheet`, `add_tab`, `edit_tab`, `copy_tab`, `delete_tab` |
  14. | Values | `read_range`, `write_ranges`, `append_rows`, `clear_ranges` |
  15. | Rows, columns | `edit_rows_columns`, `delete_rows_columns` |
  16. | Formatting | `format_range` |
  17. Each tool carries MCP annotations. The four read tools are marked
  18. read-only, and every tool that overwrites or removes data is marked
  19. destructive, so a client can ask before running one.
  20. ## Installation
  21. ```
  22. pipx install 'sheets-mcp[server] @ git+https://github.com/bissli/sheets-mcp'
  23. ```
  24. Without the `server` extra, the package installs as a library with no
  25. `mcp` dependency: every module but `sheets_mcp.server` and
  26. `sheets_mcp.__main__` imports.
  27. ## Credentials
  28. The server reads one of three kinds of Google credentials:
  29. - **Application Default Credentials.** With no `--credentials` flag, the
  30. server uses the account set by
  31. `gcloud auth application-default login --scopes=https://www.googleapis.com/auth/spreadsheets,https://www.googleapis.com/auth/drive,https://www.googleapis.com/auth/cloud-platform`.
  32. - **A personal Google account.** A Desktop app OAuth client from the Google
  33. Cloud console, with the Sheets and Drive APIs enabled.
  34. `sheets-mcp login client.json` runs the browser consent once and stores
  35. the token in `~/.config/sheets-mcp/token.json`. The server then runs
  36. with `--credentials client.json`.
  37. - **A service account.** `--credentials key.json` with the account's key
  38. file. A service account sees only the files shared with its email
  39. address, and has no My Drive storage, so it creates files in a shared
  40. drive folder.
  41. The server asks for the `spreadsheets` and `drive` scopes. Moving, sharing
  42. and deleting any file the account can reach needs the full Drive scope.
  43. ## Client setup
  44. Claude Code:
  45. ```
  46. claude mcp add sheets -- sheets-mcp --credentials ~/client.json
  47. ```
  48. Claude Desktop, in `claude_desktop_config.json`:
  49. ```json
  50. {
  51. "mcpServers": {
  52. "sheets": {
  53. "command": "sheets-mcp",
  54. "args": ["--credentials", "/home/ana/client.json"]
  55. }
  56. }
  57. }
  58. ```
  59. `--read-only` serves only the four read tools.
  60. ## Safety
  61. - `delete_file` moves a file to the trash. Only `permanent=true` deletes
  62. it beyond recovery.
  63. - A written value that Sheets would parse as a formula may not call
  64. IMPORTXML, IMPORTHTML, IMPORTDATA, IMPORTFEED, IMPORTRANGE or IMAGE.
  65. Those functions fetch a URL, so a prompt injection could use them to
  66. send cell contents to a third party. `copy_tab` applies the same check
  67. to a tab it copies into another spreadsheet.
  68. - The check closes only that channel. Any write or copy into a file or
  69. folder someone else can read shows them the data, so a client should
  70. confirm write tools whose target it did not choose.
  71. - `read_range` answers in pages of at most 60 KB, with `next_offset` for
  72. the next page.
  73. - `export_spreadsheet` keeps an existing local file unless the call sets
  74. `overwrite=true`.
  75. - The server runs over stdio only, so no network port exposes the
  76. account.
  77. ## Development
  78. ```
  79. poetry install --with test --extras server
  80. poetry run pytest
  81. ```
  82. The tests run against an in-memory fake of the Drive and Sheets APIs in
  83. `tests/fake_google.py` and make no network calls.
  84. ## License
  85. MIT

Ratings and comments

Sign in to rate this skill.

Sign in

Free to use. If it’s helped, pass it on.