{"_id":"@bossforce.ai/mcp-google-sheets","name":"@bossforce.ai/mcp-google-sheets","dist-tags":{"latest":"0.1.0"},"versions":{"0.1.0":{"name":"@bossforce.ai/mcp-google-sheets","version":"0.1.0","type":"module","repository":{"type":"git","url":"git+https://github.com/bossforce-ai/bossforce-tools.git","directory":"mcps/spreadsheets/google-sheets"},"publishConfig":{"access":"public"},"bin":{"bossforce-mcp-google-sheets":"dist/bin.js"},"dependencies":{"zod":"^4.4.3","@bossforce.ai/mcp-core":"0.3.0","@bossforce.ai/mcp-google":"0.1.0"},"devDependencies":{"@bossforce.ai/mcp-testkit":"0.0.0"},"scripts":{"build":"tsc -p tsconfig.json","test":"node --test \"dist/*.test.js\""},"_id":"@bossforce.ai/mcp-google-sheets@0.1.0","description":"MCP server for **Google Sheets** (v4 API). Create spreadsheets and read, append and update their data.","bugs":{"url":"https://github.com/bossforce-ai/bossforce-tools/issues"},"homepage":"https://github.com/bossforce-ai/bossforce-tools#readme","_integrity":"sha512-slk1/frBJoRT67jrkVaZq0xv7dF4t7h5AmJ2OCB60Lz5dxnYEIQsldLLDd/ytSfuz0KbT8PyUmRqbfvNioLbQg==","_resolved":"C:\\Users\\user\\AppData\\Local\\Temp\\e3a55678212432fa4f277e9a13b4caaf\\bossforce.ai-mcp-google-sheets-0.1.0.tgz","_from":"file:bossforce.ai-mcp-google-sheets-0.1.0.tgz","_nodeVersion":"22.18.0","_npmVersion":"10.9.3","dist":{"integrity":"sha512-slk1/frBJoRT67jrkVaZq0xv7dF4t7h5AmJ2OCB60Lz5dxnYEIQsldLLDd/ytSfuz0KbT8PyUmRqbfvNioLbQg==","shasum":"5a9fe96f5509de07833c7a88300fd04d75a48569","tarball":"https://registry.npmjs.org/@bossforce.ai/mcp-google-sheets/-/mcp-google-sheets-0.1.0.tgz","fileCount":30,"unpackedSize":24586,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEQCIBDNEBDLo4sWDP5ipyJoLyjPovUw9ZIYVX7oeh9cJpHzAiBtXtosDxQcpvvlT+Cmx3RhGOqxiuIWjv4tleOpMLONxA=="}]},"_npmUser":{"name":"bossforce.ai","email":"bossforce.ai@gmail.com"},"directories":{},"maintainers":[{"name":"bossforce.ai","email":"bossforce.ai@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mcp-google-sheets_0.1.0_1780985508123_0.7115564156023706"},"_hasShrinkwrap":false}},"time":{"created":"2026-06-09T06:11:47.927Z","0.1.0":"2026-06-09T06:11:48.288Z","modified":"2026-06-09T06:11:48.546Z"},"maintainers":[{"name":"bossforce.ai","email":"bossforce.ai@gmail.com"}],"description":"MCP server for **Google Sheets** (v4 API). Create spreadsheets and read, append and update their data.","homepage":"https://github.com/bossforce-ai/bossforce-tools#readme","repository":{"type":"git","url":"git+https://github.com/bossforce-ai/bossforce-tools.git","directory":"mcps/spreadsheets/google-sheets"},"bugs":{"url":"https://github.com/bossforce-ai/bossforce-tools/issues"},"readme":"# @bossforce.ai/mcp-google-sheets\n\nMCP server for **Google Sheets** (v4 API). Create spreadsheets and read, append\nand update their data.\n\n## Auth (OAuth2)\n\nThe platform performs the Google authorization and injects these env vars; the\nserver exchanges the refresh token for short-lived access tokens itself (cached,\nrefreshed a minute before expiry).\n\n| Env                           | Source                          |\n| ----------------------------- | ------------------------------- |\n| `GOOGLE_SHEETS_CLIENT_ID`     | OAuth client id (server `.env`) |\n| `GOOGLE_SHEETS_CLIENT_SECRET` | OAuth client secret             |\n| `GOOGLE_SHEETS_REFRESH_TOKEN` | per-workspace, from OAuth flow  |\n\nCredentials are read lazily, so the server boots and answers `tools/list`\nwithout them. All auth lives behind a `getAccessToken()` seam (`oauth.ts`) — in\nplatform mode that implementation is swapped for a central token service without\ntouching the tools.\n\nScopes: `spreadsheets`, `drive.file`.\n\n## Tools\n\n| Tool                 | Arguments                           | Purpose                       |\n| -------------------- | ----------------------------------- | ----------------------------- |\n| `create_spreadsheet` | `title`                             | create a spreadsheet          |\n| `get_spreadsheet`    | `spreadsheet_id`                    | title + list of sheets (tabs) |\n| `add_sheet`          | `spreadsheet_id`, `title`           | add a tab                     |\n| `get_values`         | `spreadsheet_id`, `range`           | read a range                  |\n| `append_values`      | `spreadsheet_id`, `range`, `values` | append rows                   |\n| `update_values`      | `spreadsheet_id`, `range`, `values` | overwrite a range             |\n\n`range` is an A1 range (e.g. `Sheet1!A1:C10`); `values` is rows of cells.\n\n## Develop\n\n```bash\npnpm --filter @bossforce.ai/mcp-google-sheets build\npnpm --filter @bossforce.ai/mcp-google-sheets test\nUPDATE_SNAPSHOTS=1 pnpm --filter @bossforce.ai/mcp-google-sheets test  # after a signature change\n```\n","readmeFilename":"README.md","_rev":"1-462ab4f337d577a3212943c41f862a36"}