Recent content on tanaike - Google Apps Script, Gemini API, and Developer Tips
Gists Solving the LLM quota monitoring paradox with zero-overhead local Connect RPC agent hooks. Abstract Google Antigravity CLI users using Google OAuth face abrupt task failures when API quota hits 0%, while account switching triggers unrecoverable signature errors. Querying quota via LLM tool calls creates a paradox by consuming the very tokens being monitored. We resolve this with…
Gists Published Paper : Unification Theory of Lithosphere-Atmosphere-Ionosphere Coupling via Acoustic-Gravity Waves (LAIC-AGW) and Quantitative Pre- and Post-Seismic Anomaly Verification Using Ultra-Dense IoT Weather Sensor Networks (ESS Open Archive) Abstract We announce the publication of our updated manuscript on ESS Open Archive, establishing the Unified LAIC-AGW Theory using ultra-dense IoT…
Gists Abstract Gemini Spark, Google’s 24/7 autonomous AI agent, seamlessly connects with Google Workspace. However, connecting to arbitrary external APIs requires extended integration. This article demonstrates how integrating Google Apps Script (GAS) as a Model Context Protocol (MCP) server or Webhook endpoint expands Gemini Spark’s capabilities, enabling enterprise-grade workflow…
Gists System Enforces Order, AI Accelerates Logic: Driving Next-Generation R&D Through Human-AI Co-Creation Abstract This case study presents the zero-to-one execution of an urban torrential rain fluid dynamics research project using Gemini and tanaike-lab on Antigravity CLI. By uniting system order, AI-accelerated logic, and clear human imagination, we demonstrate a next-generation R&D paradigm…
Gists Abstract This article introduces Robust-GAP , a hierarchical Retrieval-Augmented Generation (RAG) framework designed to eliminate semantic hallucinations and knowledge drift during multi-document log summarization. By combining dynamic causal graph extraction (DLCE), active topology verification (SGAV), and metadata provenance propagation (PAPP), the framework enforces strict citation…
Gists Today, on July 16, 2026, the Antigravity CLI was updated to version v1.1.3 . Following this update, I encountered a critical issue: after entering any prompt, the execution state falls into an infinite loop. The status messages (such as “Loading…”, “Generating…”, and “Working…”) cycle indefinitely, and no content is ever generated. Is…
Gists Have you ever had a brilliant solution get completely crushed by a single comment on a technical blog post? Just last week, on July 8, 2026, I published a post introducing the Pyramid Aggregator . It was a beautiful story of technical lineage: we took a string summation algorithm originally designed on October 13, 2016 (to optimize Google Apps Script) and applied it to modern Large Language…
Gists Have you ever tried to read a massive pile of reports and summarize them in under 50 words? It’s hard. Now, imagine asking a cutting-edge Large Language Model (LLM)—like Gemini—to do it. You might think AIs have perfect memories, but they don’t. When forced to aggregate information from dozens of documents under strict length constraints, AIs suffer from severe “memory…
Gists Abstract Executing autonomous AI agent payloads in Google Workspace via the Apps Script API ’s scripts.run method introduces severe security risks. This article presents a novel sandboxing proposal designed specifically for the scripts.run method, using ggsrun as the orchestrator to execute code safely and efficiently. By performing in-memory token replacement and uploading a separate,…
Gists Motivation To be quite honest, “Hooks”—the shell commands we trigger at specific points when generative AI agents process tasks—were something I used blindly for a long time. Whenever colleagues asked me about them, I realized I lacked any real confidence in explaining how they actually work. However, when I migrated from Gemini CLI to the new Antigravity CLI, I noticed that the…
ggsrun was updated to v5.3.7. v5.3.7 (June 2026) - Simplified Quick Onboarding, On-demand Setup Prompting, Optional Credentials Path, and Seamless Configuration Initializer Introduced the groundbreaking, extremely easy-to-use $ ggsrun setup onboarding command to dramatically simplify Google Cloud API and OAuth2 credentials setup, while keeping traditional $ ggsrun auth fully intact for backward…
GASADK was updated to v2.0.0 v2.0.0 (June 24, 2026) Exposed Google Workspace APIs as a Dynamic MCP/A2A Server. Added a standalone deployment script ( DeployMcpServer.js ) under samples/googleapiapp-mcp-server to expose the GoogleApiApp library. Created a detailed beginner-friendly guide for configuring and deploying Google Workspace services (Sheets, Drive, Docs, Calendar, Gmail, etc.) as dynamic…
ggsrun was updated to v5.3.3. v5.3.3 (June 2026) - Recursive Directory Walk, Safe Interactivity & GAS Zip Download Enhanced updateproject (alias ud ) command to recursively traverse folders specified via -f / --filename to batch overwrite remote GAS projects. Prints targeted local files in a beautiful bullet list using pterm.BulletListPrinter and requires explicit interactive confirmation (Y/N) in…
ggsrun was updated to v5.3.0. v5.3.0 (June 2026) - Responsive TUI Filer (FD Mode) Enhancements, Focus Persistence, and Platform Compatibility Fixes Refactored TUI Filer (FD Mode) popup layouts using tview.Flex to center dialogs (errors, sorting, details, help) and prevent text clipping. Implemented focus locking to preserve active panel focus post-action. Added wrap-around to lists and mapped the…
Gists Abstract This article explores the integration of Google Workspace with the Antigravity CLI, the high-performance successor to the legacy Gemini CLI. This integration is critical because it bridges the gap between low-latency, local agent execution and cloud-native enterprise productivity platforms. We demonstrate this framework by evaluating five core developer tools—the Google Workspace…
Gists Abstract This paper presents a serverless architecture that overcomes the stateless nature and 6-minute execution limit of Google Apps Script (GAS). By configuring a 1-second immediate timeout in UrlFetchApp loopback calls, an orchestrator dispatches background tasks and terminates immediately. This design frees up the caller’s execution quota while the target Web App runs to…
GASADK was updated to v1.3.0 v1.3.0 (June 3, 2026) Added Custom Server Name Routing to specify user-defined server names as aliases in MCP and A2A configurations. Supports string URLs or custom JSON objects (with custom server names as keys and URL configurations as values) in mcpServers and a2aServerAgentCardURLs . You can see the detail information here https://github.com/tanaikech/adk-gas
Gists Abstract Configuring complex time-driven triggers in Google Apps Script—such as executing tasks exclusively on weekday mornings—is notoriously intractable programmatically and strictly impossible via the standard UI. TriggerApp mitigates this architectural friction through a declarative JSON engine, allowing developers to completely bypass granular date-math logic. Now, by embedding a native…
v5.0.0 (May 2026) - The Omnibus Architecture Rewrite Engine fundamentally rewritten for Go 1.26.3+. Implemented channel-based concurrency ( errgroup ), freeze-proof TUI ( mpb/v8 ), SIMD JSON parsing ( goccy/go-json ), native MCP server ( ggsrun mcp ), Shared Drives full-support, auto MIME-mapping, isolated fault tolerance, and OAuth2 loopback automation. You can check ggsrun at…
v3.2.2 (May 27, 2026) Critical Progress Bar Lifecycle Fix : Fixed a bug where indeterminate file sizes (such as Google Docs exports returning 0 size from the Drive API) caused the progress bar spinners to hang infinitely. Bar completion is now strictly enforced ( SetTotal(-1, true) ) upon IO completion. Resource Leak Patches : Hardened HTTP body and local file descriptor management using strictly…
Gists Abstract Integrating autonomous AI agents into enterprise architectures exposes critical security and latency vulnerabilities. The Autonomous Google API Agent (AGAA) solves this by enforcing a deterministic, zero-trust execution framework directly within Google Apps Script (GAS). By merging GASADK, dynamic REST endpoint resolution via GoogleApiApp, and the Developer Knowledge API through the…
Overview GASADK is a groundbreaking Agent Development Kit tailored specifically for the resource-constrained Google Apps Script environment. Driven by a deterministic Planner-Executor-Synthesizer (PES) architecture, it effectively bypasses traditional async Node.js assumptions to overcome the absolute 6-minute execution limit and synchronous blocking networking ( UrlFetchApp ). Featuring dynamic…
Gists Abstract Google’s Agent Development Kit (ADK) revolutionizes autonomous AI agents, yet its standard Node.js-based asynchronous ReAct architecture is fundamentally incompatible with the restrictive, synchronous, and time-bound execution environment of Google Apps Script (GAS). To unlock enterprise-grade AI natively within Google Workspace, this paper introduces GASADK. By abandoning the…
GeminiWithFiles was updated to v2.0.16 v2.0.16 (May 7, 2026) Introduced invoke_agent functionality to Agent Skills. Enabled subagent orchestration, allowing parent agents to spawn independent executing contexts (Subagents) for specialized tasks without polluting the main conversation history. You can see the detail information here https://github.com/tanaikech/GeminiWithFiles
MoveFolder was updated to v1.0.3. v1.0.3 (May 06, 2026) Refactored the core script for better performance, safety, and readability. Enhanced error handling: The script now strictly verifies if file moves were successful before deleting any original source folders, preventing accidental data loss if permission errors occur. Introduced parallel processing using UrlFetchApp.fetchAll for much faster…
Gists Implementing Progressive Disclosure in Google Apps Script Motivation for Writing As an active researcher and developer in the AI ecosystem, I have seamlessly integrated Agent Skills into daily workflows using tools like Claude Code, Gemini CLI, and Antigravity. However, I observed a pervasive tendency in the developer community—and initially within my own practice—to treat these capabilities…
GeminiWithFiles was updated to v2.0.15 v2.0.15 (May 6, 2026) Refactored the script entirely. Added support for Agent Skills (Progressive Disclosure architecture). You can now build autonomous agent workflows using skills stored in Google Drive. Added the skillFolderId property to the geminiWithFiles constructor to automatically discover skills, register necessary functions ( activate_skill ,…
Gists Abstract As Large Language Model (LLM) agents increasingly integrate numerous external systems, they suffer from Tool Space Interference (TSI), a phenomenon causing context bloat, attention dilution, and degraded reasoning accuracy. In this paper, we introduce the Agent-as-a-Tool paradigm—an evolutionary, practical implementation of the recently proposed Self-Optimizing Tool Caching Network…
Gists A Comparative Study of Agentic Frameworks and Multi-Agent Orchestration Abstract The transition from passive chatbots to autonomous execution environments was cemented at Google Cloud Next ‘26 with the introduction of the Gemini Enterprise Agent Platform. This paper evaluates four cutting-edge AI agent methodologies for Google Workspace automation, developed by leading developers…
Gists Abstract Welcome to the Agentic Enterprise era. This article explores a paradigm shift in generative AI workflows by introducing an autonomous agent capable of dynamically creating, testing, and executing original tools. Utilizing Google Apps Script, Node.js emulation, and multi-agent orchestration, this architecture overcomes traditional limitations, enabling highly adaptable task…
Gists Abstract Explore how to build and orchestrate production-ready, type-safe AI agents using Google’s TypeScript Agent Development Kit (ADK). This guide provides practical scaffolding patterns, multi-agent coordination strategies, and seamless integration techniques for deploying remote subagents within the Gemini CLI ecosystem. Introduction As the artificial intelligence landscape…
Gists Abstract This article explores integrating remote subagents built with Google Apps Script into the Gemini CLI using the Agent-to-Agent (A2A) protocol. It demonstrates how bypassing standard authentication via local agent cards enables seamless execution of complex workflows while effectively overcoming Tool Space Interference (TSI) for massive toolsets. Introduction Recently, remote subagent…
Gists Abstract Google Sheets recently introduced the SHEET and SHEETS functions. Because they automatically recalculate upon structural changes, developers can utilize them as custom triggers. This article demonstrates how to leverage these functions to detect sheet insertions, deletions, renames, and movements without requiring cumbersome installable triggers in Google Apps Script. Introduction…
Gists Abstract This paper presents a self-evolving framework, Recursive Knowledge Crystallization (RKC) , designed to overcome the “Catastrophic Forgetting” inherent in autonomous AI agents. By persisting evolved technical insights into a universally readable SKILL.md file based on the Agent skills specification, this approach establishes long-term memory and cross-platform…
Gists Abstract Discover how to seamlessly integrate Google Workspace with GitHub Actions using the gas-fakes library. This guide demonstrates running Google Apps Script locally and within CI/CD pipelines without deploying Web Apps. Automate workflows, secure credentials, and effortlessly interact with Google Drive and Sheets directly from your repository. Introduction Google Apps Script (GAS) is a…
I got an awarded for publishing a top Google AI post for this article. Recursive Knowledge Crystallization: A Framework for Persistent Autonomous Agent Self-Evolution
Gists Abstract In the development of autonomous agents using Large Language Models (LLMs), restrictions such as context window limits and session fragmentation pose significant barriers to the long-term accumulation of knowledge. This study proposes a “self-evolving framework” where an agent continuously records and refines its operational guidelines and technical knowledge—referred to…
Gists Abstract This article demonstrates how to build an adaptive learning agent using Agent-to-User Interface (A2UI), Gemini, and Google Apps Script. We explore a system that generates personalized quizzes, tracks performance in Google Sheets, and dynamically adjusts difficulty to maximize learning efficiency within the Google Workspace ecosystem. Introduction A2UI (Agent-to-User Interface)…
Gists Abstract This article explores A2UI (Agent-to-User Interface) using Google Apps Script and Gemini. By generating dynamic HTML via structured JSON, Gemini transforms Workspace into an “Agent Hub.” This recursive UI loop enables complex workflows where the AI builds the specific functional tools required to execute tasks directly. Introduction: The Evolution of AI Interaction The…
Gists Abstract This article details the development of Smart Stowage Optimizer , a web-based digital twin for logistics that bridges the gap between physical safety and artificial intelligence. By integrating Gemini 3 Pro , the system solves the 3D Bin Packing Problem (3DBPP) using advanced spatial reasoning. Built with React 19 and Three.js , the application visualizes physics-aware load…
Gists Abstract This article explores implementing the Agent-to-User Interface (A2UI) protocol within Google Apps Script. It demonstrates utilizing Gemini’s structured output to render secure, dynamic, server-driven UIs—like booking forms and event lists—directly inside Google Sheets, streamlining workflows without complex external infrastructure. Introduction I recently published a sample…
Gists Abstract The Gemini API now supports external file URLs, allowing developers to process data directly without uploading it first. This article demonstrates how to leverage this update to integrate Google Workspace resources—including Google Sheets, Docs, Slides, and Apps Script—into Gemini’s workflow, covering both public and secure private access methods. Introduction Recently, the…
Gists Abstract This article demonstrates how to implement Google’s A2UI (Agent-to-User Interface) using Google Apps Script (GAS). By porting official Python/TypeScript examples to GAS, we show how to create dynamic, AI-generated interfaces within Google Workspace, enabling flexible business automation and interactive user experiences without complex server infrastructure. Introduction Google…
Gists Published: January 3, 2026 Author: Kanshi Tanaike Abstract Analyzing StackOverflow data (2008–2026) reveals a massive activity decline post-ChatGPT. Using Google Apps Script as a case study, this report quantifies the migration from human support to AI. We explore how the platform is pivoting from a help desk to a critical verification layer for AI-generated code to prevent model collapse.…
URL: https://stackoverflow.com/users/7108653/tanaike?tab=answers&sort=newest This is the statistics of my activities from 2025-01-01 - 2025-12-31 on Stackoverflow. Answers to stackoverflow I answered 35 answers. On January 02, 2026, the total view count is 7,795. Answers to ja.stackoverflow I answered 1 answers. On January 02, 2026, the total view count is 292. Total view counts: 8,087
Gists Abstract This article introduces a Google Apps Script-based Agent2Agent architecture to solve Tool Space Interference. While the provided demonstration utilizes a single server for testing purposes, the architecture is designed for distributed task execution. By running multiple category-specific A2A servers in parallel, users can achieve scalable, high-efficiency agent networks.…
Gists Abstract Nexus-MCP resolves “Tool Space Interference” in Large Language Models by aggregating multiple MCP servers into a single gateway. Utilizing a strictly deterministic 4-phase workflow—Discovery, Mapping, Schema Verification, and Bridged Execution—it prevents context saturation and tool hallucinations, enabling the use of massive tool ecosystems without sacrificing reasoning…
UtlApp was updated to v1.0.12. v1.0.12 (December 12, 2025) Updated the method consolidateA1Notations . In the current version, the result is returned as an array. The array includes the combinations of the calculated result. The 1st element of the array is the best calculated result. You can see the detail information here https://github.com/tanaikech/UtlApp
Gists Abstract This article introduces a major update to gas-fakes enabling dynamic loading of Google Apps Script libraries. This enhancement allows developers to build modular, maintainable Model Context Protocol (MCP) servers. We demonstrate this by integrating sophisticated library-based tools with Gemini CLI and Google Antigravity for seamless Google Workspace automation. Introduction I…
Gists Abstract This article demonstrates how to build Model Context Protocol (MCP) tools directly using Google Apps Script. By leveraging the gas-fakes CLI, developers can execute Google Apps Script locally to automate Google Workspace via Gemini CLI and Google Antigravity, streamlining development and eliminating the overhead of dynamic tool creation. Introduction With the rapid advancement of…