ToolsForMCPServer-extension

This MCP server extension enables Gemini CLI users to access the ToolsForMCPServer capabilities via a Gemini extension-based MCP server. After deploying the Google Apps Script web app and configuring the required environment variables, you can invoke the MCP tools from Gemini using the /mcp command. The server exposes a suite of tools originally provided by ToolsForMCPServer, such as data automation helpers, Google Sheets and Docs-related operations, and other generic MCP utilities that can be commanded through natural-language prompts. Once running, Gemini will route prompts to the ToolsForMCPServer backend hosted by the Apps Script Web App URL and return structured results.

To use the tools, ensure your GEMINI_API_KEY is set for authenticating with Gemini services and MCP_WEB_APPS_URL points to your deployed Web App endpoint. In the Gemini CLI session, run /mcp to load the available tools, then issue prompts to perform tasks such as data extraction, transformation, or Google Workspace automation using natural language commands.

Prerequisites:

• Node.js and npm installed on your machine
• Gemini CLI installed and configured
• Access to the internet to install dependencies

Step-by-step instructions:

1. Install the Gemini CLI if you haven’t already:

npm install -g @google/gemini-cli

2. Install this MCP server extension via Gemini:

gemini extensions install https://github.com/tanaikech/ToolsForMCPServer-extension

3. Deploy and configure the underlying ToolsForMCPServer backend (Google Apps Script Web App):

• Create and deploy the Apps Script Web App as described in the repository’s deployment steps.
• Copy the Web App URL (endpoints) and set it as MCP_WEB_APPS_URL.
• Ensure you have a Gemini API key; export it or set it in your environment.

4. Set required environment variables:

export GEMINI_API_KEY="{Your API key}"
export MCP_WEB_APPS_URL="https://script.google.com/macros/s/###/exec?accessKey=sample"

5. Run the MCP server via the extension (the extension is installed globally by the Gemini CLI):

gemini

Then within Gemini, load the MCP server (using /mcp) and start issuing prompts to interact with ToolsForMCPServer.

Notes and tips:

• The MCP server is backed by a Google Apps Script Web App; ensure the app is deployed with the correct permissions (Execute as: Me, Who has access: Anyone).
• When you modify the Apps Script code, redeploy as a new version and update MCP_WEB_APPS_URL accordingly.
• If you encounter authentication issues, verify GEMINI_API_KEY is valid and that the environment variables are exported in the shell/session running Gemini.
• The extension uses a Web App endpoint; latency may vary based on Google Apps Script execution time.
• You can customize environment variables per deployment if needed, but keep GEMINI_API_KEY and MCP_WEB_APPS_URL consistent with the Apps Script endpoint.
• If you need to update the MCP server prompt capabilities, refer to the ToolsForMCPServer project for supported commands and prompts.