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

Apps Script with Gemini Quick Start Guide

Apps Script with Gemini Quick Start Guide Github https://github.com/lsvekis/Apps-Script-with-Gemini-Quick-Start-Guide 1. What you’re building By the end of this guide you’ll know how to: All examples use the Gemini REST API (generativelanguage.googleapis.com) with an API key from Google AI Studio. 2. One-time setup 2.1 Get a Gemini API key You’ll use this key in Apps Script … Read more

How to Use TypeScript Files from Google AI Studio and Deploy Them Yourself

If you’ve been experimenting with Google AI Studio and have generated TypeScript files, you might be wondering how to actually run and deploy them in your own environment.This post walks you through everything — from setup to deployment — so you can go from AI Studio sample to live, running project in under 15 minutes. … Read more

Exercise 12 — AI Translator with Terminology Glossary

https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects/tree/main/Exercise%2012 Bring the power of Gemini into Google Sheets to translate text — and keep your organization’s terminology consistent. Most translation tools ignore your company’s unique language: acronyms, product names, or preferred wordings. In this project, you’ll build an AI Translator directly inside Google Sheets that not only translates text but also follows a custom … Read more

Exercise 9 — AI Meeting Minutes Generator

Github Source code https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects Meetings are important — but summarizing them can be tedious.What if your meeting notes could write themselves? In this project, you’ll build an AI Meeting Minutes Generator right inside Google Sheets, powered by Gemini 2.5 Flash and Google Apps Script. This exercise shows how to take raw meeting transcripts (from Zoom, … Read more

Exercise 8 AI Data Cleaner and Categorizer with Google Sheets + Gemini

Source code https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects/tree/main/AI%20Data%20Cleaner Managing messy product data is a constant headache — especially when you’re working with spreadsheets full of inconsistent titles, missing brands, and vague descriptions.In this exercise, we’ll build an AI-powered Google Sheets add-on that automatically cleans, classifies, and enriches product information using the Gemini API and Google Apps Script. By the end, … Read more

AI Translator and Tone Converter in Google Sheets

🌍 Build an AI Translator & Tone Converter in Google Sheets (with Gemini & Apps Script) Github https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects 🚀 Overview In this exercise, you’ll learn how to connect Google Sheets to Gemini’s REST API using Apps Script, enabling you to automatically translate text and rewrite it in different tones — all directly from your spreadsheet. … Read more

AI Grammar and Clarity Enhancer in Google Sheets

Github https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects/tree/main/AI%20Grammar%20and%20Clarity%20Enhancer%20in%20Google%20Sheets 🎯 Learning Objectives By completing this exercise, learners will: 🧠 What You’ll Build You’ll create an AI-powered Grammar and Clarity Enhancer directly in Google Sheets.This app will: 🧾 Step 1: Create the Files In Apps Script, create: 📂 gemini-sheets-grammar/ ├── Code.gs ├── Sidebar.html ├── appsscript.json 💻 Step 2: Code.gs Paste the following code: … Read more