Course Information

  • Sessions 2 days
  • Duration 16 hrs
  • Level Beginner
  • Assessment 2 hrs

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Skills Framework

TSC Title
Applications Integration
TSC Code
ICT-DIT-3003-1.1

Funding Validity

Funding for this course is valid from 16 Feb 2024 to 15 Feb 2027. Register and complete the course within this period to qualify for funding support.

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

Certification

  • Certificate of Achievement from Tertiary Infotech Academy Pte Ltd - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Achievement from Tertiary Infotech Academy Pte Ltd.
  • 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 - IT Automation with Google Apps Script

Course Code: TGS-2024042306
  • WSQ
  • SFC
  • PSEA
  • UTAP
  • SFEC
  • Absentee Payroll
  • MCES
Share

What's This Course About

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.

WSQ Funding

Full Fee $800.00 Before GST
GST $72.00 9% of fee
Baseline Nett $472.00 SG/PR age 21+ · 50% funded
MCES / SME Nett $312.00 SG age 40+ · 70% funded
SkillsFuture Enterprise Credit (SFEC)

Eligible companies can use their $10,000 SFEC to cover up to 90% of out-of-pocket course fees for classes ending on or before 30 Nov 2026. A redesigned SFEC starts on 1 Dec 2026.

View on SkillsFuture for Business

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.

Direct Application on SkillsFuture Portal

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.

Submit UTAP Claim

PSEA

Eligible Singapore Citizens can use their PSEA funds to offset course fee payable after funding.

Check PSEA Eligibility

  • Scroll down to “Keyword Tags” to verify for PSEA eligibility.
  • If there is “PSEA” under keyword tags, the course is eligible for PSEA.

Once you are eligible for PSEA, please download and fill up the PSEA Withdrawal Form, then submit the completed form to us:

PSEA Withdrawal FormSubmit PSEA Form

Course FeeBefore Funding

$800.00 (GST-exclusive)
$872.00 (GST-inclusive)

Course Date

* Required Fields

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.

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.

Cancellation & Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
  • 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

Course Details

What You'll Learn

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

Assessment

  • Written Exam
  • Practical Exam

Course Info

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 will need the following for this course:

Hardware: Windows PC or Mac laptop

Funding Eligibility Criteria

Self-sponsored learners (individuals)

  • Singapore Citizens and Singapore Permanent Residents aged 21 and above.
  • Up to 50% course fee funding. Singapore Citizens aged 40 and above receive up to 70% under the Mid-career Enhanced Subsidy (MCES).
  • Singapore Citizens aged 25 and above can pay the remaining fee with SkillsFuture Credit.

Company-sponsored learners

  • Singapore Citizens and Singapore Permanent Residents who are direct employees of the sponsoring company.
  • Up to 50% course fee funding, or up to 70% for employees of SMEs (Enhanced Training Support for SMEs) and for Singapore Citizens aged 40 and above. An SME has no more than 200 employees or an annual turnover of no more than $100 million.
  • Employers can also claim Absentee Payroll funding for employees who attend during working hours.
  • Eligible companies can offset their out-of-pocket fees with SkillsFuture Enterprise Credit (SFEC).

Conditions for all funded learners

  • Attendance is taken digitally with Singpass for every session, including the assessment.
  • You must complete the course and pass all assessments (assessed as Competent).
  • If these conditions are not met, the funding is clawed back and the learner or employer pays the full course fee.
  • 9% GST is charged on the full course fee before funding.
  • Promo and discount codes cannot be used on funded courses.
  • Any balance after funding can be paid in cash, with SkillsFuture Credit, with PSEA (Singapore Citizens with a PSEA), or partly reimbursed by UTAP for NTUC members.

How to Apply SkillsFuture Credit Claim for Individuals

Singapore Citizens aged 25 and above can use their SkillsFuture Credit (base tier) to pay the course fee after funding. The $4,000 mid-career top-up cannot be used for this course.

  1. Register for this course as self-sponsored and tell us you will use SkillsFuture Credit. Do not pay the amount you plan to claim.
  2. We email you an invoice showing the course fee after funding.
  3. From 60 days before the course starts, and no later than the course start date, log in to MySkillsFuture with Singpass and click Claim credits.
  4. Click Submit a Claim and search for this course by its course code, TGS-2024042306.
  5. Select your class start date, enter the course fee payable after funding and the amount of credit to claim, then upload the invoice (PDF, JPG or PNG, under 4MB).
  6. Review, accept the terms and click Agree and Submit. The credit is paid directly to us; processing can take up to 14 working days.

Changing or withdrawing: cancel the claim on MySkillsFuture at least one day before the course starts. If your class date changes, cancel the claim and submit a new one with the new date.

How to Apply SkillsFuture Enterprise Credit (SFEC)

SFEC helps companies pay for employee training. The current SFEC ends on 30 November 2026, and a redesigned SFEC starts on 1 December 2026.

Current SFEC: classes ending on or before 30 November 2026

  • Eligible companies received a one-off $10,000 credit, notified by letter to their Corppass administrator. Eligibility generally required at least 3 Singapore Citizen or PR employees and Skills Development Levy contributions.
  • SFEC covers up to 90% of the company's out-of-pocket course fee after other subsidies.
  1. Check your company's SFEC eligibility and balance on EnterpriseSG.
  2. Register your Singapore Citizen or PR employee for a class that ends by 30 November 2026, as company-sponsored, and pay the course fee after funding.
  3. Your employee attends and completes the course. We submit the attendance and assessment results to SWDA.
  4. No separate claim is needed. SFEC is calculated automatically once the course fee grant is approved and is paid quarterly to your company's IRAS GIRO or PayNow Corporate account.

Any unused balance of the current SFEC expires on 30 November 2026.

Redesigned SFEC from 1 December 2026

Companies with at least 3 resident employees receive a fresh $10,000 in an online SFEC wallet that offsets out-of-pocket fees upfront at enrolment, instead of reimbursing them afterwards. SWDA has not yet published the support rates and claim steps; see OurWorkforce or our SFEC guide.

How to Apply UTAP (NTUC Members)

NTUC members can claim 50% of the unfunded course fee under the Union Training Assistance Programme (UTAP), capped at $250 a year (aged below 40) or $500 a year (aged 40 and above). The cap is shared with UTAP claims for AI tool subscriptions.

Eligibility: you must be an NTUC member paying full membership fees, with your membership paid up before and during the course and when you claim. The course must not be fully paid for by your employer or another source.

  1. Make sure your NTUC membership is paid up before the course starts.
  2. Register for this course with us and pay the course fee after funding and SkillsFuture Credit.
  3. Attend at least 75% of the course and sit all assessments.
  4. Within 6 months after the course ends, go to the NTUC U Portal, open UTAP under E-services, log in with Singpass and choose Course Fee Claim.
  5. Enter the nett course fee you paid (after all subsidies and SkillsFuture Credit, including GST), and upload your invoice or receipt and your certificate or result slip (PDF, JPG or PNG, up to 5MB each).
  6. NTUC usually pays the claim within 4 weeks of submission.

Read more in our UTAP guide.

How to Apply PSEA

Singapore Citizens with a Post-Secondary Education Account (PSEA), which stays open until around the year you turn 31, can use it to pay the course fee after funding for PSEA-approved courses. You can also use a sibling's PSEA after your own has been used up.

  1. Check that this course shows the PSEA tag on its MySkillsFuture page.
  2. Check your PSEA balance on MOE's Student Finance System with Singpass.
  3. Download and complete the PSEA withdrawal form, then submit it to us.
  4. We submit the withdrawal request to MOE. You (and your sibling, if you are using their account) authorise it in the Student Finance System. Nothing is withdrawn without this authorisation.
  5. MOE pays us directly. If you have already paid, we refund the amount covered by PSEA.

More details: MOE PSEA overview.

Appeal Process

If you disagree with an assessment decision, you have the right to appeal.

  1. When the assessor gives you feedback, say whether you agree with the outcome. If you agree, you and the assessor sign the Assessment Summary Record; if you disagree, do not sign it.
  2. Discuss the decision with the assessor or the assessment manager first.
  3. If you are still not satisfied, tell the assessor you intend to appeal. The assessor records this in the feedback section of the Assessment Summary Record and informs the assessment manager.
  4. Lodge your appeal within 7 days, giving your reasons, using the Candidate Appeal Form. The assessor can help you write and lodge it.
  5. An Assessment Appeal Panel reviews the information from you and the assessor and makes a decision. A record of the appeal and its outcome is kept.
  6. You will be told the outcome within 2 weeks of lodging the appeal. The panel's decision is final.

Job Roles

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

Trainers

Tan Woei Ming is an accomplished data scientist and AI engineer with over 15 years of experience in artificial intelligence, machine learning, and data-driven innovation. Holding a Master’s in Intelligent Systems from the National University of Singapore (NUS) and a First-Class Honours in Electrical and Electronic Engineering from NTU, he has led AI initiatives in predictive analytics, automation, and process optimization across the semiconductor and manufacturing industries. His expertise lies in translating complex AI technologies into practical business applications, enabling organizations to innovate through data insights and intelligent automation.
Yeo Hwee Theng is a data science leader and AI strategist with extensive experience in driving enterprise analytics, AI adoption, and data architecture initiatives across healthcare, finance, and government sectors. As the Data & Analytics Product Lead at Amplify Health, she leads large-scale data transformation and machine learning projects focused on improving business outcomes through data-driven decision-making. Her previous roles include AI & Data Architect at Huawei International and Senior Data Scientist at DataRobot, where she implemented advanced AI and analytics solutions across the Asia-Pacific region. She holds a Master of Technology in Enterprise Business Analytics from the National University of Singapore and an Advanced Certificate in Learning and Performance (ACLP).
Teh Siew Yee is an experienced adult educator and corporate trainer specializing in business communication, workplace effectiveness, and professional development. With years of experience across both corporate and training environments, she has helped learners enhance their skills in problem-solving, collaboration, and interpersonal communication. Her ability to translate complex concepts into clear, practical strategies ensures that participants can immediately apply their learning in the workplace. As an ACLP-certified trainer, Siew Yee delivers WSQ courses with a strong focus on learner engagement and workplace application. She integrates case studies, role-plays, and reflective exercises into her sessions, ensuring participants develop not only knowledge but also confidence in real-world contexts. By combining her corporate experience with adult education expertise, she empowers learners to improve workplace efficiency, strengthen teamwork, and achieve personal and organizational success.

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 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.

Review

Customer Reviews (7)

will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 3/20/2025)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
.Mr Gary Chan is very professional and an experience trainer (Posted on 12/16/2024)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
many thanks for a making this course available to me despite the short notice. I can definitely bring back what I learnt here back to my workplace to enhance my workflow. (Posted on 11/5/2024)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 10/16/2024)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 9/9/2024)

Items 1 to 5 of 7 total

per page
Page:
  1. 1
  2. 2

Write Your Own Review

You're reviewing: WSQ - IT Automation with Google Apps Script

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment