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

Beginner  1 Day

Automating Your Workflow with Google Apps Script and ChatGPT

Master the basics of Google Apps Script and learn how to combine it with ChatGPT to automate your everyday tasks and save hours of manual work.

  • Duration: 1 Day (9:00AM – 5:00PM)

  • Instructor: Ali Reza Azmi

  • Mode: Physical / Virtual
  • Level: Beginner

Course Overview

This beginner-friendly course introduces you to the power of Google Apps Script and how it can automate your workflow across Google Workspace tools like Sheets, Gmail, Drive, Calendar, and Forms.

You’ll also learn how to integrate ChatGPT to assist with script generation, troubleshooting, and coding efficiency.

By the end of the session, you’ll walk away with a ready-to-use automation project, a quick reference guide, and the skills to start building your own time-saving solutions.

What You’ll Learn

  • Understand how Google Apps Script works and what you can automate with it.

  • Automate common workflows using Gmail, Google Sheets, Drive, Calendar, and Forms.

  • Use ChatGPT to generate, fix, and enhance your scripts with real examples.

  • Build and present a complete automation project based on your real tasks.

Who Should Join?

This course is ideal for:

  • Professionals who want to eliminate repetitive work using automation
  • Google Workspace users looking to streamline their daily tasks
  • Beginners with no coding experience who want to get started with scripting

Prerequisites

  • Familiarity with Google Workspace (Gmail, Sheets, Drive, Calendar)
  • No coding experience required — we’ll guide you step by step

Course Modules

Learn how to use Apps Script to automate tasks in Google Sheets and Gmail. Get hands-on with dynamic email creation, data processing, and integrating ChatGPT for script writing.

Hands-on activity: Automate data validation in Sheets and create a custom Gmail email sender using ChatGPT-generated scripts.

Explore how to manage files in Drive, schedule events in Calendar, and automate Form workflows.

Hands-on activity: Organise files in Drive and create Calendar events triggered by Form responses — all using simple Apps Script.

Learn the basics of working with external APIs, how to troubleshoot scripts using ChatGPT, and wrap up with a complete automation project.

Hands-on activity: Fetch weather data using an API, debug using ChatGPT, and build a script that automates report creation and sharing.

Featured Review

Very good input from the trainer, it helps me a lot to manage my work efficiently and dilligently. The Automation Process using AI and Google Workspace also increased my capability to maximise my output at my workplace. Thank you!

Mohd Amin Marwan bin Mohamad, Universiti Selangor

13th November 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.

No, this course is beginner-friendly. You’ll be guided step-by-step, with help from ChatGPT along the way.

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.