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

Power Up Your Workflow with Google Apps Script + Gemini

Automate, accelerate, and innovate inside Google Workspace Today, AI and automation are finally meeting where people already work: Google Workspace. In my latest presentation, Google Apps Script & Gemini — Power Up, I explored how anyone—beginner or advanced—can use simple JavaScript plus Google’s Gemini models to build smart tools directly inside Sheets, Docs, Gmail, and … Read more

100 Custom Google Sheets Functions Built with Apps Script — Your Ultimate Power Toolkit

Get the code on Github https://github.com/lsvekis/100-custom-Google-Sheets-functions Google Sheets is already one of the most versatile tools in the Google Workspace ecosystem, but when you combine it with Apps Script, it becomes a full-fledged programmable powerhouse. Today, I’m sharing something special:👉 100 custom Google Sheets functions written entirely in Apps Script — clean, flexible, fast, and … Read more

JavaScript DOM & Canvas Mini-Games — Exercises 91–100 (Pure JavaScript Edition)

Github https://github.com/lsvekis/JavaScript-DOM-Exercises/ Welcome back to the next chapter of the 100-exercise JavaScript DOM & Canvas series! If you’ve been following along, you already know the mission: ✨ Learn real JavaScript by building small, visual, interactive projects — with no frameworks and no complexity. Just vanilla JS, DOM APIs, Canvas 2D, and Web APIs, the way … Read more

JavaScript DOM & Canvas Games — Exercises 81–90

Github https://github.com/lsvekis/JavaScript-DOM-Exercises/ If you’ve ever tried to learn JavaScript and thought, “I get the syntax, but I’m not sure how to actually build things,” this set of mini-games is for you. Exercises 81–90 are part of a larger “JavaScript DOM Games” series: self-contained, vanilla JS projects that live in a single HTML file. No build … 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

Powering Up Google Apps Script with Gemini AI — My DevFest USF 2025 Talk Recap

This weekend, I had the privilege of presenting at DevFest USF (University of South Florida) — part of the world’s largest community-driven tech conference hosted by Google Developer Groups. Held on November 15, 2025, at the USF Engineering Building II in Tampa, the event brought together an incredible community of developers, students, innovators, and tech … Read more