GAS Executor - API Key Management and Script Execution System

English | 日本語

A webhook API system for securely executing JavaScript code in Google Apps Script environment.

Development Setup

Prerequisites

• Node.js and npm installed
• Google account with access to the Apps Script project
• clasp CLI tool (already installed globally)

Initial Setup

# Install dependencies
npm install

# Project has already been cloned with:
# clasp clone 11rmlSwoAwNaimK7mEWOhAMrWA1ctivqQVDWFEhTe0bbsRBFyRDe7mJXW

Development Workflow

Pull Latest Changes

npm run pull
# or
clasp pull

Push Changes to Google Apps Script

npm run push
# or
clasp push

Watch for Changes and Auto-push

npm run watch
# or
clasp push --watch

Open in Google Apps Script Editor

npm run open
# or
clasp open

View Logs

npm run logs
# or
clasp logs

Deploy New Version

npm run deploy
# or
clasp deploy --description "Your deployment description"

View Version History

npm run versions
# or
clasp versions

Project Structure

• appsscript.json - Google Apps Script manifest file
• コード.js - Main script file (Code.js)
• .claspignore - Files to ignore when pushing to GAS
• .clasp.json - Clasp configuration (auto-generated)

Features

• API Key Management System
• Script Execution via Webhook
• Logging to Google Sheets
• Google Services Integration (Drive, Docs, YouTube)

Important Notes

• Always pull before making changes to avoid conflicts
• Test locally when possible before pushing
• Use meaningful deployment descriptions
• Keep API keys secure and never commit them to version control

Planned Features

• Rate Limiting: Implement request throttling per API key
• Webhook Validation: Add request signature verification
• Dashboard: Create a web interface for API key management
• Metrics: Add execution analytics and performance monitoring