Frequently Asked Questions (FAQ)

Q: What is the UBOS MCP Server for Google Sheets? A: It’s a TypeScript server that bridges AI agents and Google Sheets, enabling secure and automated data interaction.

Q: What authentication methods does it support? A: It supports both Service Account (via base64-encoded credentials) and OAuth2 authentication.

Q: What tools are included in the MCP Server? A: Tools for creating, listing, renaming sheets, reading/writing cell data, sharing spreadsheets, and more.

Q: What are the prerequisites for using the MCP Server? A: You need Bun installed, a Google Cloud project with Sheets and Drive APIs enabled, and either OAuth2 credentials or a Service Account key.

Q: How do I set up the MCP Server? A: Clone the repository, install dependencies, configure the environment variables, and run the server.

Q: Can I use this with my own AI models? A: Yes, the MCP Server provides a standard interface for AI agents to interact with Google Sheets, allowing you to integrate it with your own models.

Q: Is a Drive Folder ID required? A: No, it’s optional. If provided, new spreadsheets will be automatically moved to that folder.

Q: What kind of security measures are in place? A: The server uses secure authentication methods (Service Account or OAuth2) to protect your data.

Q: How does the MCP Server interact with AI Agents? A: It uses StdioServerTransport, allowing agents to invoke tools over stdin/stdout with JSON requests.

Q: Can I contribute to the project? A: Yes, you are welcome to open issues or pull requests for new tools, bug fixes, and enhancements.