skills.rest
henkisdabro
henkisdabroCOMMUNITY
Explore all skills by this author →
Website𝕏@henkisGitHub

google-apps-script

Automate Google Workspace tasks across Sheets, Docs, Gmail, and Drive.

77|9|Updated Oct 10, 2025
Search Tags:#automation#workflow#productivity#Google Sheets#JavaScript#Google Drive#Gmail#Google Apps Script
One-click install
npx skills add https://github.com/henkisdabro/wookstar-claude-code-plugins --skill google-apps-script
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-apps-script
Source: https://github.com/henkisdabro/wookstar-claude-code-plugins/tree/main/google-apps-ads-script/google-apps-script
Command: npx skills add https://github.com/henkisdabro/wookstar-claude-code-plugins --skill google-apps-script

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes assets (resource) and references (resource) and scripts (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance for automating repetitive tasks across Google Workspace, eliminating manual data entry, report generation, and email management. It empowers users to build custom solutions that save significant time and reduce human error in daily operations.

Core Features & Use Cases

  • Google Sheets Automation: Read, write, format, and manipulate data in Google Sheets for reporting and data processing.
  • Gmail & Drive Management: Automate email sending, search, and organization, along with file and folder operations in Google Drive.
  • Event-Driven Triggers: Implement time-based or event-based triggers (e.g., on form submit, on spreadsheet edit) for hands-free automation.
  • Use Case: You need to generate a weekly sales report from a Google Sheet and email it to your team. Use this skill to write an Apps Script that automatically pulls data, formats it, and sends the email every Monday morning, freeing up your time for more strategic tasks.

Quick Start

Write a Google Apps Script to read data from 'Sheet1' in the active spreadsheet and send an email with a summary.

Frequently Asked Questions about google-apps-script

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Google Sheets data processing and reporting?▼

Google Apps Script reads, writes, and formats data in Google Sheets for automated reporting. Write a script to pull data, perform calculations, and generate formatted reports without manual intervention.

Can I send automated emails from Google Sheets or Gmail?▼

Yes. Google Apps Script automates email sending through Gmail, allowing you to compose, send, and manage messages triggered by spreadsheet changes, form submissions, or scheduled times.

What's the best way to set up event-driven automation in Google Workspace?▼

Google Apps Script implements time-based and event-based triggers—such as on form submit or spreadsheet edit—to execute custom functions automatically without manual execution.

How do I manage files and folders in Google Drive programmatically?▼

Google Apps Script automates file and folder operations in Google Drive, including create, read, move, and organize actions, integrated with Sheets, Docs, and other Workspace apps.

Can I call external APIs from Google Apps Script?▼

Yes. Google Apps Script includes UrlFetchApp to make external API calls, enabling integration with third-party services and retrieval of data outside Google Workspace.

Do I need to know advanced programming to build Google Workspace automation?▼

Google Apps Script uses JavaScript and provides built-in methods for common tasks, making it accessible to users with basic scripting knowledge while supporting ES6+ for advanced use cases.

Related Skills

Explore More Software Engineering Skills→
Wike-CHIWike-CHI
2

gog

Search and retrieve information from Google Workspace services via CLI.

Community
Intermediate
ano4lano4l

data-export

Generate Swift data export/import infrastructure for JSON, CSV, and PDF formats.

Community
Advanced
suchintansuchintan
1

google-workspace

Manage Google Workspace tasks via the gws CLI.

Community
Intermediate
StarrySerendipityStarrySerendipity

webapp-testing

Automate end-to-end testing of local web apps with Playwright in Python.

Community
Intermediate