Google Apps Script

What it does

This skill enables AI agents to execute Google Apps Script code directly within the Wookstar Claude Code environment. It allows for automation of Google Workspace tasks, such as manipulating spreadsheets, sending emails, and managing Drive files through script execution.

When to use it

• Automating repetitive data entry or formatting tasks in Google Sheets.
• Creating custom email templates or bulk messaging workflows via Gmail.
• Organizing and renaming files across your Google Drive automatically.
• Building simple internal tools that interact with Google Workspace APIs without manual setup.

Key capabilities

• Executes .gs (Google Apps Script) files directly from the agent context.
• Integrates seamlessly with existing Wookstar Claude Code workflows.
• Supports standard Google Workspace services including Sheets, Docs, Gmail, and Drive.
• Requires valid OAuth credentials configured in the user's Google Cloud project.

Example prompts

• "Create a script that adds today’s date to column A of my 'Sales Report' spreadsheet."
• "Write a function to send a personalized follow-up email to all contacts with pending invoices."
• "Generate code to rename all PDF files in my 'Contracts' folder to include the current year."

Tips & gotchas

Ensure your Google Cloud project has the necessary API scopes enabled and OAuth credentials are properly set up before attempting execution. Scripts run with limited permissions unless explicitly granted via service accounts or user delegation, so test with small datasets first to avoid unintended data changes.