Google Apps Script

Google Apps Script

Reset Chat Show Sources Lesson 5

by

📘 Lesson 5 — Reset Chat + Show Sources (Docs & Chunks) in the UI By now you have: – A RAG index in Sheets (Lesson 4B) – Chat history + RAG working together (Lesson 4C) – A web app UI (from Lesson 2) calling google.script.run But two things are missing: – Users can’t reset … Read more

Lesson 4 – Leveling Up Your Gemini RAG Assistant

by

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

by

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

by

📘 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

by

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

Demote All Headings in a Google Doc Using Apps Script

by

(H1 → H2, H2 → H3, etc.) When working with long Google Docs—course outlines, documentation, manuscripts, or AI-generated content—you often need to shift all heading levels down by one. For example: Doing this manually in a long document is tedious. Fortunately, Google Apps Script makes it possible to automate this task in seconds. This post … Read more

100 Useful Google Docs Apps Script Functions (That Every Docs Power-User Should Know)

by

Google Docs + Apps Script is a magic combo for automating writing workflows, templates, formatting, and reporting. https://github.com/lsvekis/100-Useful-Google-Docs-Apps-Script-Functions In this post, you’ll get 100 tiny utility functions you can drop into your own projects. Each one is: Tip: Create a single .gs file called docsHelpers.gs and paste all the functions there. Then call them from … Read more

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

by

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

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

by

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

Build a Gmail Smart Reply Assistant Using Apps Script Gemini

by

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