Next-Level Data Automation: Gemini CLI, Google Calendar, and MCP
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.
Читать далее
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.
Читать далее
Updated: GAS Library - ToolsForMCPServer
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.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.
Читать далее
Updated: GAS Library - ToolsForMCPServer
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.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
Читать далее
GitHub
GitHub - tanaikech/ToolsForMCPServer: The Gemini CLI confirmed that the MCP server built with Google Apps Script (GAS), a low-code…
The Gemini CLI confirmed that the MCP server built with Google Apps Script (GAS), a low-code platform, offers immense possibilities. If you've created snippets for GAS, these could be revit...
Updated: GAS Library - 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.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.
Читать далее
Generating Request Body for APIs using Gemini
Gists
Abstract Effortlessly generate API request bodies from natural language commands. This guide demonstrates using Gemini and Google Apps Script to streamline automation and accelerate development for Google Workspace APIs and beyond.
Introduction In a recent article, “Managing Google Docs, Sheets, and Slides by Natural Language with Gemini CLI and MCP,” I showcased a powerful method for dynamically creating API request bodies using natural language. This approach, utilizing the Gemini CLI and a My Custom Proxy (MCP) server, allows users to manage Google Workspace applications with simple, human-readable commands.
Читать далее
Gists
Abstract Effortlessly generate API request bodies from natural language commands. This guide demonstrates using Gemini and Google Apps Script to streamline automation and accelerate development for Google Workspace APIs and beyond.
Introduction In a recent article, “Managing Google Docs, Sheets, and Slides by Natural Language with Gemini CLI and MCP,” I showcased a powerful method for dynamically creating API request bodies using natural language. This approach, utilizing the Gemini CLI and a My Custom Proxy (MCP) server, allows users to manage Google Workspace applications with simple, human-readable commands.
Читать далее
Updated: GAS Library - GeminiWithFiles
GeminiWithFiles was updated to v2.0.13 v2.0.13 (July 22, 2025)
responseJsonSchema was added. The default model was changed from models/gemini-2.5-flash-preview-04-17 to models/gemini-2.5-flash. You can see the detail information here https://github.com/tanaikech/GeminiWithFiles
Читать далее
GeminiWithFiles was updated to v2.0.13 v2.0.13 (July 22, 2025)
responseJsonSchema was added. The default model was changed from models/gemini-2.5-flash-preview-04-17 to models/gemini-2.5-flash. You can see the detail information here https://github.com/tanaikech/GeminiWithFiles
Читать далее
GitHub
GitHub - tanaikech/GeminiWithFiles: This is a Google Apps Script library for Gemini API with files.
This is a Google Apps Script library for Gemini API with files. - tanaikech/GeminiWithFiles
Updated: GAS Library - ToolsForMCPServer
ToolsForMCPServer was updated to v1.0.29 v1.0.29 (September 15, 2025)
The following 5 tools were added. These tools provide the information for building the request body of Google APIs.
explanation_analytics_data_properties_runReport explanation_analytics_data_properties_runRealtimeReport explanation_manage_google_sheets_using_sheets_api explanation_manage_google_docs_using_docs_api explanati...
Читать далее
ToolsForMCPServer was updated to v1.0.29 v1.0.29 (September 15, 2025)
The following 5 tools were added. These tools provide the information for building the request body of Google APIs.
explanation_analytics_data_properties_runReport explanation_analytics_data_properties_runRealtimeReport explanation_manage_google_sheets_using_sheets_api explanation_manage_google_docs_using_docs_api explanati...
Читать далее
Updated: GAS Library - ToolsForMCPServer
ToolsForMCPServer was updated to v1.0.28 v1.0.28 (September 11, 2025)
The following 9 tools were added.
create_document_body_in_google_docs remove_files_on_google_drive maps_get_route maps_convert_location_to_lat_lon maps_convert_lat_lon_to_location maps_create_map explanation_create_maps_url explanation_reference_generate_google_apps_script explanation_reference_export_google_sheets_as_pdf ...
Читать далее
ToolsForMCPServer was updated to v1.0.28 v1.0.28 (September 11, 2025)
The following 9 tools were added.
create_document_body_in_google_docs remove_files_on_google_drive maps_get_route maps_convert_location_to_lat_lon maps_convert_lat_lon_to_location maps_create_map explanation_create_maps_url explanation_reference_generate_google_apps_script explanation_reference_export_google_sheets_as_pdf ...
Читать далее
Google Maps with Natural Language: Integrated Collaboration through Gemini CLI and MCP
Gists Abstract This article demonstrates integrating Google Maps with natural language using the Gemini CLI and an MCP server. This powerful combination allows users to automate complex location-based tasks, such as route planning and information retrieval, through simple, intuitive text-based prompts. Introduction The Gemini CLI, when paired with Model Context Protocol (MCP) servers, is a powerfu...
Читать далее
Gists Abstract This article demonstrates integrating Google Maps with natural language using the Gemini CLI and an MCP server. This powerful combination allows users to automate complex location-based tasks, such as route planning and information retrieval, through simple, intuitive text-based prompts. Introduction The Gemini CLI, when paired with Model Context Protocol (MCP) servers, is a powerfu...
Читать далее
A Fake-Sandbox for Google Apps Script: A Feasibility Study on Securely Executing Code Generated by Gemini CLI
Gists
Abstract Generating Google Apps Script (GAS) with Gemini CLI from natural language introduces security risks due to broad permissions. This report investigates a “Fake-Sandbox” using the gas-fakes library, translating GAS calls into granularly-scoped API requests to securely execute scripts created from user prompts.
Introduction 1. Background: Generative AI and the Challenge of Secure Scrip...
Читать далее
Gists
Abstract Generating Google Apps Script (GAS) with Gemini CLI from natural language introduces security risks due to broad permissions. This report investigates a “Fake-Sandbox” using the gas-fakes library, translating GAS calls into granularly-scoped API requests to securely execute scripts created from user prompts.
Introduction 1. Background: Generative AI and the Challenge of Secure Scrip...
Читать далее
Updated: GAS Library - ToolsForMCPServer
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 repor...
Читать далее
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 repor...
Читать далее
Streamlining Web Page Insights with Natural Language using Gemini CLI, Google Analytics, and MCP
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 ...
Читать далее
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 ...
Читать далее
Unifying Google Workspace with Natural Language: Integrated Collaboration through Gemini CLI and MCP
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 te...
Читать далее
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 te...
Читать далее
Next-Level Classroom Automation: Gemini CLI, Google Classroom, and MCP
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, conver...
Читать далее
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, conver...
Читать далее
Updated: GAS Library - MCPApp
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), asynchr...
Читать далее
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), asynchr...
Читать далее
Updated: GAS Library - ToolsForMCPServer
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
Читать далее
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
Читать далее
GitHub
GitHub - tanaikech/ToolsForMCPServer: The Gemini CLI confirmed that the MCP server built with Google Apps Script (GAS), a low-code…
The Gemini CLI confirmed that the MCP server built with Google Apps Script (GAS), a low-code platform, offers immense possibilities. If you've created snippets for GAS, these could be revit...
Updated: GAS Library - MCPApp
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
Читать далее
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
Читать далее
GitHub
GitHub - tanaikech/MCPApp: This text introduces the Model Context Protocol (MCP) for AI interaction, exploring Google Apps Script…
This text introduces the Model Context Protocol (MCP) for AI interaction, exploring Google Apps Script (GAS) as a server option. It shows feasibility with a sample but notes the lack of a GAS SDK, ...
Enhanced Guide to Using Prompts in Gemini CLI
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 user...
Читать далее
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 user...
Читать далее
Updated: GAS Library - ToolsForMCPServer
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 promp...
Читать далее
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 promp...
Читать далее
Updated: GAS Library - MCPApp
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
Читать далее
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
Читать далее
GitHub
GitHub - tanaikech/MCPApp: This text introduces the Model Context Protocol (MCP) for AI interaction, exploring Google Apps Script…
This text introduces the Model Context Protocol (MCP) for AI interaction, exploring Google Apps Script (GAS) as a server option. It shows feasibility with a sample but notes the lack of a GAS SDK, ...
Next-Level Data Automation: Gemini CLI, Google Calendar, and MCP
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, de...
Читать далее
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, de...
Читать далее