AI + Automation: Next-Generation Google Sheets for Project Managers

By Saiful Anuar

AIProductivityGoogle

Overview

Manual data entry and broken formulas heavily drain project team productivity. This 1-day practical workshop transforms professionals into AI workflow engineers using standard Google Workspace applications, requiring no premium enterprise upgrades. Participants will master advanced conversational AI prompts to build dynamic trackers, automate complex calculations, and deploy zero-code notification scripts. By the end of the session, teams will possess immediate automation frameworks capable of cutting manual project reporting times by up to 80%.

Target Audience

Project Managers, PMO Leads, Operations Managers, Logistics Managers, Coordinators

Course Duration

1 Day

Claimable

Yes - HRD Corp Claimable

Delivery Format

In Person - Workshop

Max Class Size

Learning Outcomes

1Construct comprehensive project management trackers and Work Breakdown Structures (WBS) using advanced prompt engineering frameworks with standalone AI tools.
2Utilise generative AI to draft, troubleshoot, and implement complex spreadsheet formulas and automated data validation rules without syntax errors.
3Execute data-driven project audits and performance analysis by leveraging AI conversational interfaces to identify cost overruns and baseline delays.
4Deploy custom, zero-cost workflow automations via AI-generated scripts to reduce manual administrative updates and automate stakeholder alert systems.

Prerequisites

Google Enterprise

Course Syllabus

Time	Module & Title	Focus & Practical Deliverables
09:00 - 10:00	Module 1: Prompt Engineering for Standalone PM Trackers	Master the prompt frameworks to generate comprehensive Project Milestone tables, WBS timelines, and task lists via the Gemini web app, ready to copy directly into standard Google Sheets.
10:00 - 11:00	Module 2: AI-Powered Formula Generation & Data Cleaning	Using Gemini as a 24/7 spreadsheet assistant. Generating complex formulas (VLOOKUP, XLOOKUP, Nested IFs) and diagnosing broken rows by describing the business logic in plain English.
11:00 - 11:15	Morning Coffee Break	Compliance Buffer
11:15 - 12:30	Module 3: Zero-Cost Project Analytics & Trend Auditing	Structuring data tables for AI compatibility. Exporting project data sheets to Gemini to analyze project delays, calculate budget burn rates, and generate text summaries for stakeholder reporting without pivot tables.
12:30 - 13:30	Networking Lunch	Exposed to Malaysian Corporate Context
13:30 - 14:30	Module 4: Dynamic Dashboard Building & Linked Client Reporting	Designing an executive dashboard in standard Google Sheets using AI-optimized chart layouts. Linking the data dynamically to Google Slides for automated, professional corporate reporting.
14:30 - 15:30	Module 5: Automating Standard Workflows via Apps Script	Using Gemini to write flawless, zero-code Google Apps Script. Participants will deploy simple scripts that automatically send automated email alerts when a task status changes to "Overdue" in a standard sheet.
15:30 - 15:45	Afternoon Coffee Break	Compliance Buffer
15:45 - 17:00	Module 6: The Operational PMO Hackathon & Capstone	A live, practical assessment where teams apply Modules 1-5 to rescue a simulated, unorganized project tracking sheet using free AI assets. Participants present their dynamic workflows, serving as the required HRD Corp learning evaluation.

Master the prompt frameworks to generate comprehensive Project Milestone tables, WBS timelines, and task lists via the Gemini web app, ready to copy directly into standard Google Sheets.

Using Gemini as a 24/7 spreadsheet assistant. Generating complex formulas (VLOOKUP, XLOOKUP, Nested IFs) and diagnosing broken rows by describing the business logic in plain English.

Compliance Buffer

Structuring data tables for AI compatibility. Exporting project data sheets to Gemini to analyze project delays, calculate budget burn rates, and generate text summaries for stakeholder reporting without pivot tables.

Exposed to Malaysian Corporate Context

Designing an executive dashboard in standard Google Sheets using AI-optimized chart layouts. Linking the data dynamically to Google Slides for automated, professional corporate reporting.

Using Gemini to write flawless, zero-code Google Apps Script. Participants will deploy simple scripts that automatically send automated email alerts when a task status changes to "Overdue" in a standard sheet.