Basic IT Automation with Google Apps Script Training

Course Information

  • Sessions 1 day
  • Duration 7.5 hrs
  • Level Beginner
  • Assessment NA

Venue

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.

Basic IT Automation with Google Apps Script Training

Course Code: C187

7 Review(s) | Add Your Review

What's This Course About

Unlock the boundless possibilities of automation within the Google Workspace through our specialized Automation with Google Apps Script Training. Kickstart your journey with a deep understanding of what Google Apps Script entails and explore its seamless integration across the suite, be it Sheets, Slides, Doc, Calendar, or Drive.

Dive deeper into the nuances of crafting custom triggers, and empower your operations with the creation of automated email alerts, ensuring you stay abreast of every essential update. By the end of this comprehensive training, you'll be proficient in automating tasks, enhancing workflow efficiency, and maximizing the potential of the Google Workspace environment.

WSQ Funding

Full Fee ₵1,500.00 Before GST
GST ₵135.00 9% of fee
Baseline Nett ₵885.00 SG/PR age 21+ · 50% funded
MCES / SME Nett ₵585.00 SG age 40+ · 70% funded

Course Fee

₵1,500.00

Course Date

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 info@tertiarycourses.com.gh 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

Topic 1. Getting Started

What is Google Apps Script

Google Apps Script Editor

Write Your First Google Apps Script

Mail Service

Run You Script

Topic 2. Google Sheet Script

Spreadsheet Service

Sheet Methods

Range Methods

Get and Change Cell Values

Apply Formula

Topic 3. Google Doc Script

Document Service

Document Methods

Body Methods

Text Methods

Modify and Append Text

Topic 4. Google Slide Script

Slide Service

Presentation Methods

Slide Methods

Modify Slide Font

Topic 5. Google Calendar Script

Calendar Service

Event Methods

Recurrence Methods

Create Calendar Events

Create Recurrence Events

Module 6. Google Drive Script

Drive Service

Create Folder and File

Topic 6. Google Drive Script

Drive Service

Create Folder and File

Topic 7. Triggers

What is Trigger

Time Driven Trigger

Setup an Auto Email Alert

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: 21-65 years old

Minimum Software/Hardware Requirement

Software: NIL

Sign up for free Google account

Hardware: Windows 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

is an accomplished IT and data specialist with over 20 years of experience in academia, ICT leadership, and professional training, with a strong focus on data analytics and Excel-based solutions. He has developed and delivered specialized training programs on Statistical Data Analysis with Excel and Visual Basic for Applications (VBA) for Excel, equipping learners with advanced data manipulation, automation, and reporting skills. His expertise extends to automating institutional reporting systems, where he successfully streamlined academic records management through Excel-based tools, integrating macros and automation to improve efficiency and accuracy. As a trainer and consultant, Dr. Siraj has taught Excel to diverse audiences, including university staff, administrative teams, and professionals in banking, security, and education, ensuring they can apply Excel for decision-making, statistical modeling, and process automation. His practical mastery of Excel is complemented by his deep knowledge of office automation and ICT project management, making him a highly sought-after trainer in data analysis and productivity tools. With his blend of hands-on technical expertise and instructional experience, Dr. Siraj stands out as a credible authority in leveraging Excel to drive organizational efficiency and data-driven strategies

Review

Customer Reviews (7)

Excellent course 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
Very informative and interactive. The small class size meant we got a lot of personal attention. (Posted on 5/21/2026)
Engaging trainer 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
Solid content and a supportive trainer. I would definitely sign up for more courses here. (Posted on 5/17/2026)
Engaging trainer 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
Solid content and a supportive trainer. I would definitely sign up for more courses here. (Posted on 12/27/2025)
Well structured course 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
I found the course extremely useful and relevant to my job. Highly recommend it to others. (Posted on 11/27/2025)
Clear and easy to follow 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
Very engaging session. The trainer patiently answered all our questions and gave useful tips. (Posted on 11/8/2025)

Items 1 to 5 of 7 total

per page
Page:
  1. 1
  2. 2

Write Your Own Review

You're reviewing: Basic IT Automation with Google Apps Script Training

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