• Home
  • Automating IT Processes with Google Apps Script: A Practical Approach

Automating IT Processes with Google Apps Script: A Practical Approach

Course Information

  • Sessions 2 days
  • Duration 15 hrs
  • Level Beginner to Intermediate
  • Assessment NA

Venue

Kuala Lumpur: G-3A-02, Suite Pejabat Korporat, KL Gateway, No 2, Jalan kerinchi, Gerbang kernichi Lestari, 59200 Kuala Lumpur, Malaysia
Penang: Jalan Sungai Dua, 11700 Penang, Malaysia.

Download Course Brochure

Certification

  • Certificate of Completion from Tertiary Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.

Automating IT Processes with Google Apps Script: A Practical Approach

Course Code: C819
  • HRDF

Be the first to review this product

What's This Course About

In our comprehensive course, "Automating IT Processes with Google Apps Script: A Practical Approach," participants will delve into the powerful capabilities of Google Apps Script to automate and optimize various IT processes. This hands-on course is designed to equip learners with the skills to write and deploy custom scripts that integrate seamlessly with Google Workspace applications. You'll learn how to automate tasks across Google Sheets, Docs, and Drive, creating efficient workflows that save time and reduce manual effort.

Our practical approach ensures that you not only understand the fundamentals of scripting but also apply these skills in real-world scenarios. Whether you're managing data, creating complex spreadsheets, or need to automate repetitive tasks, this course will transform the way you work. By the end of this course, you will be proficient in using Google Apps Script to create custom functions, automate email responses, and streamline your IT operations, significantly boosting your productivity and technical expertise.

WSQ Funding

Full Fee 1,800.00 Before GST
GST 162.00 9% of fee
Baseline Nett 1,062.00 SG/PR age 21+ · 50% funded
MCES / SME Nett 702.00 SG age 40+ · 70% funded
Funding and Grant Applications

No funding is available for this course.

For WSQ funding, please checkout the details at WSQ - IT Automation with Google Apps Script

Course Fee

MYR1,800.00

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Disclaimer: The course dates displayed on our website are tentative and subject to trainer availability. We will confirm the final date after checking with the trainer. You are also welcome to email us your preferred date at sales@tertiarycourses.com.my, and we will do our best to coordinate with the trainer's schedule.

Post-Course Support

  • We may provide consultation related to the subject matter after the course.
  • Please email your queries to sales@tertiarycourses.com.my and we will forward your queries to the subject matter experts and get back to you as soon as possible.

Cancellation & Reschedule Policy

  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
  • Note: the venue of the training is subject to changes due to class size and availability of the classroom. The minimum class size to start a class is 3 Pax.

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

Trainers

Trainers

Saeid is co-founder of Skymics Sdn Bhd. He has 8 years of experience in the field of IoT (Internet of Things) and Information Technology. He is a certified IBM IoT Practitioner and instructor, and a Certified Citizen Data Scientist Train-The-Trainer. He has been co-inventor of 3 inventions during the last 4 years.

Review

Write Your Own Review

You're reviewing: Automating IT Processes with Google Apps Script: A Practical Approach