skills.rest
dasgltd
dasgltdCOMMUNITY
Explore all skills by this author →
GitHub

apps-script-workflow

Deploy Google Apps Script projects locally with clasp and generate UI menus.

2|Updated Jun 29, 2026
Search Tags:#error handling#defensive programming#Google Apps Script#clasp#UI feedback#Apps Script
One-click install
npx skills add https://github.com/dasgltd/llm-skills --skill apps-script-workflow
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: apps-script-workflow
Source: https://github.com/dasgltd/llm-skills/tree/main/skills/apps-script-workflow
Command: npx skills add https://github.com/dasgltd/llm-skills --skill apps-script-workflow

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires clasp, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the challenge of invisible script outputs, silent failures, and lack of UI feedback in Google Apps Script development, making AI Agents more effective in scripting and UI interactions.

Core Features & Use Cases

  • Local Deployment: Utilizes clasp for local development and deployment, avoiding cache issues.
  • Custom Menus: Automatically generates a "Pro Tools" menu for UI interaction.
  • UI Feedback: Implements Toasts for progress indication and Alerts for error handling.
  • Defensive Programming: Ensures robust Google Sheets programming practices.
  • Data Import Discipline: Ensures integrity and consistency when importing data for Looker Studio dashboards.

Quick Start

Deploy a new Google Apps Script project using the clasp push -f command and generate a "Pro Tools" menu for the script.

Frequently Asked Questions about apps-script-workflow

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

FAQPage Schema
How do I show UI feedback in Google Apps Script to avoid silent failures?▼

To avoid silent failures in Google Apps Script, you can implement UI feedback using Toasts for progress indication and Alerts for error handling. This ensures users receive immediate visual confirmation of script execution and issues.

What is the best way to deploy Google Apps Script locally to avoid cache issues?▼

The best way to deploy Google Apps Script locally and avoid cache issues is by using the clasp tool. You can push your local project files directly to Google Apps Script using the 'clasp push -f' command for forced deployment.

Do I need clasp to automate Google Sheets programming with AI Agents?▼

Yes, you need clasp to automate Google Sheets programming with AI Agents. It enables local development and deployment, allowing automated scripting workflows to push code changes directly without browser-based editor limitations.

How do I add a custom menu to Google Sheets for script interaction?▼

To add a custom menu to Google Sheets for script interaction, you generate a 'Pro Tools' menu within your Apps Script project. This provides a dedicated UI element for users to trigger automated scripts and tools directly.

Why does my Google Apps Script data import fail for Looker Studio dashboards?▼

Google Apps Script data imports for Looker Studio dashboards often fail due to inconsistent data integrity. Applying defensive programming practices ensures data consistency and prevents silent formatting errors during the automated import process.

Related Skills

Explore More Software Engineering Skills→
kensaku63kensaku63

appscript

Develop and deploy Google Apps Script projects locally using the clasp CLI.

Community
Intermediate
akillnessakillness
40

looker-studio-bigquery

Connect Looker Studio to BigQuery for analytics dashboards.

Community
Advanced
tody-agenttody-agent
48

cm-google-form

Connect HTML forms to Google Sheets via Apps Script with retry and toast notifications.

Community
Advanced
powerhouse-incpowerhouse-inc

google-sheets

Read, write, and manage Google Sheets data via direct curl API calls.

Official
Intermediate