TU5.8 - Apps Script and Gemini Next '24 Redux: Build custom AI-powered Google Workspace solutions
Channel: Totally Unscripted
Date: 18/04/2024

Join the TU team as we delve into the world of custom generative AI solutions for Google Workspace using Apps Script. Discover how developers are seamlessly integrating Gemini's large language models to revolutionize productivity and automation. We'll explore real-world examples demonstrating how AI can supercharge your Workspace experience. Imagine having Gemini as your Apps Script coding assistant, intelligently naming untitled documents, crafting next-generation mail merges, and so much more. 

Get ready to learn, be inspired, and unlock the full potential of intelligent automation within Google Workspace.

Episode Links
Apps Script and Gemini: Build custom AI-powered Google Workspace solutions - https://cloud.withgoogle.com/next/session-library?session=COL300

Extend the Google Workspace UI - https://developers.google.com/workspace/extend 

Gemini for Google Workspace Prompt Guide https://goo.gle/prompt-guide-101 

AI Slides Reviewer with Google Workspace and Gemini https://youtube.com/watch?v=NVyf6teUE4c 

Build an AI slides reviewer with Gemini - https://ai.google.dev/examples/slides-advisor 

CODE: Slides Advisor [GitHub] - https://github.com/googleworkspace/slides-advisor-add-on

New Card Builder Kit https://addons.gsuite.google.com/uikit/builder

Answer questions based on Chat conversations with a Gemini AI Chat app - https://developers.google.com/workspace/chat/tutorial-ai-knowledge-assistant 

Google Apps Script library for Gemini API - GeminiApp https://github.com/mhawksey/geminiapp 

Exploring Gemini API Function Calling with Google Apps Script https://medium.com/cts-technologies/genai-for-google-workspace-exploring-gemini-api-function-calling-with-google-apps-script-part-3-028785dafe3b 

Key moments
(0:05) Google Cloud Next & Introducing Duet AI/Gemini 
We start with a recap of Google Cloud Next, highlighting the event's energy and key takeaways. 

(5:14) Extracting Insights & Building with Duet AI/Gemini 
We dive deeper into Gemini's capabilities, with Alice demonstrating how it extracts data from emails and Google Drive, generates insights, and assists in building spreadsheets and dashboards. Alice shows how Gemini can generate Apps Script code, enabling the creation of custom solutions and visualizations. 

(22:05) Custom Functions & User-Centric Solutions 
We then show some examples of how the Gemini API can be used across Google Workspace apps, including custom functions in Google Sheets

(34:00) Bulk Automation & Content Evaluation with AI 
The focus turns to bulk automation tasks, showcasing some Google Workspace editor add-ons that uses the Gemini API to process and summarize multiple documents simultaneously, evaluate Google Slide design and content.

(46:54) Taming Workflows & Streamlining Communication 
We demo a Google Docs add-on that assists with document naming and deletion based on AI-generated summaries. We also demonstrate a Gmail add-on that analyzes emails, extracts key information, and integrates with external platforms like Jira to provide context and support for customer interactions.

(59:59): Chat-Based Solutions & Enhancing Collaboration 
We turn our attention to the realm of Google Chat based solutions, showcasing a workspace add-on that automatically summarizes updates within a Google Chat space, facilitating efficient team collaboration and knowledge sharing.

(1:10:38): Link Previews & Vertex AI Integration 
We look at a new way to extend the user interface through link previews within Google Docs. We demonstrate an add-on that provides AI-generated summaries for Google Workspace developer documentation.

(1:23:41) Advanced Libraries, Function Calling & Future Possibilities 
We finally explore advanced techniques using the GeminiApp library, which simplifies integration with Gemini and enables function calling for enhanced automation such as personalised mail merges.