Google Apps Script

Google Apps Script

Build AI-Powered Google Sheets with Gemini: A Complete Beginner’s Guide

by

https://github.com/lsvekis/20-Gemini-Exercises Learn how to use Google Apps Script + Gemini to automate ideas, translations, emails, summaries, and more AI is no longer something we only use in chat apps—it can now work directly inside your Google Sheets. With just a few lines of Apps Script, you can get Google’s Gemini model to: ✨ Generate creative … Read more

5 Simple Google Apps Script Exercises Using Gemini

by

https://github.com/lsvekis/5-Simple-Google-Apps-Script-Exercises-Using-Gemini 🚀 5 Simple Google Apps Script Exercises Using Gemini (With Full Code + Downloadable Repo) AI is transforming how we work inside Google Workspace—and with Google Apps Script + Gemini, you can now add AI superpowers directly into Docs, Sheets, and your everyday workflows. To help you get started quickly, I’ve created a set … Read more

Lesson 6 Chat Memory RAG Sheet Vector Index MultiSource AI

by

📘 Lesson 6 — Multi-Folder Workspaces (Switch Between Knowledge Bases) How to let your Apps Script + Gemini assistant dynamically switch between multiple folders (each with its own RAG index). 🔥 What Lesson 6 Adds Until now, your assistant worked with exactly one folder, and one RAG index sheet. Lesson 6 adds the ability to … Read more

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