DiscoveryVIPDISCOVERY ACADEMIES / GOOGLE WORKSPACEHelp

Ready to explore.

Loading the learning path…

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

Replace current work?