Apps script course

Lesson 1 • Your First Script

Guides learners through writing, saving, and running a minimal script. Demonstrates the full edit-run-log cycle from scratch.

Lesson 2 • The Script Editor Interface

Explores the built-in IDE: file management, toolbar, and logging panel. Familiarity here accelerates every hands-on exercise in the course.

Lesson 3 • Authorisation and Permissions

Explains OAuth consent screens, scopes, and how Apps Script requests access to services. Prevents common permission errors in later projects.

Lesson 1 • Control Flow and Loops

Teaches if/else, switch, for, while, and for...of constructs. These patterns drive conditional logic and iteration in every automation script.

Lesson 2 • Arrays and Objects

Explains array methods and object literals essential for handling spreadsheet data and API responses. Directly applied in Sheets and Drive chapters.

Lesson 3 • Error Handling in JavaScript

Introduces try/catch/finally and custom error messages. Robust error handling is required for reliable production scripts.

Lesson 4 • Variables, Types, and Operators

Introduces var, let, const, primitive types, and arithmetic/comparison operators. Provides the syntax base for all script logic ahead.

Lesson 1 • Sorting, Filtering, and Data Validation

Automates sort operations, filter views, and data validation rules on ranges. Prepares students for building data-quality workflows.

Lesson 2 • Formatting Cells Programmatically

Applies fonts, colours, borders, and number formats via script. Enables automated report styling without manual intervention.

Lesson 3 • Working with Formulas and Named Ranges

Inserts and reads formulas, and manages named ranges for maintainable scripts. Named ranges reduce hard-coded cell references in production code.

Lesson 4 • Reading and Writing Cell Data

Covers getValue, getValues, setValue, and setValues for single cells and ranges. Efficient data I/O is the core skill for Sheets automation.

Lesson 1 • Drive Service Fundamentals

Introduces DriveApp for navigating folders, listing files, and reading file metadata. Establishes the Drive object model for file management scripts.

Lesson 2 • Sending and Replying to Emails

Covers sendEmail, replyTo, and HTML body composition. Enables automated notifications and report delivery from scripts.

Lesson 3 • Gmail Service Fundamentals

Introduces GmailApp methods for reading threads, messages, and labels. Provides the foundation for all email automation tasks in this chapter.

Lesson 4 • Managing Labels and Drafts

Teaches creating labels, applying them to threads, and saving drafts programmatically. Supports inbox organisation automation workflows.

Lesson 1 • Event Objects and Context

Examines the event object passed to trigger functions for source, range, and user data. Enables context-aware scripts that respond to specific changes.

Lesson 2 • Time-Driven Triggers

Configures minute, hourly, daily, and weekly time-driven triggers for scheduled tasks. Enables recurring report generation and data sync jobs.

Lesson 3 • Trigger Management Best Practices

Addresses duplicate trigger prevention, quota limits, and error notification settings. Ensures production triggers remain stable and observable.

Lesson 4 • Installable Triggers

Covers creating installable triggers via the UI and ScriptApp API for expanded permissions. Required for Gmail, Drive, and Calendar event-based automation.

Lesson 1 • Client-Server Communication

Uses google.script.run to call server-side functions from HTML and handle callbacks. Bridges the UI and script logic for dynamic interfaces.

Lesson 2 • Templated HTML and Dynamic Content

Applies HtmlTemplate with scriptlets to inject server data into HTML at render time. Enables data-driven UIs without client-side API calls.

Lesson 3 • Custom Menus in Google Workspace

Creates custom menus in Sheets, Docs, and Forms using onOpen and addMenu. Gives users one-click access to script functions without opening the editor.

Lesson 4 • HTML Service Fundamentals

Introduces HtmlService for rendering HTML pages inside Google Workspace. Provides the rendering engine for all dialog and sidebar UIs.

Lesson 1 • Rate Limiting and Error Resilience

Implements retry logic, exponential backoff, and quota-aware request patterns. Prevents script failures caused by API rate limits and transient errors.

Lesson 2 • UrlFetchApp Fundamentals

Introduces UrlFetchApp.fetch() for GET and POST requests and inspecting responses. This service is the gateway to all external API integrations.

Lesson 3 • Parsing and Using JSON Responses

Parses JSON response strings into objects and extracts nested data for use in scripts. Connects API data to Sheets, Gmail, and Drive workflows.

Lesson 4 • Authentication Patterns

Implements API key, Bearer token, and Basic Auth header patterns for secured endpoints. Covers safe credential storage using PropertiesService.

Lesson 1 • CacheService for Performance

Applies CacheService to store frequently accessed data and reduce redundant API calls. Improves response time for UI-facing scripts significantly.

Lesson 2 • PropertiesService for Persistent State

Uses script, user, and document properties to store configuration and state across executions. Eliminates hard-coded values and enables multi-user scripts.

Lesson 3 • Execution Limits and Long-Running Tasks

Addresses the six-minute execution limit using continuation patterns and trigger chaining. Enables processing of large data sets that exceed single-run limits.

Lesson 4 • Batch Operations and Quota Management

Replaces single-cell reads/writes with batch getValues/setValues to minimise API calls. Directly reduces execution time and quota consumption.

Lesson 5 • Modular Code and Libraries

Organises scripts into multiple files and shared libraries for reuse across projects. Promotes maintainability and team collaboration on large codebases.