Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
đ Apps Script + Gemini Mastery â Issue #1 âYour First AI-Powered Script: Build a Smart Document Analyzerâ A newsletter series for experienced Google Apps Script developers who want to level up with AI-powered automation, real-world exercises, and fully working code. â Welcome to the Series This series will teach you how to: Each issue … Read more
đ Lesson 1 â Your First API Call with Google Apps Script (UrlFetchApp Guide) Blog Post #1 in the Apps Script + APIs + Gemini Series Working with APIs is one of the most important skills you can learn as a Google Apps Script developer. Whether you’re building dashboards, automating workflows, or integrating AI tools … Read more
Gemini just made Google Docs a whole lot smarter. In this upgrade, youâll unlock five new AI-powered tools that supercharge your writing workflowâexpanding content, rewriting tone, generating titles, extracting bullet-point insights, and even proofreading your text. With a clean Apps Script file and a custom âGemini AIâ menu, any Google Doc becomes your own intelligent … Read more
Github https://github.com/lsvekis/20-Gemini-Exercises Google Docs & Google Sheets AI Helpers with Custom Menus This toolkit lets you add Gemini-powered AI features directly into: All with: 𧹠1. Project Structure Youâll create two separate container-bound projects: A) Google Docs toolkit (Doc-bound) Files: B) Google Sheets toolkit (Sheet-bound) Files: The same SharedHelpers.gs code can be reused in both … Read more
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