tanaike

The Thinker

Fields Builder for Google APIs: Visualizing Partial Responses

Gists Abstract Fields Builder for Google APIs is a client-side web application that streamlines constructing the fields parameter. It parses Discovery documents into interactive trees, enabling developers to visually select nested resources, implement Partial Response, and optimize API payload sizes without manual syntax errors. Introduction FieldsBuilderForGoogleAPIs is a specialized Web Application designed to streamline the construction of the fields parameter for Google APIs. Since the update of the official Google API Explorer, developers have found it increasingly difficult to visually construct the fields parameter.

Agentic Automation in Google Workspace: Bridging Antigravity and Gemini 3.0

Gists Abstract This article explores automating Google Workspace by integrating Google Antigravity and Gemini 3.0 with Model Context Protocol (MCP) servers. We demonstrate how to overcome tool limits and utilize custom extensions to enable AI agents to securely execute scripts, manage files, and perform RAG-based tasks using private data. Introduction Google Antigravity and Gemini 3.0 are ushering in a new era of “Agent-First” development, transforming how we interact with cloud environments.

Next-Generation Google Apps Script Development: Leveraging Antigravity and Gemini 3.0

Gists Abstract This article demonstrates a cutting-edge workflow for Google Apps Script development using Google Antigravity and Gemini 3.0. By integrating gas-fakes via the Model Context Protocol (MCP), we establish an environment where autonomous agents can generate, unit-test, and execute cloud-based scripts locally, revolutionizing the standard GAS development lifecycle. Introduction Google Antigravity has officially been released. Ref This is a revolutionary “Agent-first” IDE powered by Gemini 3, designed to empower autonomous AI agents to plan, code, and verify tasks across the Editor, Terminal, and Browser.

GAS Library - TableApp

Overview TableApp is a Google Apps Script library for managing Tables on Google Sheets. Description Recently, a new feature “Tables” was introduced to Google Sheets. Tables allow users to group data into structured tables with headers, filtering, and specific data types. While these can be managed via the Google Sheets API (v4), constructing the raw JSON requests for operations like creating, updating, and managing tables can be complex. This library, TableApp, creates an object-oriented wrapper around the Google Sheets API, making it easy to manage Tables directly within Google Apps Script.

Simplify Google Sheets Tables Management with Google Apps Script

Gists Abstract This article introduces “TableApp,” a Google Apps Script library designed to simplify managing Google Sheets Tables. It addresses the complexity of the native Sheets API, providing an intuitive interface for creating, updating, and manipulating tables. Sample scripts and installation guides are included to ensure easy implementation. Introduction The introduction of Tables in Google Sheets has significantly enhanced data management capabilities. While these tables can be managed via the Sheets API, the process is often complex and verbose.