{"_id":"@shivaduke28/google-sheets-mcp","_rev":"7-8c09cb5f23bea7e99491e0f9674d431d","name":"@shivaduke28/google-sheets-mcp","dist-tags":{"latest":"1.3.0"},"versions":{"1.0.0":{"name":"@shivaduke28/google-sheets-mcp","version":"1.0.0","keywords":["mcp","google-sheets","model-context-protocol"],"author":{"name":"shivaduke"},"license":"ISC","_id":"@shivaduke28/google-sheets-mcp@1.0.0","maintainers":[{"name":"shivaduke28","email":"shivaduke28@gmail.com"}],"homepage":"https://github.com/shivaduke28/google-mcp#readme","bugs":{"url":"https://github.com/shivaduke28/google-mcp/issues"},"bin":{"google-sheets-mcp":"dist/index.js"},"dist":{"shasum":"93279f096b7ac8e4520d9497496cc1ba5162d331","tarball":"https://registry.npmjs.org/@shivaduke28/google-sheets-mcp/-/google-sheets-mcp-1.0.0.tgz","fileCount":4,"integrity":"sha512-Q2Ri72tUucH7R7pZHtEt2NuVmeU2AgB72CGirTz0ZDQzVdmoXrfYx0Lq1kWURc3BJH8Ru0HWR1tjU9Bww09e1g==","signatures":[{"sig":"MEQCIAGKoZPSZfs/N/Anu0Z6GcEe95Q6goKujFbzUrheyPx5AiBAuKKfwYbqq2gJlHybpUYks9f3k0BkN7Hi7FMx4TSpMw==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":13465},"main":"dist/index.js","type":"module","_from":"file:shivaduke28-google-sheets-mcp-1.0.0.tgz","scripts":{"dev":"tsx src/index.ts","build":"tsc","start":"node dist/index.js","typecheck":"tsc --noEmit"},"_npmUser":{"name":"shivaduke28","email":"shivaduke28@gmail.com"},"_resolved":"/private/var/folders/mt/s79frgqn3_v6f3k1w2dhkz0r0000gn/T/fb70c59fba2169f06ba227aca2c2655c/shivaduke28-google-sheets-mcp-1.0.0.tgz","_integrity":"sha512-Q2Ri72tUucH7R7pZHtEt2NuVmeU2AgB72CGirTz0ZDQzVdmoXrfYx0Lq1kWURc3BJH8Ru0HWR1tjU9Bww09e1g==","repository":{"url":"git+https://github.com/shivaduke28/google-mcp.git","type":"git","directory":"packages/sheets"},"_npmVersion":"10.9.2","description":"Google Sheets MCP server with allowlist-based permission control","directories":{},"_nodeVersion":"22.14.0","dependencies":{"zod":"^4.3.6","@toon-format/toon":"^2.1.0","@googleapis/sheets":"^13.0.1","@modelcontextprotocol/sdk":"^1.26.0","@shivaduke28/google-mcp-auth":"1.0.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.21.0","typescript":"^5.9.3","@types/node":"^25.2.3"},"_npmOperationalInternal":{"tmp":"tmp/google-sheets-mcp_1.0.0_1771517445350_0.9320312062746576","host":"s3://npm-registry-packages-npm-production"}},"1.0.1":{"name":"@shivaduke28/google-sheets-mcp","version":"1.0.1","keywords":["mcp","google-sheets","model-context-protocol"],"author":{"name":"shivaduke"},"license":"ISC","_id":"@shivaduke28/google-sheets-mcp@1.0.1","maintainers":[{"name":"shivaduke28","email":"shivaduke28@gmail.com"}],"homepage":"https://github.com/shivaduke28/google-mcp#readme","bugs":{"url":"https://github.com/shivaduke28/google-mcp/issues"},"bin":{"google-sheets-mcp":"dist/index.js"},"dist":{"shasum":"a983a491c3891d48710a58a787d6ca0d657a748c","tarball":"https://registry.npmjs.org/@shivaduke28/google-sheets-mcp/-/google-sheets-mcp-1.0.1.tgz","fileCount":4,"integrity":"sha512-xKLTALF0eiUAaq6ZWIMBWZEEKbkQDW3Kj488mcQOLPbiMT80bXp0QOSGbM+pTIiNVWUgmCtEcQ1pdWrxcyyUwg==","signatures":[{"sig":"MEUCIQC43tFuMjrHAzaKkMgOfbYvYx0w7djptKAIFZRVoPwyPwIgWyuMmneHjXOKYh9uA7OsZ9wWB2mloEcsiUQbukR3h/g=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":13157},"main":"dist/index.js","type":"module","_from":"file:shivaduke28-google-sheets-mcp-1.0.1.tgz","scripts":{"dev":"tsx src/index.ts","build":"tsc","start":"node dist/index.js","typecheck":"tsc --noEmit"},"_npmUser":{"name":"shivaduke28","email":"shivaduke28@gmail.com"},"_resolved":"/private/var/folders/mt/s79frgqn3_v6f3k1w2dhkz0r0000gn/T/610f9da31aa6a52b89fb2c69c876a1be/shivaduke28-google-sheets-mcp-1.0.1.tgz","_integrity":"sha512-xKLTALF0eiUAaq6ZWIMBWZEEKbkQDW3Kj488mcQOLPbiMT80bXp0QOSGbM+pTIiNVWUgmCtEcQ1pdWrxcyyUwg==","repository":{"url":"git+https://github.com/shivaduke28/google-mcp.git","type":"git","directory":"packages/sheets"},"_npmVersion":"10.9.2","description":"Google Sheets MCP server with allowlist-based permission control","directories":{},"_nodeVersion":"22.14.0","dependencies":{"zod":"^4.3.6","@toon-format/toon":"^2.1.0","@googleapis/sheets":"^13.0.1","@modelcontextprotocol/sdk":"^1.26.0","@shivaduke28/google-mcp-auth":"1.0.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.21.0","typescript":"^5.9.3","@types/node":"^25.2.3"},"_npmOperationalInternal":{"tmp":"tmp/google-sheets-mcp_1.0.1_1771519783061_0.23818801687329993","host":"s3://npm-registry-packages-npm-production"}},"1.1.0":{"name":"@shivaduke28/google-sheets-mcp","version":"1.1.0","keywords":["mcp","google-sheets","model-context-protocol"],"author":{"name":"shivaduke"},"license":"ISC","_id":"@shivaduke28/google-sheets-mcp@1.1.0","maintainers":[{"name":"shivaduke28","email":"shivaduke28@gmail.com"}],"homepage":"https://github.com/shivaduke28/google-mcp#readme","bugs":{"url":"https://github.com/shivaduke28/google-mcp/issues"},"bin":{"google-sheets-mcp":"dist/index.js"},"dist":{"shasum":"df0503bdd5862623b83fafb8c142c8820e500cdf","tarball":"https://registry.npmjs.org/@shivaduke28/google-sheets-mcp/-/google-sheets-mcp-1.1.0.tgz","fileCount":4,"integrity":"sha512-E7C9h5siLNgXOYkWne+Zuu2qV1M+r79Yxmq6JckwCJWYkdi2zjQpLav9e+EvJVun3gdn++Tsto/i74z1pG+SqA==","signatures":[{"sig":"MEUCIE3W8QIIg6bjFWAxB6FcKMWJFqDs8DKB3UO3avxOunEBAiEA7QUef8eL00cIgZ45iXmV4MANUeH5LtlQhZDUHQBiqlM=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":13336},"main":"dist/index.js","type":"module","_from":"file:shivaduke28-google-sheets-mcp-1.1.0.tgz","scripts":{"dev":"tsx src/index.ts","build":"tsc","start":"node dist/index.js","typecheck":"tsc --noEmit"},"_npmUser":{"name":"shivaduke28","email":"shivaduke28@gmail.com"},"_resolved":"/private/var/folders/mt/s79frgqn3_v6f3k1w2dhkz0r0000gn/T/0aa84dc7e4351f2156655e9ca53b0fa5/shivaduke28-google-sheets-mcp-1.1.0.tgz","_integrity":"sha512-E7C9h5siLNgXOYkWne+Zuu2qV1M+r79Yxmq6JckwCJWYkdi2zjQpLav9e+EvJVun3gdn++Tsto/i74z1pG+SqA==","repository":{"url":"git+https://github.com/shivaduke28/google-mcp.git","type":"git","directory":"packages/sheets"},"_npmVersion":"10.9.2","description":"Google Sheets MCP server with allowlist-based permission control","directories":{},"_nodeVersion":"22.14.0","dependencies":{"zod":"^4.3.6","@toon-format/toon":"^2.1.0","@googleapis/sheets":"^13.0.1","@modelcontextprotocol/sdk":"^1.26.0","@shivaduke28/google-mcp-auth":"1.1.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.21.0","typescript":"^5.9.3","@types/node":"^25.2.3"},"_npmOperationalInternal":{"tmp":"tmp/google-sheets-mcp_1.1.0_1771602458017_0.33875967455895584","host":"s3://npm-registry-packages-npm-production"}},"1.2.0":{"name":"@shivaduke28/google-sheets-mcp","version":"1.2.0","keywords":["mcp","google-sheets","model-context-protocol"],"author":{"name":"shivaduke"},"license":"ISC","_id":"@shivaduke28/google-sheets-mcp@1.2.0","maintainers":[{"name":"shivaduke28","email":"shivaduke28@gmail.com"}],"homepage":"https://github.com/shivaduke28/google-mcp#readme","bugs":{"url":"https://github.com/shivaduke28/google-mcp/issues"},"bin":{"google-sheets-mcp":"dist/index.js"},"dist":{"shasum":"2de4a1533b40ec8b7c1dbbd6d3ad744de794f1a8","tarball":"https://registry.npmjs.org/@shivaduke28/google-sheets-mcp/-/google-sheets-mcp-1.2.0.tgz","fileCount":4,"integrity":"sha512-vw3aXBOlwSwhuXo0yuwsV3DI3qmZZkuhSiJAMSSUZO6vu7zVEYaC3CSHYqI4ujvD12KCG17FgkZ8rWAStWfRqg==","signatures":[{"sig":"MEYCIQC1no4jPw/FIWHx++pJtWXoHmrvky/uS0dTe0eVfPoaZQIhAKMdTkqbP1YJCVq9fNFaINjd/N5fQRhSEyi0h2x8mWh4","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":15697},"main":"dist/index.js","type":"module","gitHead":"3b9ec415a0374a0e33c62c16a770b8d7c1d8adaa","scripts":{"dev":"tsx src/index.ts","build":"tsc","start":"node dist/index.js","typecheck":"tsc --noEmit"},"_npmUser":{"name":"shivaduke28","email":"shivaduke28@gmail.com"},"repository":{"url":"git+https://github.com/shivaduke28/google-mcp.git","type":"git","directory":"packages/sheets"},"_npmVersion":"10.9.2","description":"Google Sheets MCP server with allowlist-based permission control","directories":{},"_nodeVersion":"22.14.0","dependencies":{"zod":"^4.3.6","@toon-format/toon":"^2.1.0","@googleapis/sheets":"^13.0.1","@modelcontextprotocol/sdk":"^1.26.0","@shivaduke28/google-mcp-auth":"workspace:*"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.21.0","typescript":"^5.9.3","@types/node":"^25.2.3"},"_npmOperationalInternal":{"tmp":"tmp/google-sheets-mcp_1.2.0_1771681684870_0.08605257205867001","host":"s3://npm-registry-packages-npm-production"}},"1.2.1":{"name":"@shivaduke28/google-sheets-mcp","version":"1.2.1","keywords":["mcp","google-sheets","model-context-protocol"],"author":{"name":"shivaduke"},"license":"ISC","_id":"@shivaduke28/google-sheets-mcp@1.2.1","maintainers":[{"name":"shivaduke28","email":"shivaduke28@gmail.com"}],"homepage":"https://github.com/shivaduke28/google-mcp#readme","bugs":{"url":"https://github.com/shivaduke28/google-mcp/issues"},"bin":{"google-sheets-mcp":"dist/index.js"},"dist":{"shasum":"59fcbd40a01caacd2924120b7bdb4986de63b763","tarball":"https://registry.npmjs.org/@shivaduke28/google-sheets-mcp/-/google-sheets-mcp-1.2.1.tgz","fileCount":4,"integrity":"sha512-P165pHhl2enGo81Sj2moz70q6MGbbWSRxr1C415qA1z6Ex0/R5lnnw3DvE2/bnabPBfhmpr02nAka7mvWtrkCw==","signatures":[{"sig":"MEUCIQDNXnmGp+LLUPDqf1r0S+C+2MGTt+/CwQj9xrbUYWosSwIgIAwTRKHwgygC9HUcvcqh5Nq+QAdWtCXcbR/bzTriuNg=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":15690},"main":"dist/index.js","type":"module","_from":"file:shivaduke28-google-sheets-mcp-1.2.1.tgz","scripts":{"dev":"tsx src/index.ts","build":"tsc","start":"node dist/index.js","typecheck":"tsc --noEmit"},"_npmUser":{"name":"shivaduke28","email":"shivaduke28@gmail.com"},"_resolved":"/private/var/folders/mt/s79frgqn3_v6f3k1w2dhkz0r0000gn/T/346b25ce61a043ead939ea2a2a08e5c5/shivaduke28-google-sheets-mcp-1.2.1.tgz","_integrity":"sha512-P165pHhl2enGo81Sj2moz70q6MGbbWSRxr1C415qA1z6Ex0/R5lnnw3DvE2/bnabPBfhmpr02nAka7mvWtrkCw==","repository":{"url":"git+https://github.com/shivaduke28/google-mcp.git","type":"git","directory":"packages/sheets"},"_npmVersion":"10.9.2","description":"Google Sheets MCP server with allowlist-based permission control","directories":{},"_nodeVersion":"22.14.0","dependencies":{"zod":"^4.3.6","@toon-format/toon":"^2.1.0","@googleapis/sheets":"^13.0.1","@modelcontextprotocol/sdk":"^1.26.0","@shivaduke28/google-mcp-auth":"1.2.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.21.0","typescript":"^5.9.3","@types/node":"^25.2.3"},"_npmOperationalInternal":{"tmp":"tmp/google-sheets-mcp_1.2.1_1771683026587_0.41679559697852","host":"s3://npm-registry-packages-npm-production"}},"1.2.2":{"name":"@shivaduke28/google-sheets-mcp","version":"1.2.2","keywords":["mcp","google-sheets","model-context-protocol"],"author":{"name":"shivaduke"},"license":"ISC","_id":"@shivaduke28/google-sheets-mcp@1.2.2","maintainers":[{"name":"shivaduke28","email":"shivaduke28@gmail.com"}],"homepage":"https://github.com/shivaduke28/google-mcp#readme","bugs":{"url":"https://github.com/shivaduke28/google-mcp/issues"},"bin":{"google-sheets-mcp":"dist/index.js"},"dist":{"shasum":"a6e02fce4e1aa7dd806f6068558f78c96124d150","tarball":"https://registry.npmjs.org/@shivaduke28/google-sheets-mcp/-/google-sheets-mcp-1.2.2.tgz","fileCount":4,"integrity":"sha512-lGmLuwyQxWa4EFWr3ijAlV3ysvW0VT6WO6pLDr4hCJyMrfk0mMZnD9RXgb7w12zzKUz0q7J6XiGXT9aQ3zYK7w==","signatures":[{"sig":"MEQCICNs3GPoYMdZJBNXmTCXtyUviIeyfMylKMo/w5I1ghaDAiAWtAizM0Du1X0wW35nxsNv57ZW5feq9xqUKsKKzBC7Aw==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":13336},"main":"dist/index.js","type":"module","_from":"file:shivaduke28-google-sheets-mcp-1.2.2.tgz","scripts":{"dev":"tsx src/index.ts","build":"tsc","start":"node dist/index.js","typecheck":"tsc --noEmit"},"_npmUser":{"name":"shivaduke28","email":"shivaduke28@gmail.com"},"_resolved":"/private/var/folders/mt/s79frgqn3_v6f3k1w2dhkz0r0000gn/T/46370b822fa6e113048ec5a2e4b51797/shivaduke28-google-sheets-mcp-1.2.2.tgz","_integrity":"sha512-lGmLuwyQxWa4EFWr3ijAlV3ysvW0VT6WO6pLDr4hCJyMrfk0mMZnD9RXgb7w12zzKUz0q7J6XiGXT9aQ3zYK7w==","repository":{"url":"git+https://github.com/shivaduke28/google-mcp.git","type":"git","directory":"packages/sheets"},"_npmVersion":"10.9.2","description":"Google Sheets MCP server with allowlist-based permission control","directories":{},"_nodeVersion":"22.14.0","dependencies":{"zod":"^4.3.6","@toon-format/toon":"^2.1.0","@googleapis/sheets":"^13.0.1","@modelcontextprotocol/sdk":"^1.26.0","@shivaduke28/google-mcp-auth":"1.2.1"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.21.0","typescript":"^5.9.3","@types/node":"^25.2.3"},"_npmOperationalInternal":{"tmp":"tmp/google-sheets-mcp_1.2.2_1771683612171_0.31770141977768507","host":"s3://npm-registry-packages-npm-production"}},"1.3.0":{"name":"@shivaduke28/google-sheets-mcp","version":"1.3.0","type":"module","main":"dist/index.js","bin":{"google-sheets-mcp":"dist/index.js"},"publishConfig":{"access":"public"},"repository":{"type":"git","url":"git+https://github.com/shivaduke28/google-mcp.git","directory":"packages/sheets"},"keywords":["mcp","google-sheets","model-context-protocol"],"author":{"name":"shivaduke"},"license":"ISC","description":"Google Sheets MCP server with allowlist-based permission control","dependencies":{"@googleapis/drive":"^20.1.0","@googleapis/sheets":"^13.0.1","@modelcontextprotocol/sdk":"^1.26.0","@toon-format/toon":"^2.1.0","zod":"^4.3.6","@shivaduke28/google-mcp-auth":"1.3.0"},"devDependencies":{"@types/node":"^25.2.3","tsx":"^4.21.0","typescript":"^5.9.3"},"scripts":{"build":"tsc","start":"node dist/index.js","dev":"tsx src/index.ts","typecheck":"tsc --noEmit"},"_id":"@shivaduke28/google-sheets-mcp@1.3.0","bugs":{"url":"https://github.com/shivaduke28/google-mcp/issues"},"homepage":"https://github.com/shivaduke28/google-mcp#readme","_integrity":"sha512-oFTS/fqaIj2ZuNv5bcNtsXNylr0lx3U+MY8EGZ46Bdd/XfhY9EIP2XUAg15bX0h0xMExt3/u+9i5YVKibRJmRQ==","_resolved":"/private/tmp/claude-501/29cfa1b9329b32031bb0faae3c5b990e/shivaduke28-google-sheets-mcp-1.3.0.tgz","_from":"file:shivaduke28-google-sheets-mcp-1.3.0.tgz","_nodeVersion":"22.22.0","_npmVersion":"10.9.4","dist":{"integrity":"sha512-oFTS/fqaIj2ZuNv5bcNtsXNylr0lx3U+MY8EGZ46Bdd/XfhY9EIP2XUAg15bX0h0xMExt3/u+9i5YVKibRJmRQ==","shasum":"c45bcca6557c6ca338c66669654aa251e0a1ec82","tarball":"https://registry.npmjs.org/@shivaduke28/google-sheets-mcp/-/google-sheets-mcp-1.3.0.tgz","fileCount":4,"unpackedSize":20507,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEYCIQCnCT0OEN/2Kd6S07HqDa/hvO13/K/rKZVO/r8r7qgNZAIhAMOKKJFv26y+SdgfxUh/RloONhaQ9X+ceyT9dsVAJzi2"}]},"_npmUser":{"name":"shivaduke28","email":"shivaduke28@gmail.com"},"directories":{},"maintainers":[{"name":"shivaduke28","email":"shivaduke28@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/google-sheets-mcp_1.3.0_1780394020324_0.9732946458483311"},"_hasShrinkwrap":false}},"time":{"created":"2026-02-19T16:10:45.235Z","modified":"2026-06-02T09:53:40.594Z","1.0.0":"2026-02-19T16:10:45.488Z","1.0.1":"2026-02-19T16:49:43.248Z","1.1.0":"2026-02-20T15:47:38.167Z","1.2.0":"2026-02-21T13:48:05.006Z","1.2.1":"2026-02-21T14:10:26.716Z","1.2.2":"2026-02-21T14:20:12.302Z","1.3.0":"2026-06-02T09:53:40.471Z"},"bugs":{"url":"https://github.com/shivaduke28/google-mcp/issues"},"author":{"name":"shivaduke"},"license":"ISC","homepage":"https://github.com/shivaduke28/google-mcp#readme","keywords":["mcp","google-sheets","model-context-protocol"],"repository":{"type":"git","url":"git+https://github.com/shivaduke28/google-mcp.git","directory":"packages/sheets"},"description":"Google Sheets MCP server with allowlist-based permission control","maintainers":[{"name":"shivaduke28","email":"shivaduke28@gmail.com"}],"readme":"# @shivaduke28/google-sheets-mcp\n\nGoogle Sheets API の MCP (Model Context Protocol) サーバー。\n\nallowlist 方式のパーミッション制御により、アクセス可能なスプレッドシートと読み書き権限を制御できます。\n\n## Tools\n\n| ツール | 説明 |\n|---|---|\n| `list-spreadsheets` | allowlist に登録されたスプレッドシート一覧を返す |\n| `get-spreadsheet` | スプレッドシートのメタデータ（シート名一覧など）を取得する |\n| `get-values` | 指定範囲のセル値を取得する（A1表記） |\n| `update-values` | セル範囲に値を書き込む（readwrite のみ） |\n| `append-values` | テーブルの末尾に行を追記する（readwrite のみ） |\n\nレスポンスは [TOON](https://github.com/toon-format/toon) 形式で返されます。\n\n## Setup\n\n### 1. GCP プロジェクトの準備\n\n1. [Google Cloud Console](https://console.cloud.google.com/) でプロジェクトを作成\n2. Google Sheets API を有効化\n3. OAuth 同意画面を設定\n4. OAuth 2.0 クライアント ID を作成（デスクトップアプリ）\n5. 認証情報の JSON ファイルをダウンロード → `credentials.json` として保存\n\n### 2. 使い方\n\n#### npx（推奨）\n\n```json\n{\n  \"mcpServers\": {\n    \"google-sheets\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"@shivaduke28/google-sheets-mcp\"],\n      \"env\": {\n        \"GOOGLE_OAUTH_CREDENTIALS\": \"/path/to/credentials.json\",\n        \"GOOGLE_MCP_CONFIG\": \"/path/to/google-mcp-config.json\"\n      }\n    }\n  }\n}\n```\n\n#### ソースから実行\n\n```bash\npnpm install\npnpm -r build\n```\n\n```json\n{\n  \"mcpServers\": {\n    \"google-sheets\": {\n      \"command\": \"node\",\n      \"args\": [\"/path/to/google-mcp/packages/sheets/dist/index.js\"],\n      \"env\": {\n        \"GOOGLE_OAUTH_CREDENTIALS\": \"/path/to/credentials.json\"\n      }\n    }\n  }\n}\n```\n\n### 3. 環境変数\n\n| 変数 | 必須 | 説明 |\n|---|---|---|\n| `GOOGLE_OAUTH_CREDENTIALS` | Yes | OAuth クライアント認証情報の JSON ファイルパス |\n| `GOOGLE_MCP_CONFIG` | No | 共通設定ファイルパス。`sheets` キーから設定を読み込む |\n\n### 4. 認証\n\n初回起動時にブラウザが開き、Google アカウントでの認証を求められます。認証後、トークンは `~/.config/google-sheets-mcp/tokens.json` に自動保存され、以降はブラウザ認証なしで起動できます。\n\nPKCE (Proof Key for Code Exchange) に対応しています。\n\n## Config\n\n`GOOGLE_MCP_CONFIG` で指定した JSON ファイルの `sheets` キーから設定を読み込みます。未指定の場合は全スプレッドシートにアクセス可能です。\n\n```json\n{\n  \"sheets\": {\n    \"allowedSpreadsheets\": [\n      {\n        \"id\": \"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms\",\n        \"name\": \"家計簿\",\n        \"access\": \"readwrite\"\n      },\n      {\n        \"id\": \"1AbCdEfGhIjKlMnOpQrStUvWxYz\",\n        \"name\": \"レポート\",\n        \"access\": \"readonly\"\n      }\n    ]\n  }\n}\n```\n\n| フィールド | 説明 |\n|---|---|\n| `id` | スプレッドシートID（URLの `/d/` と `/edit` の間の文字列） |\n| `name` | 人間が読める名前（表示用） |\n| `access` | `readonly`（読み取りのみ）または `readwrite`（読み書き可） |\n\n- allowlist が未設定（`GOOGLE_MCP_CONFIG` 未指定 or `sheets` キーなし）の場合は全スプレッドシートにアクセス可能\n- allowlist が設定されている場合、リストにないスプレッドシートへのアクセスは拒否されます\n- `readonly` のスプレッドシートに対する `update-values` / `append-values` は拒否されます\n\n## Development\n\n```bash\npnpm install\npnpm --filter @shivaduke28/google-sheets-mcp dev          # tsx で開発実行\npnpm --filter @shivaduke28/google-sheets-mcp build        # tsc でビルド\npnpm --filter @shivaduke28/google-sheets-mcp typecheck    # 型チェック\n```\n\n## License\n\nISC\n","readmeFilename":"README.md"}