Ready to explore.
Explore the complete printable learning path
Start with a small spreadsheet update, then learn JavaScript, Workspace services, triggers, web apps, APIs, AI validation and professional testing. Each lesson includes runnable examples, explanations and exercises.
1. Getting started
- What Apps Script is and what you can build
- Understanding Google Workspace automation
- Exploring the Apps Script editor
- Writing and running your first script
- Execution logs and authorization
2. JavaScript fundamentals
- Variables, let and const
- Strings, numbers and Boolean values
- Operators and mathematical expressions
- Functions, parameters and return values
- Decisions using conditions
3. Arrays, objects and loops
- Arrays and indexes
- Loops that process multiple values
- Objects and properties
- Nested arrays and structured records
- Transforming with map, filter and reduce
4. Google Sheets fundamentals
- Spreadsheets, sheets, rows and columns
- Accessing a spreadsheet and its sheets
- Selecting cells and ranges
- Reading spreadsheet values
- Writing and updating spreadsheet values
5. Processing spreadsheet data
- Reading multiple rows with getValues
- Understanding two-dimensional arrays
- Writing multiple rows with setValues
- Searching, filtering and transforming records
- Appending, inserting and removing safely
6. Advanced spreadsheet operations
- Formatting ranges
- Working with formulas
- Data validation and dropdowns
- Custom spreadsheet functions
- Automated spreadsheet reports
7. Google Docs automation
- Google Docs document structure
- Creating and opening documents
- Paragraphs, headings, lists and tables
- Replacing template placeholders
- Personalized documents from spreadsheet rows
8. Google Drive automation
- Drive files, folders and IDs
- Finding files and folders
- Creating, copying, renaming and moving files
- Metadata and permissions
- File management workflows
9. Gmail and email automation
- GmailApp and MailApp
- Messages and threads
- Gmail search queries
- Personalized drafts and HTML messages
- Human-reviewed communication workflows
10. Google Forms automation
- Forms, questions and responses
- Creating forms
- Questions and supported settings
- Processing form responses
- Form-to-spreadsheet automation
11. Google Calendar automation
- Calendars and events
- Reading and searching events
- Creating and modifying events safely
- Dates, times and time zones
- Scheduling and reminder workflows
12. Google Slides automation
- Presentations, slides and page elements
- Creating presentations and slides
- Text, shapes and page coordinates
- Slides from spreadsheet records
- Automated educational presentations
13. Triggers and events
- Triggers and automatic execution
- onOpen and onEdit
- Installable triggers
- Form submission and time-driven triggers
- Event objects, permissions and execution identity
14. Menus, dialogs and sidebars
- Custom spreadsheet menus
- Alerts and prompts
- HTML Service dialogs
- Interactive sidebars
- Connecting HTML to server functions
15. Web applications
- Web application architecture
- Web applications with doGet
- HTML, CSS and client JavaScript
- Asynchronous google.script.run callbacks
- Deploying and configuring access
16. APIs and external services
- APIs and HTTP requests
- JSON data
- Retrieving data with UrlFetchApp
- Sending data with HTTP requests
- API errors, authentication and validation
17. Gemini and AI automation
- Gemini and AI-powered applications
- Connecting Gemini securely from Apps Script
- Prompts and structured AI responses
- AI processing of sheet and document information
- Reliable AI automation
18. Debugging and reliability
- Syntax, runtime and logic errors
- Logs and failure investigation
- Handling errors with try and catch
- Testing functions and spreadsheet data
- Quotas, batching, locks and duplicate processing
19. Professional development
- Reusable maintainable projects
- Properties, cache and configuration
- Authorization scopes and security
- Editor add-ons and Workspace add-ons
- AI-assisted coding with verification
20. Complete application development
- Identifying an automation opportunity
- Designing an application architecture
- Building a multi-service solution
- Testing, securing and documenting deployment
- Presenting an independent Apps Script capstone