gf_agent

Skill: gf_agent

Overview

gf_agent is a specialized agent for automating Google Workspace tasks using the gas-fakes local emulation environment. It can generate and execute Google Apps Script (GAS) code locally on Node.js.

Capabilities

• Automate Workspace: Create, read, and modify Google Docs, Sheets, Slides, Forms, Drive files, and Calendars.
• Local Execution: Run scripts using @mcpher/gas-fakes to avoid needing a live Apps Script environment for every task.
• Service Integration: Seamlessly combine multiple Google services (e.g., fetch data from a Sheet and create a Doc).
• Mock/Real Parity: Write code that works both locally (using fakes) and on the real Google Apps Script platform.

Instructions

1. Understand and Orchestrate:
   • Identify required Google Apps Script services (e.g., SpreadsheetApp, DriveApp).
   • For multi-service or complex tasks, adopt the Orchestrator Pattern: Plan the task as a sequence of service-specific sub-tasks.
2. Research and Verify (Service Agent Phase):
   • For each service, first verify method existence by reading the local skills/{service}.md files in the skill directory.
   • If detailed method signatures or descriptions are needed, fetch the latest implementation details from the remote gas-fakes repository.
   • Remote URL: https://raw.githubusercontent.com/brucemcpherson/gas-fakes/main/progress/{service}.md (Note: {service} is lowercase, e.g., spreadsheet.md).
   • Use these details to construct precise, parity-compliant code without relying on external search engines unless documentation is missing.
3. Generate Script: Create a Node.js script that:
   • Uses standard GAS syntax.
   • (Optional) Uses ScriptApp.isFake for local-only logic like logging or cleanup.
4. Execute & Verify: Use the mcp_gas-fakes-mcp_workspace_agent tool to execute the code and report the results to the user.

Example Workflow

User: "Summarize the last 5 unread emails and save the summary to a new Google Doc." Agent:

1. Identify Services: GmailApp, DocumentApp.
2. Verify Methods:
   • Check skills/gmail.md and skills/document.md.
   • (Optional) Fetch progress/gmail.md and progress/document.md from GitHub for detailed signatures.
3. Generate Script:

   const threads = GmailApp.getInboxThreads(0, 5);
   let summary = 'Email Summary:\n\n';
   threads.forEach(t => {
     const msg = t.getMessages()[0];
     summary += `From: ${msg.getFrom()}\nSubject: ${msg.getSubject()}\n---\n`;
   });
   const doc = DocumentApp.create('Email Summaries');
   doc.getBody().appendParagraph(summary);
   console.log('Summary saved to Doc ID:', doc.getId());
   

4. Execute: Call mcp_gas-fakes-mcp_workspace_agent({ script: '...' }).
5. Report: Confirm completion and provide the Doc ID.