Build Your Own AI Secretary with Google Sheets & Apps Script

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 Sheets

• Gmail

• Google Apps Script

• Google 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.