gas-developer

What This Skill Does

The gas-developer skill turns OpenClaw into a powerful Google Apps Script (GAS) architect. It allows you to automate workflows across the Google Workspace ecosystem, including Sheets, Gmail, Calendar, Drive, and Forms. This skill provides expert-level assistance in writing, debugging, and deploying scripts that bridge the gap between static data and active automation. Whether you are building complex data processing pipelines in Sheets, setting up automated email notifications, or synchronizing calendar events based on external triggers, this skill manages the technical complexity of the Apps Script API, error handling, and trigger management.

Installation

You can integrate this capability into your OpenClaw environment by running the following command in your terminal or assistant interface: clawhub install openclaw/skills/skills/sa9saq/gas-developer. Once installed, ensure you have the necessary Google Cloud project permissions configured for the specific APIs you intend to access (e.g., Gmail API, Drive API).

Use Cases

1. Automated Reporting: Trigger daily scripts that aggregate data from multiple Google Sheets, generate summaries, and email them as PDF reports.
2. Client Management: Automatically create Calendar events when a new row is added to a 'Meeting Requests' Google Sheet.
3. Form-to-Action: Process Google Form responses in real-time to update project management tools or trigger external API notifications.
4. Data Syncing: Fetch data from external APIs via UrlFetchApp and pipe that information directly into a master Google Sheet for business intelligence.

Example Prompts

1. "I need a script that runs every morning at 8 AM to check my 'Pending Tasks' sheet; if a deadline is within 24 hours, send me a reminder email with the task details."
2. "Write a function that watches a specific folder in Google Drive, and when a new PDF is uploaded, logs its file ID and name into a tracking spreadsheet."
3. "Help me debug this GAS error: I'm getting a 'Service invoked too many times' message when trying to update my spreadsheet using a loop."

Tips & Limitations

• Efficiency: Always use batch operations (like getValues() and setValues()) instead of reading/writing to cells inside loops to avoid hitting execution time limits.
• Error Handling: Use the provided safeExecute pattern to wrap volatile API calls to prevent one failure from crashing your entire automation pipeline.
• Logging: Make aggressive use of Logger.log() during development. Since GAS runs on Google's servers, this is your primary way to inspect variable states.
• Quota Constraints: Be mindful of daily quotas for email sends and URL fetches, as these can vary depending on whether you are using a personal or Workspace account.