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.

主な機能

Comprehensive Workspace API support for Sheets, Docs, Gmail, Drive, and Calendar
Automated trigger management for time-based and event-driven execution
Secure OAuth scope handling and PropertiesService for persistent configuration
8 GitHub stars
Performance optimization via batch operations and CacheService implementation
External API integration patterns using UrlFetchApp and JSON processing

ユースケース

Generating automated weekly reports and data summaries from Google Sheets
Programmatically creating documents and PDF invoices from Google Doc templates
Building custom Gmail auto-responders and automated label management workflows

概要

主な機能

Comprehensive Workspace API support for Sheets, Docs, Gmail, Drive, and Calendar
Automated trigger management for time-based and event-driven execution
Secure OAuth scope handling and PropertiesService for persistent configuration
8 GitHub stars
Performance optimization via batch operations and CacheService implementation
External API integration patterns using UrlFetchApp and JSON processing

ユースケース

Generating automated weekly reports and data summaries from Google Sheets
Programmatically creating documents and PDF invoices from Google Doc templates
Building custom Gmail auto-responders and automated label management workflows