tanaike - Google Apps Script, Gemini API, and Developer Tips

The Thinker

Simplified Google Workspace Automation with Gemini CLI Extensions

Gists Abstract This project simplifies Google Workspace automation by using a Gemini CLI Extension. It installs a local Model Context Protocol (MCP) server that communicates with a powerful, securely authorized backend built on Google Apps Script Web Apps, overcoming previous complex setup and performance bottlenecks. Introduction In order to achieve Google Workspace Automation with seamless authorization and safety, I have published a Model Context Protocol (MCP) server built by Google Apps Script Web Apps.

Recipient of the Outstanding Google Developer Expert Award

I am thrilled and deeply honored to be recognized with the “First place in the Outstanding GDE award”. This incredible honor inspires me to redouble my efforts in advancing new projects and further energizing our amazing community.

Dynamic Tool Creation for Google Workspace Automation with Gemini CLI

Gists Abstract This article presents a method for optimizing Google Workspace automation by dynamically converting frequently used, AI-generated Google Apps Scripts into permanent, reusable tools. By integrating the Gemini CLI with a gas-fakes sandbox via an MCP server, we demonstrate how to securely add and manage these custom tools, reducing operational costs and improving efficiency. Introduction When using generative AI to create scripts, ensuring the secure execution of the generated code is critical.

A Collaborative Dialogue Between Gemini CLI and Copilot CLI Through MCP

Gists Abstract This article introduces a method for integrating Google’s Gemini CLI and GitHub’s Copilot CLI using the Model Context Protocol (MCP). By configuring one CLI as an MCP server, the other can invoke it from a prompt, enabling a powerful, collaborative interaction between the two AI assistants for enhanced development workflows. Introduction Recently, GitHub released the Copilot CLI, a command-line interface that brings the power of GitHub Copilot directly to your terminal.

Secure and Conversational Google Workspace Automation: Integrating Gemini CLI with a gas-fakes MCP Server

Gists Abstract This article introduces a method for securely executing AI-generated Google Apps Script. By implementing a “fake-sandbox” using the gas-fakes library as an MCP server, users can empower the Gemini CLI to safely automate Google Workspace tasks with granular, file-specific permissions, avoiding significant security risks. Introduction “Have you ever faced a task that isn’t part of your routine but is tedious to do manually, like, ‘I need to add a “[For Review]” prefix to the titles of all Google Docs in a specific folder this afternoon’?