MCP

ToolsForMCPServer was updated to v1.0.27 v1.0.27 (August 22, 2025) Following 6 tools for Google Analytics were added. analytics_admin_accountSummaries_list: Retrieves a list of all Google Analytics accounts accessible by the current user analytics_admin_properties_get: Get detailed information about a single Google Analytics property analytics_data_properties_runReport: Fetches a custom report from a Google Analytics property analytics_data_properties_runRealtimeReport: Generates a customized report of real-time event data from a Google Analytics property You can see the detailed information here https://github.

Gists Abstract This report introduces a powerful method for automating Google Analytics tasks using the Gemini CLI and a custom MCP (Model Context Protocol) server built with Google Apps Script. This integration enables streamlined web page analysis through simple natural language commands, simplifying authorization and complex data retrieval workflows. Introduction Accessing and interpreting web analytics data often involves navigating complex interfaces and manual report generation. However, the emergence of natural language interfaces is changing this paradigm.

Gists Abstract This document demonstrates a transformative method for unifying Google Workspace applications by using natural language. Through the integration of the Gemini CLI with MCP, this approach empowers users to intuitively manage Google Drive, Gmail, Google Calendar, Drive Activity, and Google People. Complex tasks and collaborative workflows are streamlined into simple, conversational text commands. Introduction In today’s dynamic, collaborative environments, managing document workflows, tracking changes, and coordinating team efforts can be fragmented and inefficient.

Gists Abstract Automate Google Classroom management with natural language. This guide details using the Gemini CLI and an MCP server to streamline creating classes, managing assignments, and interacting with students. Introduction Unlock the power of natural language to command your Google Workspace. I’ve recently demonstrated how you can automate Google Workspace applications using simple, conversational commands through the Gemini CLI and the MCP (Model Context Protocol) server. My previous reports detailed how to harness natural language for automating tasks in Google Sheets and Google Calendar:

MCPApp was updated to v2.0.7 v2.0.7 (August 6, 2025) Starting with v2.0.7, you can now selectively enable or disable the LockService. By default, this library runs with the LockService enabled. To disable it, simply modify return new MCPApp.mcpApp({ accessKey: "sample" }) to return new MCPApp.mcpApp({ accessKey: "sample", lock: false }). When the LockService is disabled (lock: false), asynchronous requests from clients like the Gemini CLI may see an increase in processing speed.

ToolsForMCPServer was updated to v1.0.13 v1.0.13 (August 1, 2025) prompts/get was updated. And, 3 prompts were added. You can see the detailed information here https://github.com/tanaikech/ToolsForMCPServer

MCPApp was updated to v2.0.6 v2.0.6 (August 1, 2025) “prompts/get” method was updated. You can see the detail information here https://github.com/tanaikech/MCPApp

Gists Abstract This report provides a comprehensive overview of how to utilize prompts within the Gemini Command-Line Interface (CLI). Leveraging a Google Apps Script MCP server, we will explore practical examples, including roadmap generation, real-time weather inquiries, and Google Drive file searches. This enhanced document offers more in-depth explanations and a broader context to empower users in their understanding and application of these powerful features. Introduction The Model Context Protocol (MCP) establishes a standardized framework for servers to offer clients predefined, structured prompt templates.

ToolsForMCPServer was updated to v1.0.12 v1.0.12 (July 31, 2025) At Gemini CLI v0.1.15, prompts/list was called even when prompts wasn’t included in capabilities. This resulted in the error Error discovering prompts from gas_web_apps: MCP error -32001: Request timed out when prompts wasn’t returned for prompts/list. To resolve this, I updated ToolsForMCPServer to return an empty array for prompts, which eliminated the error. Consequently, with this update in v1.

MCPApp was updated to v2.0.5 v2.0.5 (July 31, 2025) A bug was removed. You can see the detail information here https://github.com/tanaikech/MCPApp

Gists Abstract This report demonstrates managing Google Calendar from the command line using Gemini CLI and an MCP server, enabling powerful, scriptable automation for your schedule. Introduction Following up on my previous report, “Next-Level Data Automation: Gemini CLI, Google Sheets, and MCP,” I’m excited to present the next installment in this series. My earlier report, published on Medium, detailed an innovative approach to managing Google Sheets through the powerful combination of Gemini CLI and an MCP server.

ToolsForMCPServer was updated to v1.0.10 v1.0.10 (July 26, 2025) When I updated Gemini CLI from v0.1.12 to v0.1.13, an issue related to the schema of MCP occurred. Ref So, as a workaround at the time, I updated this library. But when I updated Gemini CLI to v0.1.14, I confirmed that the previous schema could be used. So, I reimplemented the previous schema. By this, the request body for APIs can be directly generated using Gemini CLI v0.

ToolsForMCPServer was updated to v1.0.9 v1.0.9 (July 24, 2025) The following 2 new tools were added. description_youtube: Describe a YouTube video by providing the URL. create_google_docs_from_markdown_on_google_drive: Create a Google Document from a markdown format. You can see the detailed information here https://github.com/tanaikech/ToolsForMCPServer

ToolsForMCPServer was updated to v1.0.8 v1.0.8 (July 23, 2025) An issue occurred when I updated Gemini CLI from v0.1.12 to v0.1.13. Ref Fortunately, Google is already aware of this issue, and I’m awaiting a resolution. In the meantime, I’ve received emails about it, so I’ve updated ToolsForMCPServer for Gemini CLI v0.1.13. The detailed updates are as follows: I confirmed that all tools in ToolsForMCPServer v1.0.8 worked when tested with Gemini CLI v0.

ToolsForMCPServer was updated to v1.0.7 v1.0.7 (July 19, 2025) Added a getToolList method for retrieving all current tools in the library. Tools can be filtered using enables or disables as an array argument for the getTools method. If enables is used, only the tools specified in the enables array will be used. If disables is used, all tools except those specified in the disables array will be used.

Gists Abstract This report explores an optimized approach to integrating the Gemini CLI with Google Workspace via an MCP server. Traditionally, this process requires numerous custom tools, which increases development costs. We propose leveraging the inherent JSON schema requirements of the MCP server tools to directly construct request bodies for the batchUpdate methods of the Google Docs, Sheets, and Slides APIs. This approach aims to consolidate document management into just three core tools, significantly streamlining development and offering a scalable, cost-effective solution for Google Workspace automation and broader API integrations.

Gists Abstract This article explores the integration of the Gemini Command-Line Interface (CLI) with Google Sheets using the Model Context Protocol (MCP). It demonstrates how to leverage the open-source projects MCPApp and ToolsForMCPServer to create a bridge between the Gemini CLI and Google Workspace. This enables users to perform powerful data automation tasks, such as creating, reading, and modifying tables in Google Sheets directly from the command line, using natural language prompts.

Gists Abstract This report introduces ToolsForMCPServer, an enhanced Google Apps Script library that expands the capabilities of Gemini CLI. It showcases new tools that streamline complex workflows, with a special emphasis on facilitating seamless file content transfer and management between a user’s local environment and Google Drive. Introduction This report details significant enhancements to ToolsForMCPServer, a powerful Google Apps Script library designed to work in tandem with Gemini CLI. By integrating this library with a Model Context Protocol (MCP) server, the capabilities of Gemini CLI are dramatically expanded, especially in its interaction with Google Workspace services.

Gists Abstract This report details two methods for processing files using the Gemini CLI and a Google Apps Script MCP server: direct Base64 encoding and indirect transfer via the Google Drive API using ggsrun. The direct method proved ineffective due to token limits. The recommended approach, leveraging ggsrun, allows for efficient, scalable file transfers by using file IDs instead of embedding content within the prompt, enabling advanced automation capabilities. Introduction This report demonstrates how to efficiently process file content using the Gemini CLI integrated with an MCP (Magical Control Panel) server built on Google Apps Script Web Apps.

Gists Abstract The Gemini CLI provides a powerful command-line interface for interacting with Google’s Gemini models. By leveraging the Model Context Protocol (MCP), the CLI can be extended with custom tools. This report explores the integration of the Gemini CLI with an MCP server built using Google Apps Script Web Apps. We demonstrate how this combination simplifies authorization for Google Workspace APIs (Gmail, Drive, Calendar, etc.), allowing Gemini to execute complex, multi-step tasks directly within the Google ecosystem.

Gists Abstract The Gemini CLI can be integrated with Google Workspace via Google Apps Script to securely access personal data, enabling powerful automations like email summaries and calendar management. Introduction The recently released Gemini CLI is a powerful command-line interface for interacting with Google’s Gemini models and cloud resources. Ref While powerful on its own, its utility can be significantly enhanced by connecting it to a user’s personal Google resources, such as Google Sheets, Docs, Slides, Gmail, and Calendar.

Gists Abstract A new unified Google Apps Script now deploys both Model Context Protocol (MCP) and Agent2Agent (A2A) networks as a single server, streamlining AI model integration for Google Workspace users. Introduction The rapid growth of generative AI has led to increasing integration between AI models, exemplified by protocols like the Model Context Protocol (MCP) and Agent2Agent (A2A) Protocol. Recently, I released MCPApp and A2AApp, which establish the MCP and A2A networks using Google Apps Script.

MCPApp was updated to v2.0.0 v2.0.0 (June 12, 2025) From v2.0.0, both the MCP client and the MCP server can be built by Google Apps Script. You can see the detail information here https://github.com/tanaikech/MCPApp

Gists Abstract This report details an MCP network using Google Apps Script for both server and client, enabling automated, secure Gmail processing to boost efficiency. Introduction Recently, I published a report titled “Building Model Context Protocol (MCP) Server with Google Apps Script,” which you can find here. In that initial report, I demonstrated the feasibility of creating an MCP server using Google Apps Script, with Claude Desktop serving as the client.

MCPApp was updated to v1.0.2 v1.0.2 (May 29, 2025) From v1.0.2, in order to use MCPApp as a library, LockService is given. You can see the detail information here https://github.com/tanaikech/MCPApp

Gists Abstract This report details transferring image data via Model Context Protocol (MCP) from Google Apps Script server to a Python/Gemini client, extending capabilities for multimodal applications beyond text. Introduction Following up on my previous report, “Building Model Context Protocol (MCP) Server with Google Apps Script” (Ref), which detailed the transfer of text data between the MCP server and client, this new report focuses on extending the protocol to handle image data.

Gists Abstract This text introduces the Model Context Protocol (MCP) for standardizing AI interaction with external systems. It explores the potential of using Google Apps Script (GAS) to host an MCP server, leveraging GAS’s integration with Google Workspace for data access. A sample script demonstrates feasibility, highlighting the current absence of an official GAS SDK. The work aims to foster understanding and encourage SDK development. Introduction Recently, the Model Context Protocol (MCP) has emerged as a standard protocol for connecting AI applications with third-party systems and data sources.