AI + Automation: Google Sheets & Active Monitoring (Part 2)
By Saiful Anuar
Overview
Following the 2-week workplace implementation gap from Part 1, Part 2 focuses on evaluating real participant use cases and mastering advanced Google Sheets automation. Participants will refine their custom Gemini Gems based on actual operational feedback, automate complex spreadsheet calculations using plain-language conversational commands, and set up live active monitoring dashboards for shared team environments. The session culminates in an end-to-end capstone hackathon where teams build dynamic multi-user tracking systems connecting Google Docs context directly to automated Google Sheets reporting.
Target Audience
Project Managers, PMO Leads, Operations Managers, Business Analysts, Coordinators, and anyone using Google productivity tools
Course Duration
1 Day (9:00 AM – 5:00 PM)
Claimable
Yes - HRD Corp Claimable
Delivery Format
In Person - Workshop
Max Class Size
20
Learning Outcomes
Evaluate and Refine custom AI agents (Gems) using real workplace implementation data gathered during the 2-week application gap.
Execute complex spreadsheet data cleaning, formula generation (VLOOKUP, XLOOKUP, Nested IFs), and pivot table creation in Google Sheets using plain-language AI commands.
Build live active monitoring dashboards in shared Google Sheets that evaluate multi-user updates and automatically trigger executive status summaries.
Deploy an interconnected Google Workspace workflow—linking project Docs context to dynamic Sheets trackers—via a practical team capstone evaluation.
Prerequisites
- 1Laptop and Completion of AI + Automation: Fundamentals of AI & Google Docs Automation (Part 1). Access to Google Enterprise (or standard Google Workspace with access to Gemini / Gemini Gems).