Course Outline
Introduction to Google Apps Script
- What is Google Apps Script?
- Key features and capabilities
- Understanding the V8 runtime and modern JavaScript support
Setting up the Development Environment
- Creating and managing Apps Script projects
- Working in the online editor vs. clasp (command-line Apps Script)
- Version control with GitHub and clasp
Working with Google Sheets
- Reading, writing, and formatting data
- Building custom menus, dialogs, and sidebars
- Data validation, formulas, and integrations
Automating Google Workspace Applications
- Automating Gmail: emails, threads, filters
- Google Drive automation: file creation, movement, permissions
- Calendar automation: scheduling, reminders, and events
- Integrating with Docs and Slides for reporting and presentations
Triggers and Event-Driven Execution
- Time-driven triggers (scheduled tasks)
- Event-driven triggers (on edit, on form submit, on open)
- Managing and debugging triggers
Building Add-ons and Advanced Integrations
- Developing Google Workspace add-ons
- Publishing add-ons to the Marketplace
- Connecting Apps Script with REST APIs and third-party services
Best Practices for Apps Script Projects
- Error handling and debugging techniques
- Security and permissions management
- Scalability and optimization strategies
Case Studies and Applied Projects
- Automating reporting workflows in Sheets and Docs
- Building custom CRM or task management tools with Apps Script
- Real-world enterprise use cases of Apps Script
Summary and Next Steps
Requirements
- Experience with JavaScript programming
- Basic familiarity with Google Workspace applications (e.g., Docs, Sheets, Gmail)
Audience
- Web developers
- IT professionals managing Google Workspace
- Teams seeking automation for workflows
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (4)
The details amout, way of explaning and the calm and confidence the trainer is inspiring.
Cosmin Ghergheles - Ness
Course - React, Redux and TypeScript
The Trainor gives more samples which really helps a lot.
Romulo - Tribal Software Philippines, Inc.
Course - Advanced TypeScript
I like the professionality of the trainer, he really knows what he is talking about and able to explain almost even the simple subjects on the topic which is great.
Marlon - National Confederation of Cooperatives
Course - React with Next.js
practice exercises
