Skip to content

Instantly share code, notes, and snippets.

View tanaikech's full-sized avatar

Kanshi TANAIKE tanaikech

View GitHub Profile
@tanaikech
tanaikech / submit.md
Last active July 12, 2025 02:28
Next-Level Data Automation: Gemini CLI, Google Sheets, and the Model Context Protocol

Next-Level Data Automation: Gemini CLI, Google Sheets, and MCP

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. The article provides practical examples and sample prompts to illustrate the seamless workflow and potential for building sophisticated, AI-powered applications within the Google Cloud ecosystem.

Introduction

@tanaikech
tanaikech / submit.md
Created July 9, 2025 06:25
Gemini CLI: Featuring an Enhanced ToolsForMCPServer

Gemini CLI: Featuring an Enhanced ToolsForMCPServer

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

@tanaikech
tanaikech / submit.md
Last active July 8, 2025 06:30
Processing File Content Using Gemini CLI with an MCP Server Built by Google Apps Script

Processing File Content Using Gemini CLI with an MCP Server Built by Google Apps Script

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

@tanaikech
tanaikech / submit.md
Created July 3, 2025 06:49
Gemini CLI with MCP Server: Expanding Possibilities with Google Apps Script

Gemini CLI with MCP Server: Expanding Possibilities with Google Apps Script

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. We provide setup instructions and several practical examples showcasing how this integration unlocks significant potential for automation and productivity enhancement.

Introduction

@tanaikech
tanaikech / submit.md
Created June 27, 2025 07:16
Gemini CLI with MCP Server Built by Web Apps of Google Apps Script

Gemini CLI with MCP Server Built by Web Apps of Google Apps Script

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.

@tanaikech
tanaikech / submit.md
Created June 26, 2025 03:02
A Practical Analysis of the Gemini API's URL Context Tool

A Practical Analysis of the Gemini API's URL Context Tool

Introduction

The Gemini API recently introduced the URL context tool, a feature designed to allow the model to directly fetch and utilize content from specified URLs to ground its responses. Ref

This report provides a practical demonstration of this tool's capabilities. We will investigate its impact on two critical aspects of AI model interaction: the accuracy of the generated response and the total token consumption, which directly affects API costs.

@tanaikech
tanaikech / submit.md
Last active June 23, 2025 19:18
Managing Smart Chips on Google Sheets with Sheets API

Managing Smart Chips on Google Sheets with Sheets API

Overview

Google Sheets now supports managing smart chips via its API, enabling retrieval and placement with Apps Script and other languages.

Description

@tanaikech
tanaikech / submit.md
Created June 19, 2025 02:20
Consolidating Generative AI Protocols: A Single Server Solution for MCP and A2A

Consolidating Generative AI Protocols: A Single Server Solution for MCP and A2A

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

@tanaikech
tanaikech / submit.md
Created June 16, 2025 01:38
Growing Image Generation with Gemini API: Python and Node.js Now Supported

Growing Image Generation with Gemini API: Python and Node.js Now Supported

Abstract

This article announces that the Gemini API's Python client library now supports "growing image" generation, a feature previously unavailable. Sample scripts for Python and Node.js are provided to demonstrate this new capability.

Introduction

@tanaikech
tanaikech / submit.md
Created June 12, 2025 06:17
Gmail Processing using MCP Network Powered by Google Apps Script

Gmail Processing using MCP Network Powered by Google Apps Script

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