{"_id":"@arthur_kim/google-sheets-mcp","name":"@arthur_kim/google-sheets-mcp","dist-tags":{"latest":"1.0.0"},"versions":{"1.0.0":{"name":"@arthur_kim/google-sheets-mcp","version":"1.0.0","description":"MCP server for Google Sheets API with read/write capabilities - Claude Desktop integration","main":"index.js","type":"module","bin":{"google-sheets-mcp":"index.js"},"scripts":{"start":"node index.js","dev":"node --watch index.js"},"keywords":["mcp","model-context-protocol","google-sheets","spreadsheet","api","claude","claude-desktop","ai","sheets-api"],"author":{"name":"arthur_kim","email":"kun10191@gmail.com"},"license":"MIT","repository":{"type":"git","url":"git+https://github.com/arthur_kim/google-sheets-mcp.git"},"bugs":{"url":"https://github.com/arthur_kim/google-sheets-mcp/issues"},"homepage":"https://github.com/arthur_kim/google-sheets-mcp#readme","dependencies":{"@modelcontextprotocol/sdk":"^1.0.4","googleapis":"^144.0.0","dotenv":"^16.4.7"},"engines":{"node":">=18.0.0"},"_id":"@arthur_kim/google-sheets-mcp@1.0.0","_nodeVersion":"22.16.0","_npmVersion":"11.5.1","dist":{"integrity":"sha512-pkP6R4VIHsE7D9fpwWULsuwazHXHi0NzZgDyd49hSDZtBD2kAV42RwH1pWteMMnZRwmeYMVnZ6SCnwDdZFVj6A==","shasum":"57f8b09e732b28275d6ff1cbeca2ba831c4d27a3","tarball":"https://registry.npmjs.org/@arthur_kim/google-sheets-mcp/-/google-sheets-mcp-1.0.0.tgz","fileCount":7,"unpackedSize":27819,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCICDbxYYjg4Xlv/jJYHV+n2go4ke8IF4XSxbC/l62m6nqAiEAuIzIsUcrjm+t/rNC3ZXWRauhfdLmA300iou+RcgydoA="}]},"_npmUser":{"name":"arthur_kim","email":"kun10191@gmail.com"},"directories":{},"maintainers":[{"name":"arthur_kim","email":"kun10191@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/google-sheets-mcp_1.0.0_1768900966022_0.2510742834782116"},"_hasShrinkwrap":false}},"time":{"created":"2026-01-20T09:22:45.922Z","1.0.0":"2026-01-20T09:22:46.173Z","modified":"2026-01-20T09:22:46.395Z"},"maintainers":[{"name":"arthur_kim","email":"kun10191@gmail.com"}],"description":"MCP server for Google Sheets API with read/write capabilities - Claude Desktop integration","homepage":"https://github.com/arthur_kim/google-sheets-mcp#readme","keywords":["mcp","model-context-protocol","google-sheets","spreadsheet","api","claude","claude-desktop","ai","sheets-api"],"repository":{"type":"git","url":"git+https://github.com/arthur_kim/google-sheets-mcp.git"},"author":{"name":"arthur_kim","email":"kun10191@gmail.com"},"bugs":{"url":"https://github.com/arthur_kim/google-sheets-mcp/issues"},"license":"MIT","readme":"# Google Sheets MCP Server\n\n[![npm version](https://badge.fury.io/js/%40arthur_kim%2Fgoogle-sheets-mcp.svg)](https://www.npmjs.com/package/@arthur_kim/google-sheets-mcp)\n[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/MIT)\n\nModel Context Protocol (MCP) server for seamless Google Sheets integration with Claude Desktop and other MCP clients.\n\n## ✨ Features\n\n- 📖 **Read** spreadsheet data with A1 notation\n- ✍️ **Write** data to specific cells or ranges\n- ➕ **Append** new rows to spreadsheets\n- 📝 **Update** spreadsheet titles\n- ℹ️ **Get** spreadsheet metadata and information\n- 🔐 Secure OAuth 2.0 authentication\n- 🚀 Easy setup with environment variables\n\n## 📦 Installation\n\n### NPM (Recommended)\n\n```bash\nnpm install -g @arthur_kim/google-sheets-mcp\n```\n\n### Manual Installation\n\n```bash\ngit clone https://github.com/arthur_kim/google-sheets-mcp.git\ncd google-sheets-mcp\nnpm install\n```\n\n## 🚀 Quick Start\n\n### 1. Google Cloud Setup\n\n1. Go to [Google Cloud Console](https://console.cloud.google.com/)\n2. Create a new project or select existing one\n3. Enable **Google Sheets API**\n4. Create **OAuth 2.0 Client ID** (Desktop App)\n5. Download credentials\n\n### 2. Get OAuth Credentials\n\nSet up environment variables with your Google OAuth credentials:\n\n```bash\nexport GOOGLE_CLIENT_ID=\"your-client-id.apps.googleusercontent.com\"\nexport GOOGLE_CLIENT_SECRET=\"your-client-secret\"\n```\n\n### 3. Configure Claude Desktop\n\nAdd to your Claude Desktop config file:\n\n**macOS**: `~/Library/Application Support/Claude/claude_desktop_config.json`\n**Windows**: `%APPDATA%\\Claude\\claude_desktop_config.json`\n\n```json\n{\n  \"mcpServers\": {\n    \"google-sheets\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"@arthur_kim/google-sheets-mcp\"],\n      \"env\": {\n        \"GOOGLE_CLIENT_ID\": \"your-client-id.apps.googleusercontent.com\",\n        \"GOOGLE_CLIENT_SECRET\": \"your-client-secret\"\n      }\n    }\n  }\n}\n```\n\n### 4. Restart Claude Desktop\n\nRestart Claude Desktop to apply the configuration.\n\n## 💡 Usage Examples\n\nOnce configured, you can interact with Google Sheets naturally in Claude:\n\n### Read Spreadsheet\n```\n\"Read data from spreadsheet 1nOFeUYjxOQClms8dP8Sz8XuGlEocorYi5injSS0MFlY, range Sheet1!A1:D10\"\n```\n\n### Update Title\n```\n\"Change the title of spreadsheet 1nOFeUYjxOQClms8dP8Sz8XuGlEocorYi5injSS0MFlY to 'Q1 Sales Report'\"\n```\n\n### Write Data\n```\n\"Write 'New Value' to cell A1 in Sheet1\"\n```\n\n### Append Rows\n```\n\"Add a new row to Sheet1 with values: ['John', 'Doe', '30', 'Engineer']\"\n```\n\n### Get Metadata\n```\n\"Get information about spreadsheet 1nOFeUYjxOQClms8dP8Sz8XuGlEocorYi5injSS0MFlY\"\n```\n\n## 🔧 Available Tools\n\n| Tool | Description |\n|------|-------------|\n| `sheets_read` | Read data from a spreadsheet range |\n| `sheets_write` | Write data to specific cells |\n| `sheets_append` | Append rows to a spreadsheet |\n| `sheets_update_title` | Update spreadsheet title |\n| `sheets_get_info` | Get spreadsheet metadata |\n\n## 📚 Documentation\n\nFor detailed setup instructions, see:\n- [SETUP_GUIDE.md](./SETUP_GUIDE.md) - Complete setup guide\n- [QUICKSTART.md](./QUICKSTART.md) - Quick start tutorial\n\n## 🐛 Troubleshooting\n\n### Authentication Issues\n- Verify OAuth credentials in environment variables\n- Ensure Google Sheets API is enabled in Google Cloud Console\n- Check that OAuth consent screen is configured\n\n### Connection Issues\n- Restart Claude Desktop completely\n- Check MCP server logs in Claude Desktop\n- Verify `claude_desktop_config.json` syntax\n\n### Permission Errors\n- Ensure required scope is authorized: `https://www.googleapis.com/auth/spreadsheets`\n- Re-authenticate if permissions were changed\n\n## 🤝 Contributing\n\nContributions are welcome! Please feel free to submit a Pull Request.\n\n## 📄 License\n\nMIT License - see LICENSE file for details\n\n## 🔗 Links\n\n- [Google Sheets API v4](https://developers.google.com/sheets/api/reference/rest)\n- [Model Context Protocol](https://modelcontextprotocol.io/)\n- [OAuth 2.0 Documentation](https://developers.google.com/identity/protocols/oauth2)\n\n## 👨‍💻 Author\n\narthur_kim\n","readmeFilename":"README.md","_rev":"1-89b9a4a8d4cd0f875d0831e667c0bc64"}