Udemy - Build Your Own AI Secretary with Google Sheets and Apps S...
Build Your Own AI Secretary with Google Sheets & Apps Script
https://WebToolTip.com
Published 7/2025
Created by Gunaseelan Bhaskaran
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 7 Lectures ( 2h 16m ) | Size: 1.84 GB
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.