{
  "markdown": "# google-sheets-mcp\n\nMCP server for Google Sheets - read, write, and query spreadsheet data.\n\n## Use Cases\n\n**Data questions**: \"How many open deals are in the pipeline?\" or \"What's our total Q3 revenue?\" → reads the spreadsheet and answers directly.\n\n**Quick expense entry**: Snap a photo of a receipt → extracts the details and appends a row to your expense tracker.\n\n**Cross-tool status sync**: \"Check all our vendor Slack channels and update the tracking spreadsheet with their latest updates\" → reads Slack, updates the sheet.\n\n**Data analysis**: \"Break down the Salesforce figures by region and compare against our events calendar\" → pulls data from multiple sources into a spreadsheet for analysis.\n\n(These are just examples - any workflow that needs spreadsheet data can use this. Use in combination with [google-drive-mcp](https://github.com/domdomegg/google-drive-mcp) for finding files, deleting, comments, and sharing permissions.)\n\n## Setup\n\n### 1. Create Google OAuth credentials\n\n1. Go to [Google Cloud Console](https://console.cloud.google.com/)\n2. Create a new project (or use existing)\n3. Enable the Google Sheets API\n4. Go to **APIs & Services** → **OAuth consent screen**, set up consent screen\n5. Go to **APIs & Services** → **Credentials** → **Create Credentials** → **OAuth client ID**\n6. Choose **Web application**\n7. Add `http://localhost:3000/callback` to **Authorized redirect URIs**\n8. Note your Client ID and Client Secret\n\n### 2. Run the server\n\n```bash\nGOOGLE_CLIENT_ID='your-client-id' \\\nGOOGLE_CLIENT_SECRET='your-client-secret' \\\nMCP_TRANSPORT=http \\\nnpm start\n```\n\nThe server runs on `http://localhost:3000` by default. Change with `PORT=3001`.\n\n### 3. Add to your MCP client\n\nWith the server running, follow the instructions on [install-mcp](https://adamjones.me/install-mcp/?url=http://localhost:3000/mcp), which generates the right config for your MCP client (Claude Code, Claude Desktop, Cursor, Cline, VS Code, and more).\n\n## Architecture\n\nThis server acts as an **OAuth proxy** to Google:\n\n```mermaid\ngraph LR\n    A[MCP client] <--> B[google-sheets-mcp] <--> C[Google OAuth/API]\n```\n\n1. Server advertises itself as an OAuth authorization server via `/.well-known/oauth-authorization-server`\n2. `/register` returns the Google OAuth client credentials\n3. `/authorize` redirects to Google, encoding the client's callback URL in state\n4. `/callback` receives the code from Google and forwards to the client's callback\n5. `/token` proxies token requests to Google, injecting client credentials\n6. `/mcp` handles MCP requests, using the bearer token to call Google Sheets API\n\nThe server holds no tokens or state - it just proxies OAuth to Google.\n\n## Tools\n\n| Tool | Description |\n|------|-------------|\n| **Spreadsheet** | |\n| `sheets_spreadsheet_get` | Get spreadsheet metadata (title, sheets list, optionally cell data) |\n| `sheets_spreadsheet_create` | Create a new spreadsheet |\n| **Values** | |\n| `sheets_values_get` | Read cell values from a range |\n| `sheets_values_batch_get` | Read cell values from multiple ranges |\n| `sheets_values_update` | Write cell values to a range (overwrites) |\n| `sheets_values_batch_update` | Write cell values to multiple ranges |\n| `sheets_values_append` | Append rows after existing data |\n| `sheets_values_clear` | Clear cell values from a range |\n| **Sheets (tabs)** | |\n| `sheets_sheets_list` | List all sheets in a spreadsheet |\n| `sheets_sheet_add` | Add a new sheet (tab) |\n| `sheets_sheet_delete` | Delete a sheet (tab) |\n| **Advanced** | |\n| `sheets_batch_update` | Execute batch operations (formatting, merging, filters, etc.) |\n\n## Google Sheets API Scope\n\n- `spreadsheets` - Full read/write access to spreadsheets\n\n## Contributing\n\nPull requests are welcomed on GitHub! To get started:\n\n1. Install Git and Node.js\n2. Clone the repository\n3. Install dependencies with `npm install`\n4. Run `npm run test` to run tests\n5. Build with `npm run build`\n\n## Releases\n\nVersions follow the [semantic versioning spec](https://semver.org/).\n\nTo release:\n\n1. Use `npm version <major | minor | patch>` to bump the version\n2. Run `git push --follow-tags` to push with tags\n3. Wait for GitHub Actions to publish to the NPM registry.\n",
  "bytes": 4205,
  "sha": "c0772e92ad11eb336817d5ada7b6361d4e50352f360bac0da99c03738fdbb0ca",
  "repo_slug": "domdomegg/google-sheets-mcp",
  "fonte": "repo",
  "truncated": false,
  "api": "https://agentalog.com/api/listings/mcp_io_github_domdomegg_google_sheets_mcp_c081e02f/readme"
}