Skip to content
Back to search

google-sheets-mcp

Google Sheets MCP Server 📊🤖

Safety scan

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

Checked today
Badge for your README
findsafeskills safety rating

Markdown

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

HTML

<a href="/listings/mkummer225--google-sheets-mcp"><img src="/api/listings/mkummer225--google-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.

1. Clone this repository:

git clone https://github.com/mkummer225/google-sheets-mcp
cd google-sheets-mcp

2. Install dependencies: `npm install`

3. Build: `npm run build`

4. Create OAuth credentials in Google Cloud Platform: - Create a new project in [Google Cloud Console](https://console.cloud.google.com/) - Enable the [Google Sheets API](https://console.cloud.google.com/marketplace/product/google/sheets.googleapis.com) - Configure the OAuth consent screen - Create OAuth client ID credentials (Desktop application) with an appropriate redirect URI (ex: http://localhost:3000/oauth2callback) - Download the credentials and save as `gcp-oauth.keys.json` in the `dist` subdirectory

5. Start the MCP server (you'll automatically be prompted to authenticate/re-authenticate your Google account when necessary): `npm run start`

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 · 79 lines

View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)

  1. # Google Sheets MCP
  2. A Model Context Protocol (MCP) connector for Google Sheets that allows AI agents to interact with spreadsheets directly.
  3. ## Demo
  4. https://github.com/user-attachments/assets/cc4729d9-4e6e-437b-848b-6da9a09418c3
  5. ## Setup
  6. 1. Clone this repository:
  7. ```bash
  8. git clone https://github.com/mkummer225/google-sheets-mcp
  9. cd google-sheets-mcp
  10. ```
  11. 2. Install dependencies:
  12. `npm install`
  13. 3. Build:
  14. `npm run build`
  15. 4. Create OAuth credentials in Google Cloud Platform:
  16. - Create a new project in [Google Cloud Console](https://console.cloud.google.com/)
  17. - Enable the [Google Sheets API](https://console.cloud.google.com/marketplace/product/google/sheets.googleapis.com)
  18. - Configure the OAuth consent screen
  19. - Create OAuth client ID credentials (Desktop application) with an appropriate redirect URI (ex: http://localhost:3000/oauth2callback)
  20. - Download the credentials and save as `gcp-oauth.keys.json` in the `dist` subdirectory
  21. 5. Start the MCP server (you'll automatically be prompted to authenticate/re-authenticate your Google account when necessary):
  22. `npm run start`
  23. ## Usage
  24. Sample config:
  25. ```json
  26. {
  27. "mcpServers": {
  28. "google-sheets-mcp": {
  29. "command": "node",
  30. "args": [
  31. "/{path_to_dir}/google-sheets-mcp/dist/index.js"
  32. ]
  33. }
  34. }
  35. }
  36. ```
  37. Then you should be able to simply specify your spreadsheetId or ask your agent to create a new one for you.
  38. ## Available Actions
  39. | Action | Description |
  40. |--------|-------------|
  41. | `refresh_auth` | Re-authenticate your Google Account when credentials expire |
  42. | `list_sheets` | List all sheets/tabs in a Google Spreadsheet |
  43. | `create_sheet` | Create a new sheet/tab in a Google Spreadsheet |
  44. | `create_spreadsheet` | Create a new Google Spreadsheet |
  45. | `read_all_from_sheet` | Read all data from a specified sheet |
  46. | `read_headings` | Read the column headings from a sheet |
  47. | `read_rows` | Read specific rows from a sheet |
  48. | `read_columns` | Read specific columns from a sheet |
  49. | `edit_cell` | Edit a single cell in a sheet |
  50. | `edit_row` | Edit an entire row in a sheet |
  51. | `edit_column` | Edit an entire column in a sheet |
  52. | `insert_row` | Insert a new row at specified position |
  53. | `insert_column` | Insert a new column at specified position |
  54. | `rename_sheet` | Rename a sheet/tab in a spreadsheet |
  55. | `rename_doc` | Rename a Google Spreadsheet |
  56. ## License
  57. MIT

Ratings and comments

Sign in to rate this skill.

Sign in

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