Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
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
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
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
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
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
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