Course Details
Course Details
What You'll Learn
LU1: Foundations of Google Apps Script and Basic Automation
Topic 1: Getting Started with Google Apps Script
Overview of Google Apps Script and its capabilities
Navigating and utilizing the Google Apps Script Editor
Creating and running basic scripts
Understanding Mail Service and basic automation scripts
Topic 2: Automating Google Sheets with Script
Introduction to Spreadsheet Service
Utilizing Sheet and Range Methods for automation
Manipulating cell values and applying formulas programmatically
LU2: Google Apps Script Functions and Integration
Topic 3: Scripting for Google Docs and Google Slides
Utilizing Document and Slide Services for automation
Scripting methods for text manipulation and slide modification
Integrating Google Docs and Slides with other Google services
Topic 4: Google Calendar and Google Drive Scripting
Automating tasks with Calendar Service, including event creation
Leveraging Drive Service for file and folder management
Implementing API-level integrations with Google Drive and Google Calendar
LU3: Trigger Management and Data Handling
Topic 5: Working with Triggers and Data Management
Setting up Time-Driven Triggers and auto-email alerts
Managing data across Google Apps Script services
Automating file duplication and folder sharing
Topic 6: HTML Services and Web App Development
Utilizing HTML Services for web app creation
Communicating with server functions and deploying web apps
Integrating Google Sheets data into HTML web apps
LU4: Customization and Optimization in Google Apps Script
Topic 7: Custom Menu, Dialogs, and Sidebars
Developing Bound Scripts and Custom Menus in Google Workspace
Utilizing Dialogs and Sidebars for user interaction
Implementing OnOpen Triggers for automation
Topic 8: Creating and Utilizing Custom Functions
Designing custom functions for specific tasks
Troubleshooting and optimizing custom scripts for performance
Addressing compatibility and technical issues in script integration
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 18-65 years old
Minimum Software/Hardware Requirement
Software:
TBD
Hardware: Window or Mac Laptops
Job Roles
Job Roles
- Google Apps Script Developer
- IT Automation Specialist
- Technical Project Manager
- Systems Analyst
- Business Process Engineer
- Cloud Solutions Architect
- Data Analyst
- IT Support Specialist
- Workflow Automation Engineer
- Application Developer
- Integration Specialist
- Database Administrator
- Information Systems Manager
- Enterprise Software Developer
- IT Consultant
- Quality Assurance Tester
- Technical Trainer
- DevOps Engineer
- User Experience Designer
- Software Engineer