Can I use this skill to connect Google Sheets to external APIs?

Yes, the skill includes implementation patterns for UrlFetchApp, including error handling and retry logic for robust external API integrations.

How does this skill help with Google Apps Script performance?

It provides specific patterns for batch operations (reading/writing ranges at once) and caching strategies to minimize API calls and avoid execution timeout limits.

Does it support automated triggers?

Absolutely. It covers the setup of both simple and installable triggers, including time-based (cron-like) events and spreadsheet-driven actions like 'onEdit' or 'onFormSubmit'.

How are permissions and OAuth handled?

The skill provides guidance on defining minimal OAuth scopes in the appsscript.json manifest to ensure security and smooth authorization for end-users.

Google Apps Script Automation

Name: Google Apps Script Automation
Author: henkisdabro

byhenkisdabro

•

生産性とワークフロー

Automates Google Workspace services through scriptable workflows, batch operations, and event-driven triggers.

This skill empowers developers to build sophisticated automation workflows across the entire Google Workspace ecosystem, including Sheets, Docs, Gmail, and Drive. It provides deep technical guidance on managing API quotas, implementing event-based triggers, and optimizing performance through batch operations and caching. Whether you are building custom spreadsheet functions, automating email reports, or managing cloud-based file systems, this skill ensures best practices for authorization, persistent storage, and error handling within the Apps Script environment.

主な機能

01Comprehensive Workspace API support for Sheets, Docs, Gmail, Drive, and Calendar

02Automated trigger management for time-based and event-driven execution

03Secure OAuth scope handling and PropertiesService for persistent configuration

048 GitHub stars

05Performance optimization via batch operations and CacheService implementation

06External API integration patterns using UrlFetchApp and JSON processing

ユースケース

01Generating automated weekly reports and data summaries from Google Sheets

02Programmatically creating documents and PDF invoices from Google Doc templates

03Building custom Gmail auto-responders and automated label management workflows

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add henkisdabro/wookstar-claude-code-plugins google-apps-script

For use in Claude.ai and ChatGPT

Download Skill