Home
WSQ - IT Automation with Google Apps Script

WSQ - IT Automation with Google Apps Script

Step into the evolving world of IT automation with our "IT Automation with Google Apps Script" course. This comprehensive program is designed to equip you with the skills to identify and leverage the full potential of Google Apps Script in connecting various applications. Throughout the course, you will learn how to utilize Google Apps Script effectively to integrate data and functionalities across multiple platforms. The hands-on training will enable you to understand the intricacies of automating tasks and processes, enhancing efficiency, and reducing manual intervention in everyday business operations.

Building on these foundations, the course takes a deeper dive into the practical aspects of IT automation. You will develop the ability to verify the functioning of different modules connected through Google Apps Script and gain expertise in troubleshooting and resolving integration issues. The curriculum is structured to provide a holistic understanding of how to implement modifications to Google Apps Script for optimized application integration. By the end of the course, you will have a solid grasp of automating and streamlining workflows using Google Apps Script, making you an invaluable asset in any technologically driven work environment.

Learning Outcomes

By end of the course, learners should be able to:

LO1: Identify and assess opportunities of using Google Apps Script to connect various applications.
LO2: Utilise Google Apps Script to integrate data and function across multiple applications.
LO3: Verify the functioning of various modules connected by Google Apps Script.
LO4: Identify issues on application integration and implement modification to Google Apps Script.

Course Brochure

Download WSQ - IT Automation with Google Apps Script Brochure

Skills Framework

This course follows the guideline of Applications Integration ICT-DIT-3003-1.1 under ICT Skills Framework

Certification

Certificate of Completion from Tertiary Infotech - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Infotech.
OpenCerts from SkillsFuture Singapore - After passing the assessment(s) and achieving at least 75% attendance, participants will receive a OpenCert (aka Statement of Achievement) from SkillsFuture Singapore, certifying that they have achieved the Competency Standard(s) in the above Skills Framework.

WSQ Funding

WSQ funding is only applicable to Singaporeans and PR. Subject to eligibility, the funding support is subjected to funding caps.

Effective for courses starting from 1 Jan 2024
Full Fee	GST	Nett Fee after Funding (Incl. GST)
		Baseline	MCES / SME
$800	$72.00	$472.00	$312.00

Baseline: Singaporean/PR age 21 and above
MCES(Mid-Career Enhanced Subsidy): S'porean age 40 & above

Upon registration, we will advise further on how to tap on the WSQ Training Subsidy.

You can pay the nett fee (after the WSQ training subsidy) by the following :

SkillsFuture Enterprise Credit (SFEC)

Eligible Singapore-registered companies can tap on $10000 SFEC to cover out-of-pocket expenses.Click here to submit SkillsFuture Enterprise Credit

SkillsFuture Credit (SFC)

Eligible Singapore Citizens can use their SFC to offset course fee payable after funding but the $4,000 Additional SFC (Mid-Career Support) cannot be used. Click here for SkillsFuture Credit submission

UTAP

Eligible NTUC members can apply for 50% of the unfunded fee from UTAP, capped up to $250/year and for members aged 40 and above, capped up to $500/year. Click here to submit UTAP

Once you are eligible for PSEA, please download and fill up the PSEA Withdrawal Form and email to us.

Course Code: TGS-2024042306

Post-Course Support

We provide free consultation related to the subject matter after the course.
Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Course Cancellation/Reschedule Policy

You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commerce.
We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
Note the venue of the training is subject to changes due to availability of the classroom

Course Details

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

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

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

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

Final Assessment

Written Assessment - Short Answer Questions (WA-SAQ)
Practical Performance (PP)

Course Info

Promotion Code

Promo or discount cannot be applied to WSQ courses

Minimum Entry Requirement

Knowledge and Skills

Able to operate using computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Have some basic Javascript, HTML5 and CSS3 programming knowledge

Attitude

Positive Learning Attitude
Enthusiastic Learner

Experience

Minimum of 1 year of working experience.

Target Age Group: 21 to 65 years old

Minimum Software/Hardware Requirement

Software:

You can download and install the following software:

Hardware: Windows and Mac Laptops

About Progressive Wage Model (PWM)

The Progressive Wage Model (PWM) helps to increase wages of workers through upgrading skills and improving productivity.

Employers must ensure that their Singapore citizen and PR workers meet the PWM training requirements of attaining at least 1 Workforce Skills Qualification (WSQ) Statement of Attainment, out of the list of approved WSQ training modules.

For more information on PWM, please visit MOM site.

Funding Eligility Criteria

Individual Sponsored Trainee

Employer Sponsored Trainee

Singapore Citizens or Singapore Permanent Residents of age 21 and above
From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.
Trainee must pass all prescribed tests / assessments and attain 100% competency.
We reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria.

Singapore Citizens or Singapore Permanent Residents who are DIRECT EMPLOYEE of the sponsoring company.
From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.
Trainee must pass all prescribed tests / assessments and attain 100% competency.
We reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria.

SkillsFuture Credit:

Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.

PSEA:

To check for Post-Secondary Education Account (PSEA) eligibility, goto mySkillsFuture portal and search for this course code.
Scroll down to "Keyword Tags" to verify for PSEA eligibility.
If there is “PSEA” under keyword tags, the course is eligible for PSEA.
And if there is no “PSEA” under keyword tags, the course is ineligible for PSEA.
Not all courses are eligible for PSEA funding.

Absentee Payroll (AP) Funding:

$4.50 per hour, capped at $100,000 per enterprise per calendar year.
AP funding will be computed based on the actual number of training hours attended by the trainee.

SFEC:

If the Training Provider has submitted an enrolment for course fee grant claim in Training Partners Gateway (TPGateway), SSG would be able to derive SFEC funding based on this record. There is no need for enterprise to submit any claim request and the SFEC claim will be automatically generated and disbursed.
Where there is no such record, eligible employers are required to submit an SFEC claim after course completion via the SFEC microsite.
SkillsFuture Enterprise Credit (SFEC) Microsite

Steps to Apply Skills Future Claim

The staff will send you an invoice with the fee breakdown.
Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
Upload your invoice and click ‘Submit’

SkillsFuture Level-Up Program

The SkillsFuture Level-Up Programme provides greater structural support for mid-career Singaporeans aged 40 years and above to pursue a substantive skills reboot and stay relevant in a changing economy. For more information, visit SkillsFuture Level-Up Programme

Get Additional Course Fee Support Up to $500 under UTAP

The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).

For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)

Steps to Apply UTAP

Note

SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
UTAP support amount will be paid to training provider first and claimed after end of class by learner.

Appeal Process

The candidate has the right to disagree with the assessment decision made by the assessor.
When giving feedback to the candidate, the assessor must check with the candidate if he agrees with the assessment outcome.
If the candidate agrees with the assessment outcome, the assessor & the candidate must sign the Assessment Summary Record.
If the candidate disagrees with the assessment outcome, he/she should not sign in the Assessment Summary Record.
If the candidate intends to appeal the decision, he/she should first discuss the matter with the assessor/assessment manager.
If the candidate is still not satisfied with the decision, the candidate must notify the assessor of the decision to appeal. The assessor will reflect the candidate’s intention in the Feedback Section of the Assessment Summary Record.
The assessor will notify the assessor manager about the candidate’s intention to lodge an appeal.
The candidate must lodge the appeal within 7 days, giving reasons for appeal
The assessor can help the candidate with writing and lodging the appeal.
he assessment manager will collect information from the candidate & assessor and give a final decision.
A record of the appeal and any subsequent actions and findings will be made.
An Assessment Appeal Panel will be formed to review and give a decision.
The outcome of the appeal will be made known to the candidate within 2 weeks from the date the appeal was lodged.
The decision of the Assessment Appeal Panel is final and no further appeal will be entertained.
Please click the link below to fill up the Candidates Appeal Form.

Job Roles

Google Apps Script Developer
Automation Engineer
Workflow Specialist
IT Project Manager
Technical Support Engineer
Data Analyst
Application Developer
Systems Analyst
Business Intelligence Analyst
Web Developer
Software Engineer
Cloud Solutions Architect
IT Consultant
Operations Analyst
Business Systems Analyst
Integration Specialist
Quality Assurance Tester
User Experience Designer
Database Administrator
Digital Transformation Specialist

Trainers

Tan Woei Ming: Tan Woei Ming is a data scientist and automation engineer with over 15 years of experience in artificial intelligence, data analytics, and process optimization. He holds a Master’s in Intelligent Systems from the National University of Singapore and a First-Class Honours in Electrical and Electronic Engineering from Nanyang Technological University. His career includes leading automation and analytics projects that integrate Python, APIs, and Google Workspace tools to streamline business processes and decision-making.

In “IT Automation with Google Apps Script,” Woei Ming teaches participants how to leverage Google Apps Script to automate repetitive tasks, enhance collaboration, and build intelligent workflows. His sessions emphasize practical coding, API integration, and data handling within Google Sheets, Drive, and Gmail. By bridging programming concepts with real-world automation use cases, he empowers learners to create efficient, scalable, and data-driven solutions across organizational workflows.

Yeo Hwee Theng: Yeo Hwee Theng is a data and AI strategist with extensive experience leading digital transformation and automation projects across healthcare, finance, and government sectors. As the Data & Analytics Product Lead at Amplify Health, she has designed and deployed AI-powered process automation frameworks using cloud-based platforms and APIs. Previously, she served as AI & Data Architect at Huawei International and Senior Data Scientist at DataRobot. She holds a Master of Technology in Enterprise Business Analytics from the National University of Singapore and is ACLP-certified.

In “IT Automation with Google Apps Script,” Hwee Theng guides learners through building intelligent, automated business workflows within Google Workspace. Her sessions focus on integrating Apps Script with APIs, cloud services, and data visualization tools. By combining technical depth with strategic understanding, she equips professionals to design scalable automation systems that enhance productivity and decision-making efficiency.

Teh Siew Yee: Teh Siew Yee is a digital transformation and analytics leader with more than 20 years of experience in technology management, automation, and data strategy. He has held leadership roles in major organizations such as Hewlett-Packard, Standard Chartered, TikTok, and SIA Engineering, where he oversaw enterprise automation and process improvement initiatives. Siew Yee holds a Master of IT in Business (Artificial Intelligence) from Singapore Management University and is an ACLP-certified trainer known for bridging technical tools with business value.

In “IT Automation with Google Apps Script,” Siew Yee focuses on developing automation solutions that improve efficiency and collaboration across teams. His sessions cover workflow automation, Google Workspace integration, and data reporting. With a strong emphasis on practical implementation, he helps learners master Apps Script for automating everyday business operations and optimizing organizational performance.

Truman Ng: Truman Ng is a senior IT consultant and automation systems architect with more than 20 years of experience in network infrastructure, cloud computing, and workflow optimization. A PMP, ACTA, and Huawei HCIE-certified professional, he has led global training programs and digital transformation projects focused on DevOps, cloud platforms, and enterprise automation. His expertise lies in building secure, scalable systems that integrate seamlessly with Google Workspace and other cloud ecosystems.

In “IT Automation with Google Apps Script,” Truman teaches participants how to implement automation workflows that connect Google Workspace tools with enterprise applications. His sessions highlight advanced scripting, API orchestration, and best practices for managing large-scale automation systems. Through a hands-on and systems-driven approach, he enables learners to develop efficient, maintainable automation solutions that streamline organizational workflows.

James Lee Kin Nam: James Lee is a creative technology educator and IT automation specialist with more than 20 years of experience in multimedia, digital transformation, and workflow automation. An Adobe Certified Expert and ACLP-qualified trainer, he has taught professionals in digital communication, process automation, and creative productivity. His teaching style focuses on making technical concepts accessible through visual and experiential learning.

In “IT Automation with Google Apps Script,” James introduces participants to automating digital tasks and integrating productivity tools using Apps Script. His sessions focus on building practical automations in Google Sheets, Drive, and Gmail, along with script-based reporting and scheduling. By blending creativity with technical proficiency, he helps learners design smart, automated workflows that improve efficiency and enhance collaboration across teams.