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.
It’s that time of year again. Kanshi Tanaike has just released his seventh annual report on the state of the google-apps-script tag on Stack Overflow. The numbers show a massive drop in platform activity since late 2022, which Tanaike identifies as a “structural shift” from human support to Generative AI.
But if you’re like me, you’re probably wondering whether the community is actually shrinking or if we are just working differently.
It’s Not Just Automation; It’s “Vibe Coding”
Tanaike’s data points to a decline in question volume, suggesting that AI has taken over the routine heavy lifting. While that is part of the story, I believe there is a more nuanced explanation for those of us in the Apps Script world.
Rather than task automation I think it’s more about “vibe coding”. We are all using LLMs to prototype, troubleshoot, and get through that initial hurdle of “how do I even start this?”. AI is absorbing the iterative problem-solving that used to happen in public threads, effectively acting as a filter for the simpler questions that used to dominate the tag.
The Shift to a “Verification Layer”
One of the most interesting parts of the report is Tanaike’s argument that Stack Overflow is transitioning from a high-volume help desk to a high-quality Verification Layer.
As the web gets flooded with AI snippets, the value of the “ground truth” on Stack Overflow actually goes up. Tanaike noticed that while scripting languages saw a sharp drop in activity, enterprise-heavy languages like PHP and Swift held steady. To me, that is a clear sign of where AI still struggles. It can write a function, but it cannot always understand the deep architectural context of a complex legacy system. That remains a human-only job.
Maturation, Not Decline
AI is great at the first 80%. It handles the syntax and the boilerplate, but the remaining 20%, the part that actually makes a solution robust and secure, is where we come in. You can read more and make your own conclusions in Kanshi Tanaike’s post.
This is an amazing trend to watch; Not surprising mind you but amazing!