Build Your Own Ai Secretary With Google Sheets & Apps Script

An AI assistant that summarizes and analyzes your business KPI's and delivers routine updates to you via voice notes.

What you'll learn

Setup Google Cloud Platform to enable additional AI services to be called directly from Google Sheets using API key.

Use Apps Script to create automation functions within Google Sheets - check for data and send reminder emails if data is not updated on time.

Use Apps Script to create a function where selected data from Google Sheets can be compiled and sent to Google Gemini AI model for analysis.

Use Google Text-to Speech function to create voice summaries that can be sent out automatically via email.

Learn how to create similar solutions within the Google apps ecosystem without any coding knowledge by utilizing the power of Gemini AI.

All these outcomes equal to an AI "secretary" that can validate information, send reminder where necessary, analyze data and update us on the go.

Requirements

No specific coding experience needed.

Ideally a Google Workspace user, but this is not a requirement.

Description

Why this course?Monitoring routine productivity data, project progress and task status requires us to stay on top of critical Key Performance Indicators (KPI's) of various kinds. This can get complicated if many things are moving at parallel, and sometimes all we want is to have someone to summarize the important information and update us verbally. It is even better if a simple analysis can be done to highlight any anomalies, and present the information in a "standard" format consistently, so that we are able to grasp the key data easily. Who would need this?This is especially true (but not limited to) for business owners, project managers and team leaders who are generally busy with a wide range of responsibilities and are using Google Sheets to keep track of stuff. We all can do with an "AI secretary" that can keep us updated routinely on-the-go.Why now? The recent advancements in AI means now we all have the tools to create any type of custom AI solutions, including for the "problem" above. Google is especially great in this aspect, since it has some of the most advanced and cost efficient AI models, along with an entire tech stack that can be easily plugged into existing apps such as Sheets, Gmail, Docs, etc. Their newer AI models (such as Gemini 2.5 Pro) are extremely good in coding, which has further opened up possibilities to integrate AI & automation into existing workflows via tools like Apps Script, which was previously a domain reserved for the IT savvy individuals. Google has empowered everyone to be a citizen developer now, enabling us to built custom solutions for our business and personal use. What is this course about?This short crash course illustrates the above point as easily and practically as possible. This course is about creating an "AI Secretary" that does the following:Look at a set of pre-determined KPI data in Google Sheets that gets updated routinely by a staff/worker/etc. Automatically send out a reminder email to them if the data is not updated on time. Collect a pre-determined KPI's from the data, compile them and send it over to a Google AI model to perform a simple analysis/comparison and highlight any anomalies. Convert the output into a voice note. Email the voice note to another person (i.e. the boss, manager, etc.).How is it done?Google Apps Script is the magic tool here, which performs all the heavy lifting such as: Automatically checks data in Google Sheets, and creates a reminder email to be sent via Gmail. Taking data from Google Sheets, sending it over to Google Cloud's Vertex AI Platform where the Gemini AI model is based.The output text from Gemini AI model is then sent over to another Google tool (Text-to-Speech) to convert the text into voice note. Then email out this voice note via Gmail, and update the status in Google Sheets. What makes this course special?Apps Script is a "low code" platform, which traditionally means we need to have knowledge on JavaScript coding language to create functions and run them accordingly. Traditionally, this was an "elite" tool that was reserved for the IT savvy individuals and third party developers. Here is the interesting part - all this can now be configured, set-up and deployed by anyone without any coding knowledge - literally zero expertise is needed. That's exactly how I did it, and this course takes you through the concepts and steps on how you can do it too. The combination of Apps Script and Gemini's coding ability has opened up an entire new set of possibilities for businesses to build hyper specific, localized & custom solutions. Well technically 80% of any workflows can benefit from some type of AI and/or automation, and this is a simple yet effective demonstration on how you can get started. This course at a minimum will enable you to build a similar solution, and at best inspire you and provide the means to take on any other simple-to-complex use cases. What tools?These are the specific Google tools that are involved in this course:Google SheetsGmailGoogle Apps ScriptGoogle Cloud Platform (GCP)This course takes a beginner approach, where all the fundamentals related to Apps Script and GCP are explained, so that anyone can create an account in GCP and follow the steps to build a working solution.What's included?Apps Script code (JavaScript) is provided, which can be copied, pasted and run with minimal configurations. The same code base can be used to create variations to suit custom use case as well.

Overview

Section 1: The Fundamentals

Lecture 1 Concepts & Workflows

Lecture 2 The Tools We Need

Section 2: Let's Build

Lecture 3 Setting Up Google Sheets and Google Cloud Project

Lecture 4 Apps Script Coding & Configuration

Lecture 5 Test & Deploy

Lecture 6 Creating Variations using Gemini 2.5 Pro

Section 3: Closing

Lecture 7 Google API's & Costing Strategy

Manager & leaders who have the need to keep track of business critical KPI's regularly on the go.,Individuals who are generally exploring how AI can be integrated as part of their existing Google Apps workflows, especially Google Sheets.,Individuals who are curious about "vibe coding" and looking to explore how Gemini + Apps Script can be a powerful combo to build custom business solutions in Google Workspace.