{"id":42663,"recorded_at":"2026-10-26T14:36:41.407499Z","observed_at":"2026-10-26T14:36:41.407425Z","subject_kind":"source_record","subject":"mcp_registry:io.github.mcp-z/mcp-sheets","kind":"listing","method":"baseline/1","body":{"endpoints":[["web","https://github.com/mcp-z/mcp-sheets"]],"name":"Google Sheets","owner_address":null,"raw":{"_meta":{"io.modelcontextprotocol.registry/official":{"isLatest":true,"publishedAt":"2026-10-12T16:12:20.156651Z","status":"active","statusChangedAt":"2026-10-12T16:12:20.156651Z","updatedAt":"2026-10-12T16:12:20.156651Z"}},"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","description":"Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting","name":"io.github.mcp-z/mcp-sheets","packages":[{"environmentVariables":[{"description":"Google OAuth client ID (required for OAuth authentication modes)","isRequired":true,"name":"GOOGLE_CLIENT_ID","placeholder":"123456789-abcdefghijk.apps.googleusercontent.com"},{"description":"Google OAuth client secret (optional for public clients)","isSecret":true,"name":"GOOGLE_CLIENT_SECRET","placeholder":"GOCSPX-abcdefghijklmnop"},{"description":"Path to service account JSON key file (required for service-account auth mode)","name":"GOOGLE_SERVICE_ACCOUNT_KEY_FILE","placeholder":"/path/to/service-account-key.json"},{"choices":["loopback-oauth","service-account"],"description":"Authentication mode","name":"AUTH_MODE","placeholder":"loopback-oauth","value":"loopback-oauth"},{"default":"false","description":"Disable browser auto-open, return auth URL instead (true/false)","name":"HEADLESS","placeholder":"false"},{"description":"OAuth redirect URI (optional, default: ephemeral loopback)","name":"REDIRECT_URI","placeholder":"http://localhost:{PORT}/oauth/callback"},{"description":"Resource store URI for exported files (file://)","name":"RESOURCE_STORE_URI","placeholder":"file://~/.mcp-z/mcp-sheets/files","value":"file://~/.mcp-z/mcp-sheets/files"},{"description":"HTTP server port (overrides --port)","name":"PORT","placeholder":"3000"},{"description":"Base URL for HTTP transport (used for OAuth/DCR endpoints and file links)","name":"BASE_URL","placeholder":"http://localhost:{PORT}"},{"choices":["debug","info","warn","error"],"description":"Logging level","name":"LOG_LEVEL","placeholder":"info","value":"info"}],"identifier":"@mcp-z/mcp-sheets","packageArguments":[{"choices":["loopback-oauth","service-account"],"description":"Authentication mode","name":"--auth","type":"named"},{"description":"Disable browser auto-open, return auth URL instead","name":"--headless","type":"named"},{"description":"OAuth redirect URI (default: ephemeral loopback)","name":"--redirect-uri","type":"named"},{"description":"Path to service account JSON key file (overrides GOOGLE_SERVICE_ACCOUNT_KEY_FILE env var)","name":"--service-account-key-file","type":"named"},{"description":"Override resource store URI for exported files","name":"--resource-store-uri","type":"named"},{"description":"Override base URL for HTTP transport (used for OAuth/DCR endpoints and file links)","name":"--base-url","type":"named"},{"choices":["debug","info","warn","error"],"description":"Override logging level","name":"--log-level","type":"named"}],"registryType":"npm","runtimeArguments":[{"name":"-y","type":"named"}],"runtimeHint":"npx","transport":{"type":"stdio"},"version":"2.4.2"},{"environmentVariables":[{"description":"Google OAuth client ID (required for OAuth authentication modes)","isRequired":true,"name":"GOOGLE_CLIENT_ID","placeholder":"123456789-abcdefghijk.apps.googleusercontent.com"},{"description":"Google OAuth client secret (optional for public clients)","isSecret":true,"name":"GOOGLE_CLIENT_SECRET","placeholder":"GOCSPX-abcdefghijklmnop"},{"description":"Path to service account JSON key file (required for service-account auth mode)","name":"GOOGLE_SERVICE_ACCOUNT_KEY_FILE","placeholder":"/path/to/service-account-key.json"},{"choices":["loopback-oauth","service-account","dcr"],"description":"Authentication mode","name":"AUTH_MODE","placeholder":"loopback-oauth","value":"loopback-oauth"},{"default":"false","description":"Disable browser auto-open, return auth URL instead (true/false)","name":"HEADLESS","placeholder":"false"},{"description":"OAuth redirect URI (optional, default: ephemeral loopback)","name":"REDIRECT_URI","placeholder":"http://localhost:{PORT}/oauth/callback"},{"choices":["self-hosted","external"],"default":"self-hosted","description":"Dynamic Client Registration mode","name":"DCR_MODE","placeholder":"self-hosted"},{"description":"External verification endpoint URL (required for external DCR mode)","name":"DCR_VERIFY_URL","placeholder":"https://example.com/verify"},{"default":"file://~/.mcp-z/mcp-sheets/dcr.json","description":"DCR client storage URI (for self-hosted DCR mode)","name":"DCR_STORE_URI","placeholder":"file://~/.mcp-z/mcp-sheets/dcr.json"},{"description":"Resource store URI for exported files (file://)","name":"RESOURCE_STORE_URI","placeholder":"file://~/.mcp-z/mcp-sheets/files","value":"file://~/.mcp-z/mcp-sheets/files"},{"description":"HTTP server port (overrides --port)","name":"PORT","placeholder":"3000"},{"description":"Base URL for HTTP transport (used for OAuth/DCR endpoints and file links)","name":"BASE_URL","placeholder":"http://localhost:{PORT}"},{"choices":["debug","info","warn","error"],"description":"Logging level","name":"LOG_LEVEL","placeholder":"info","value":"info"}],"identifier":"@mcp-z/mcp-sheets","packageArguments":[{"description":"HTTP server port","name":"--port","type":"named","value":"9004"},{"choices":["loopback-oauth","service-account","dcr"],"description":"Authentication mode","name":"--auth","type":"named"},{"description":"Disable browser auto-open, return auth URL instead","name":"--headless","type":"named"},{"description":"OAuth redirect URI (default: ephemeral loopback)","name":"--redirect-uri","type":"named"},{"description":"Path to service account JSON key file (overrides GOOGLE_SERVICE_ACCOUNT_KEY_FILE env var)","name":"--service-account-key-file","type":"named"},{"choices":["self-hosted","external"],"description":"DCR mode","name":"--dcr-mode","type":"named"},{"description":"External verification endpoint URL (required for external DCR mode)","name":"--dcr-verify-url","type":"named"},{"description":"DCR client storage URI (for self-hosted DCR mode)","name":"--dcr-store-uri","type":"named"},{"description":"Override resource store URI for exported files","name":"--resource-store-uri","type":"named"},{"description":"Override base URL for HTTP transport (used for OAuth/DCR endpoints and file links)","name":"--base-url","type":"named"},{"choices":["debug","info","warn","error"],"description":"Override logging level","name":"--log-level","type":"named"}],"registryType":"npm","runtimeArguments":[{"name":"-y","type":"named"}],"runtimeHint":"npx","transport":{"type":"streamable-http","url":"http://localhost:{PORT}/mcp"},"version":"2.4.2"}],"title":"Google Sheets","version":"2.4.2","websiteUrl":"https://github.com/mcp-z/mcp-sheets#readme"}},"source":"mcp_registry","summary":"Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting"},"body_sha256":"2455b06acc2c0e4526b448baabc37f36f451555fef677c38437237cffecea400","prev_id":null,"leaf":"0x6de19d4e550db3985d50d293f6704360ad3b1c14461983e91cf9d8097f0cace6","leaf_text":"{\"body\":\"2455b06acc2c0e4526b448baabc37f36f451555fef677c38437237cffecea400\",\"id\":42663,\"kind\":\"listing\",\"method\":\"baseline/1\",\"observed_us\":1793025401407425,\"prev\":null,\"subject\":\"mcp_registry:io.github.mcp-z/mcp-sheets\",\"subject_kind\":\"source_record\"}","day":null,"proof":[]}