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.
Introduction
On StackOverflow, millions of developers engage in daily knowledge exchange, creating a historical repository of technological evolution. A prime example of this ecosystem is the google-apps-script tag. Having participated in this community for years, I have observed its threads evolve in tandem with Google’s platform updates.
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.
Total view counts: 8,087
Gists
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
Generative AI models face significant limitations when processing massive datasets, primarily due to the constraints imposed by their fixed context windows. Current methods thus struggle to analyze the entirety of big data within a single API call, preventing comprehensive analysis. To address this challenge, I have developed and published a detailed report presenting a novel approach using the Gemini API for comprehensive big data analysis, designed to operate effectively beyond typical model context window limits. Ref
URL: https://stackoverflow.com/users/7108653/tanaike?tab=answers&sort=newest
This is the statistics of my activities from 2024-01-01 - 2024-12-31 on Stackoverflow.
Total view counts: 186,104
Gists
Abstract
A new large language model (LLM) called Gemini with an API is now available, allowing developers to analyze vast amounts of data. This report explores trends in Google Apps Script by using the Gemini 1.5 API to analyze questions on Stack Overflow.
Introduction
The release of the LLM model Gemini as an API on Vertex AI and Google AI Studio has opened a world of possibilities. Ref The Gemini API significantly expands the potential of various scripting languages, paving the way for diverse applications. Additionally, Gemini 1.5 has recently been released in AI Studio. Ref We can expect the Gemini 1.5 API to follow suit soon.
It seems that this is due to Planned network maintenance scheduled for Friday, October 1 at 01:00-04:00 UTC (Thursday, September 30 at 9:00 PM-midnight EDT).
This is a script for sending an email when users got comments at Stackoverflow. I had wished I could get an email when I got a comment at Stackoverflow. Although I investigated about this, it seems that I can get the email every 3 hours. For this situation, I wished I could get it much earlier. I thought that this can be achieved using GAS and Stack Exchange API. So I created this script. The features of this script are as follows.