Automate Google Workspace with the google-apps-script Agent Skill

Where this fits

You're building an agent that helps a marketing team automate their Google Workspace: pulling metrics from Sheets, drafting emails in Gmail, and filing reports into Drive. Without a guide, the agent will guess at API names and authorization flows. This skill gives the agent a complete reference for Google Apps Script—covering every built-in service, triggers, OAuth, and performance—so it produces working code on the first try.

Why agents benefit

• Agent can generate correct Apps Script code for Sheets, Docs, Gmail, Drive, Calendar, Forms, and Slides without consulting external docs.
• It understands OAuth scopes and the authorization flow, so the agent can guide users through the consent screen properly.
• It handles time-based and event-based triggers correctly, avoiding common mistakes like missing onEdit signatures.
• It applies performance best practices like batch operations and CacheService to keep scripts within quota limits.
• It knows when not to use Apps Script—for example, Node.js scripts need a different runtime, preventing costly errors.

Practical scenarios

Automating a weekly sales report

The agent uses the skill to generate a script that pulls data from a specific tab in a Google Sheet, formats it, and emails a summary to the sales team via GmailApp—saving the developer from writing the boilerplate.

Populating a Google Doc from a template

An agent tasked with creating client proposals copies a template, replaces placeholders with data from a form submission, and exports as PDF—all using DocumentApp and DriveApp logic from the skill.

Setting up a trigger to archive old files

The agent writes a time-driven trigger that runs daily, moving files older than 30 days from a "Working" folder to an "Archive" folder, using PropertiesService to track the last run timestamp.

Add it to your agent workflow

Install the skill with:

npx skills add henkisdabro/wookstar-claude-plugins --skill google-apps-script

Then instruct your agent: "Use the google-apps-script skill to write a script that reads the last 10 rows from the 'Leads' sheet and sends a summary email to the address in cell A1." The agent will reference the skill's service APIs and OAuth notes to generate the code.

Compare before adopting

Before adding this skill, check if it covers the specific Google service you need most (it does cover all). Compare its depth against alternatives—does it explain error handling and batch operations, or just list APIs? Also consider maintenance: the README is clear about its scope and limitations, which is a good sign. Finally, verify it fits your agent's workflow—does it integrate with your existing skill loading?

Why it is worth tracking

The skill has 83 stars and an active repository, indicating community trust and ongoing updates. It's a comprehensive resource that fills a real gap for agent developers working on Google Workspace automation. Track it if you commonly build agents that interact with Google apps—it will save hours of debugging and API documentation reading. For a full overview, see the skill page on OpenAgentSkill.