Lesson 4 – Leveling Up Your Gemini RAG Assistant

Github https://github.com/lsvekis/Google-Apps-Script-APIs-and-Gemini 4A: RAG + API Data · 4B: Sheet Vector Index · 4C: Chat History By now, you’ve already built a powerful foundation: In Lesson 4, we’re going to level this up in three big steps: By the end, you’ll have an assistant that: 📘 Lesson 4A — Combine RAG + API Data in a … Read more

Lesson 3 Adding Embeddings Retrieval RAG to Your Gemini API Project

Github https://github.com/lsvekis/Google-Apps-Script-APIs-and-Gemini In Lessons 1 and 2, you learned how to: – Call public APIs using Apps Script – Read text from a Google Drive folder – Combine both sources into a Gemini prompt – Build a full UI web app Now it’s time to level up. In Lesson 3, we introduce: – Chunking (splitting documents … Read more

Build an API + Drive + Gemini Web App

📘 Lesson 2 — Build an API + Drive + Gemini Web App (No Indexing, Just Context) Github https://github.com/lsvekis/Google-Apps-Script-APIs-and-Gemini In Lesson 1, you learned how to: Now in Lesson 2, we’ll go one level up: You’ll build a chat-style web app where each question is answered using: No embeddings, no indexing — just direct context: … Read more

Getting Data from APIs with Google Apps Script

Github Repo https://github.com/lsvekis/Google-Apps-Script-APIs-and-Gemini In this project, your Hybrid AI Orchestrator pulls in real data from the web using APIs and then lets AI (local model + Gemini) interpret that data. To do that, we need to understand one key tool: UrlFetchApp — the Apps Script class that lets you call APIs. In this lesson you’ll … Read more

Build a Google Drive “Knowledge Base” Chatbot with Apps Script + Gemini

drive-rag-chatbot/├── Code.gs // Apps Script backend├── Index.html // Web app UI└── README.md // Basic project documentation Github https://github.com/lsvekis/Build-a-Google-Drive-Knowledge-Base-Chatbot In this lesson, you’ll learn how to turn a Google Drive folder into a simple “knowledge base” chatbot, powered by: You’ll be able to ask questions about the documents in a Drive folder (Docs, text files, and … Read more

Build a Gmail Smart Reply Assistant Using Apps Script Gemini

Github https://github.com/lsvekis/Build-a-Gmail-Smart-Reply-Assistant-Using-Apps-Script How to automate email drafting, summarization, and tone adjustments directly inside Gmail. Managing email is one of the biggest daily time drains for modern professionals. Whether you’re responding to customers, coordinating projects, supporting students, or managing internal communication—email takes time, focus, and energy. But what if Gmail could help you write replies automatically? … Read more

Google Sheets AI Data Analyst (Apps Script + Gemini)

https://github.com/lsvekis/Google-Sheets-AI-Data-Analyst Turn your spreadsheets into intelligent data assistants that explain, analyze, and visualize your data automatically. Managing data inside Google Sheets is something almost everyone does—students, analysts, project managers, educators, accountants, startup founders, and even executives. But interpreting that data often requires real time, skill, and patience. What if Google Sheets could explain your data … Read more

Build a Drive Folder RAG Chatbot Using Google Apps Script + Gemini

Get Github Files https://github.com/lsvekis/Drive-Folder-RAG-Chatbot (Step-By-Step Guide) Turn any folder of Google Docs into an AI-powered knowledge assistant AI assistants are becoming a core part of modern workflows—and thanks to Google Apps Script + Gemini, you can now build your own internal chatbot that answers questions using only the content stored inside a Google Drive folder. … Read more

Build a Google Docs AI Chatbot with Apps Script and Gemini

​​GitHub https://github.com/lsvekis/Google-Docs-AI-Chatbot-using-Apps-Script-Gemini PDF Have you ever wished you could drop a Google Doc into a chatbot and ask questions about it—and have the bot answer only from that document? In this post, you’ll build exactly that: An Apps Script-powered web app that lets the user select a Google Doc, then chat with an AI agent … Read more

Build AI-Powered Workflows with Google Apps Script + Gemini

Project source code https://github.com/lsvekis/Gemini-with-Apps-Script 🚀 6 Mini Projects You Can Copy, Learn From, and Use Today AI is transforming the way we work inside Google Workspace. Whether you’re building custom tools for Sheets, automating Gmail, or creating smarter Docs workflows, Gemini makes it possible to add real intelligence to your Apps Script projects with just … Read more