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
Created May 16, 2025 06:19
Building Agent2Agent (A2A) Server with Google Apps Script

Building Agent2Agent (A2A) Server with Google Apps Script

Abstract

Exploring Agent2Agent (A2A) protocol implementation in Google Apps Script seamlessly allows AI agents to access Google Workspace data and functions. This could enable complex workflows and automation, overcoming platform silos for integrated AI applications.

Introduction

@tanaikech
tanaikech / submit.md
Last active May 12, 2025 07:02
Managing Tables on Google Sheets using Google Apps Script

Managing Tables on Google Sheets using Google Apps Script

Abstract

Google Sheets API now supports programmatic table management (create, delete, modify) as of April 29, 2025. This eliminates previous workarounds and enables direct control, including with Apps Script.

Introduction

@tanaikech
tanaikech / submit.md
Created May 10, 2025 05:10
Image Transfer: MCP Server (Web Apps/Google Apps Script) to MCP Client (Gemini/Python)

Image Transfer: MCP Server (Web Apps/Google Apps Script) to MCP Client (Gemini/Python)

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. It introduces a practical method for transferring image data efficiently from the Google Apps Script-based MCP server to an MCP client. In this implementation, the MCP client was built using Python and integrated with the Gemini model, allowing for the processing and utilization of the transferred image data alongside text, the

@tanaikech
tanaikech / submit.md
Created May 8, 2025 06:31
Building Model Context Protocol (MCP) Server with Google Apps Script

Building Model Context Protocol (MCP) Server with Google Apps Script

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

@tanaikech
tanaikech / submit.md
Created May 1, 2025 05:51
Analyzing Google Apps Script from Stackoverflow

Analyzing Google Apps Script from Stackoverflow

Abstract

The report details a novel Gemini API method to analyze big data beyond AI context window limits, which was validated with Stack Overflow data for insights into Google Apps Script's potential.

Introduction

@tanaikech
tanaikech / submit.md
Last active May 1, 2025 05:25
Comprehensive Big Data Processing with Gemini

Comprehensive Big Data Processing with Gemini

Abstract

Generative AI faces limits in processing massive datasets due to context windows. Current methods can't analyze entire data lakes. This report presents a Gemini API approach for comprehensive big data analysis beyond typical model limits.

Introduction

@tanaikech
tanaikech / submit.md
Last active April 15, 2025 04:45
Integrating Gemini and Google Apps Script for Automated Google Slides Presentations

Integrating Gemini and Google Apps Script for Automated Google Slides Presentations

Abstract

Learn how Gemini AI and Google Apps Script automate Google Slides generation. A developed application demonstrates this synergy, streamlining initial presentation drafting and showcasing AI's automation potential within Google Workspace.

Introduction

The field of AI, particularly large language models like Google's Gemini, is advancing rapidly. A powerful application of this technology involves integrating Gemini with Google Apps Script. Google Apps Script provides a seamless way to automate tasks across Google Workspace by natively handling authorization and interaction with services like Google Docs, Google Sheets, and Google Slides. By combining Gemini's generative capabilities with Apps Script, sophisticated automations become accessible.

@tanaikech
tanaikech / submit.md
Created April 3, 2025 02:16
Stowage Planning Automation Using Gemini: A Feasibility Study and A Prompt-Based Approach

Stowage Planning Automation Using Gemini: A Feasibility Study and A Prompt-Based Approach

Abstract

Gemini 2.5 Pro Experimental enabled automated cargo ship stowage planning via prompt engineering, overcoming prior model limitations. This eliminates the need for complex algorithms, demonstrating AI's potential in logistics.

Introduction

@tanaikech
tanaikech / submit.md
Last active April 1, 2025 07:35
Roadmap Generator as Gemini

Roadmap Generator as Gemini

Abstract

Gemini and Google Apps Script automate project roadmap creation in Google Sheets, including Gantt charts, improving efficiency and agile planning.

Introduction

@tanaikech
tanaikech / submit.md
Last active April 7, 2025 02:17
Enhanced Text Manipulation in Google Slides using Google Apps Script

Enhanced Text Manipulation in Google Slides using Google Apps Script

Description

This is a sample Google Apps Script designed to replace all instances of specific text within a Google Slides presentation, while simultaneously applying a desired text style. The built-in Presentation.replaceAllText() method within the Google Slides service is limited; it efficiently replaces text strings but lacks the functionality to modify text formatting during the replacement process. This limitation poses a challenge when aiming for styled text replacements. This report presents a detailed script solution that overcomes this constraint. The script iterates through all text elements within the slides, identifies matching text, and performs a replacement. Crucially, it also applies specified text formatting attributes, such as font, font size, color, and bold/italic settings, to the replaced text. This enhanced functionality allows users to maintain c