Gists

Turn Google Sheets into a Fully Interactive, Differential ACID Mutation Console for Apache Iceberg without Reverse ETL SaaS or Cloud Servers.

Hero Infographic: Interactive Bidirectional Lakehouse Writeback via Google Sheets & Apache Iceberg. Enables business operators to query filtered records from an open Apache Iceberg table on Google Cloud Storage, visually edit values, add new rows, or purge obsolete records directly within a Google Sheets grid with an embedded dark-themed console, and commit atomic, microsecond-tolerant ACID mutations back to Parquet storage via BigQuery without Reverse ETL SaaS or persistent servers.

Gists

Turn Google Drive into an AI-Powered Lakehouse Vector Engine across Converted PDFs, Binary Images, and Text without Specialized Vector Databases.

Hero Infographic: Unified Multimodal Lakehouse Vector Search via Apache Iceberg & Google Apps Script. Consolidates Google Docs, Sheets, Slides, Forms, binary diagrams, and web-fetched assets into an open Parquet table, driven by Gemini embeddings and BigQuery serverless pushdown for sub-second semantic retrieval and live Google Drive discovery.

Gists

Turn Google Sheets into a Petabyte Lakehouse with Sub-Second ACID Queries.

Abstract

Google Sheets faces severe scalability bottlenecks when handling large enterprise datasets, including a strict 10-million cell limit, crippling CRUD latency, and Google Apps Script’s execution and memory boundaries. This article presents IcebergApp, an open-source library bridging Google Workspace to Apache Iceberg lakehouses on Google Cloud. By utilizing BigQuery as a serverless query accelerator to execute predicate pushdown over Iceberg metadata, IcebergApp eliminates spreadsheet latency, ensures ACID transactions, and enables sub-second queries, time travel, and agentic AI integration directly from Google Apps Script.

Gists

Published Paper: Capturing Volcanic Lamb Waves and Blast Yields with Netatmo Weather Networks (ESS Open Archive)

Abstract

Explosive volcanic eruptions generate powerful atmospheric Lamb waves—acoustic-gravity waves trapped in the planetary boundary layer that travel horizontally across the globe at sound speed. Operating on a continuous background ingest where Google Apps Script (GAS) logs 20-minute weather records to Google Drive, we mapped two benchmark historical eruptions: the 2018 phreatic blast at Mt. Kusatsu-Shirane and the 2018 magmatic explosion at Mt. Shinmoedake. We framed these events within first-principles continuum mechanics inside the Antigravity CLI environment powered by Gemini and the autonomous R&D framework tanaike-lab. Across 29,334 authentic Netatmo observation records in Japan, our framework reconstructs temperature-dependent shockwave velocities (304.38 m/s in sub-zero winter air and 313.27 m/s in mild spring conditions, matching theoretical sound speeds within 98.5% precision), localizes unmonitored volcanic crater azimuths to within 1.78 degrees, quantifies explosive yields (178.8 to 1,041.1 tons of TNT equivalent), and delivers 2.5 to 15 minutes of advance early warning with 100% false alarm elimination (0.0% False Positive Rate) during violent storm baselines. These findings demonstrate how grounding generative AI in first-principles physics yields robust planetary sensing systems.

Gists

Breaking the Limits of GAS with Direct Cloud-to-Cloud Streaming in Persistent Linux Sandboxes

Abstract

While Google Apps Script (GAS) is a powerful tool for Google Workspace automation, platform and computational constraints often limit its ability to handle advanced workloads. Gemini Managed Agents provide remote Linux sandboxes equipped with bash execution. This article introduces an architecture integrating GAS with a Linux sandbox to execute tasks beyond the capabilities of Apps Script alone. By streaming generated artifacts directly from within the Linux sandbox to Google Drive, this approach bypasses API payload limits, eliminates token overhead, and achieves high-throughput cloud automation.

Gists

Abstract

Generative AI and autonomous agents do not obsolete Google Apps Script (GAS); they elevate it into an indispensable deterministic execution substrate. This article establishes an enterprise hybrid architecture dividing responsibilities between AI’s probabilistic reasoning (the brain) and GAS’s secure, zero-cost, event-driven execution (the nervous system). Through 12 production use cases—spanning MCP servers, deterministic guardrails, and hybrid batching—we formalize four foundational principles for engineering resilient, scalable Google Workspace automations.

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 antigravity-cli-check-usage-plugin, a CLI Agent Hook running outside the LLM execution turn. Directly querying local Connect RPC endpoints, it monitors quota with zero token overhead and injects proactive warning banners when threshold limits are reached.

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 weather data. Executed on Antigravity CLI with Gemini 3.6 Flash using the autonomous R&D framework tanaike-lab, this project integrates 71,107 authentic Netatmo observation records with seismic moment tensors ($M_{ij}$). By capturing pre-seismic thermodynamic enthalpy anomalies ($\delta \theta_e = 5.96\text{--}15.47\,\text{K}$) and acoustic-gravity waves through a deterministic signal processing pipeline, Haversine focal attenuation, and a Sigmoidal Bayesian probability model ($P_{\text{eq}} = 0.0\%\text{--}99.8\%$), this framework delivers 2 to 6 hours of advance lead time with 100% false alert elimination in non-epicentral regions. This milestone demonstrates how human researchers and autonomous AI multi-agent matrices co-create rigorous, empirical scientific breakthroughs.

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 automation.

Introduction

Gemini Spark was officially announced at Google I/O 2026 on May 19, 2026, and its service in Japan began on July 16, 2026. Ref Gemini Spark is Google’s first always-on AI agent that runs continuously in the cloud 24/7, even when your PC is closed, to complete tasks on your behalf. Unlike traditional Q&A-style chat AIs, it can autonomously execute complex workflows across multiple Google applications. Its core functionalities are built around three main pillars: Tasks, Skills, and Schedules.

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 that draws new scientific realities out of the dark void.

Introduction

The modern scientific research engine faces a nuanced challenge. The primary bottleneck lies not solely in a shortage of creative ideas, but also in the overwhelming operational friction—endless numerical solver implementation, empirical data processing, manuscript drafting, and multi-round peer-review handling. Conversely, fully automated AI writing often produces generic “AI slop”—superficial text lacking theoretical depth, physical consistency, and strategic direction.