Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
14 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
The Trainor gives more samples which really helps a lot.
Romulo - Tribal Software Philippines, Inc.
Course - Advanced TypeScript
The training has good content and easy to follow
David Phetole Leshabela - Vodacom SA
Course - React with Next.js
Simplification of new complex techniques
Brian Zaranyika - Vodacom SA
Course - React Native Expo
The breadth of the topis covered was quite a bit and the trainer tried to do justice to that.
Lakshmipriya Sivakumar - Deque Systems Inc
Course - Spring Boot, React, and Redux
The trainer seemed very knowledgable about Vue. I appreciated seeing his development style and learning some new concepts to try.
