Google Apps Script

Overview

Cloud-based JavaScript platform for automating Google Workspace services. Server-side V8 runtime with automatic OAuth integration across Sheets, Docs, Gmail, Drive, Calendar, and more.

Core Services

1. SpreadsheetApp - Google Sheets automation (read, write, format, data validation)
2. DocumentApp - Google Docs creation and editing
3. GmailApp & MailApp - Email operations (send, search, manage labels)
4. DriveApp - File and folder management, sharing, permissions
5. CalendarApp - Calendar events, recurring appointments, reminders
6. Triggers & ScriptApp - Time-based and event-driven automation

Quick Start