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.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant

HRD Corp Claimable Course for Employers Registered with HRD Corp

Course Code: M343

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