Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
Github https://github.com/lsvekis/20-Gemini-Exercises 📘 Google Docs + Gemini AI — Complete Guide for Beginners Build AI-powered writing tools directly inside Google Docs using Apps Script This guide walks you through five AI tools you can add to any Google Doc using Apps Script and Google’s Gemini API. You’ll learn how each function works, how to use … Read more
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
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 — 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
📘 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
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
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
📘 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
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
(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