Twenty-Four Consulting HRD Corp Claimable Logo
Twenty-Four Consulting HRD Corp Claimable Logo

Intermediate  2 Days

Google Apps Script & ChatGPT: Basics to Advanced Automation

Level up your automation skills by combining Google Apps Script with ChatGPT — build complex workflows, solve real business problems, and work smarter.

  • Duration: 2 Days (9:00AM – 5:00PM)

  • Instructor: Ali Reza Azmi

  • Mode: Physical / Virtual
  • Level: Intermediate to Advanced

Course Overview

This 2-day advanced course is built for professionals ready to take automation to the next level.

Using Google Apps Script and ChatGPT side by side, participants will learn how to automate Gmail, Drive, Calendar, and Sheets — and integrate external APIs for real-world business solutions.

With hands-on coding, group activities, and a final project, this course will equip you to build efficient, end-to-end automations and troubleshoot with confidence using ChatGPT.

What You’ll Learn

  • Use Google Apps Script to automate complex workflows across Gmail, Drive, Calendar, and Sheets.

  • Work with ChatGPT as your coding assistant to generate, improve, and troubleshoot Apps Script code.

  • Integrate external APIs and Google services into one seamless workflow.

  • Build, present, and refine a real-world automation project based on your own use case.

Who Should Join?

This course is ideal for:

  • Professionals familiar with Google Apps Script looking to advance their skills
  • Individuals wanting to automate real business tasks/workflows using ChatGPT and code

Prerequisites

  • Completion of our 1-Day course or equivalent knowledge
  • Comfortable using Google Workspace tools like Sheets, Gmail, Drive, and Calendar

Course Modules

Learn advanced scripting techniques in Google Sheets, including complex data manipulation and custom functions.

Hands-on activity: Automate data processing across multiple sheets using Apps Script and ChatGPT.

Explore advanced email automation and file organisation strategies for Google Drive.

Hands-on activity: Build a script to send email reports and automatically organise Drive folders.

Automate event creation, reminders, and recurring meetings for your team or department.

Hands-on activity: Create an automated system that manages recurring meeting schedules.

Learn how to use APIs to bring data into your Google Sheets and build more dynamic apps.

Hands-on activity: Use Apps Script to fetch data from an external API and display it in Sheets.

Build end-to-end workflows across Google services and learn to debug efficiently with ChatGPT.

Hands-on activity: Automate a workflow for data collection, report generation, and email notifications.

Apply your skills to solve a real-world business task and present your automation to the group.

Hands-on activity: Build and present a complete automation solution using Apps Script and ChatGPT.

Featured Review

Latihan ni memang best! Penyampaiannya jelas dan tak boring, senang nak faham konsep yang diajar. Paling syok sebab boleh tanya soalan dan discuss sama-sama. Team trainer memang buat kerja bagus, rasa puas hati sangat. Lagi best, trainer guna dwibahasa English dan Melayu, jadi semua orang senang follow.

Mohamad Ariffin Bin Zainudin, Kementerian Digital

23rd October 2024

Meet Your Trainer

Founder of Twenty-Four Consulting Ali Reza Azmi

Ali Reza Azmi

Founder & CEO @ Twenty-Four Consulting

Ali has trained hundreds of professionals across Malaysia in using AI and automation to improve workplace efficiency. With a background in digital transformation, Ali combines technical knowledge with real-world use cases to deliver engaging, results-driven training.

Frequently Asked Questions

Yes, all participants who complete the course will receive a digital certificate of completion.

You should have prior experience with Apps Script or have completed our 1-Day course. Basic scripting knowledge is recommended.

Yes. We offer in-house and private group training sessions, either at your location or virtually.

Yes, this course is fully HRD Corp claimable. Learn what HRD Corp claimable means and follow our step-by-step guide to apply via the SBL-KHAS scheme. You can also contact us to customise the session or get help with the claim process.

Request Training

More Info & Resources

All you need to know to choose the right course.

More Info & Resources

We’re excited to announce that Twenty-Four Consulting is now an official Canva Agency Partner—the first in Malaysia & Southeast Asia.

All you need to know to choose the right course.

Recommended Reads

Related Courses

HRD Corp Claimable

This course is HRD Corp claimable. Find out how your team can apply and get started.