Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
If you work with long Google Docs—guides, reports, lesson plans, ebooks, or AI-generated drafts—navigation quickly becomes painful. Headings exist… but readers still scroll endlessly. In this post, we’ll build a smart Apps Script that: ✅ Scans all headings in a document✅ Automatically generates a clickable Table of Contents✅ Inserts it at the top of the … Read more
🚀 Vibe Coding — Issue #16 Legacy, Scale & Longevity: Vibe Coding in Large Codebases Legacy Systems • Refactoring • Risk Management • Long-Term Maintainability • AI with Restraint If Issue #15 was about teams,Issue #16 is about time. Most real-world codebases: Vibe Coding at this level is not about speed.It’s about respecting constraints while … Read more
AI-Assisted Learning Workbook #2 From Understanding to Mastery Using AI to Think Better, Practice Deeper, and Transfer Knowledge How This Workbook Is Different The Quickstart Workbook teaches you how to use AI to learn. This workbook teaches you how to think with AI. Focus areas: This is where learning becomes durable. How to Use This … Read more
https://github.com/lsvekis/100-Advanced-Google-Apps-Script-Examples A) Sheets: Performance, Data Ops, Automation (1–25) 1) Batch update with RangeList (fast formatting) Does: Applies formatting to many ranges in one go. 2) Write values + formulas in one pass Does: Sets values and formulas efficiently. 3) Build an index of unique keys → row numbers Does: Creates a lookup map for fast … Read more
1) Custom menu in Google Sheets Does: Adds a menu item so users can click to run functions.How it works: onOpen() runs automatically when the file opens (for editors), and SpreadsheetApp.getUi() adds UI. function onOpen() { SpreadsheetApp.getUi() .createMenu(‘Tools’) .addItem(‘Say Hello’, ‘sayHello’) .addToUi(); } function sayHello() { SpreadsheetApp.getUi().alert(‘Hello from Apps Script!’); } 2) Show a toast … Read more
https://github.com/lsvekis/Apps-Script-Code-Examples 1) Add a Custom Menu on Open (Sheets) Does: Adds a menu to your spreadsheet UI.Use when: You want easy buttons for scripts. function onOpen() { SpreadsheetApp.getUi() .createMenu(‘Tools’) .addItem(‘Say Hello’, ‘sayHello’) .addSeparator() .addItem(‘Run Cleanup’, ‘cleanup’) .addToUi(); } function sayHello() { SpreadsheetApp.getUi().alert(‘Hello from Apps Script!’); } function cleanup() { SpreadsheetApp.getUi().alert(‘Cleanup placeholder.’); } 2) Show a … Read more
📘 AI-Assisted Learning Workbook #2 From Prompting to Independent Thinking By Laurence “Lars” Svekis Who This Workbook Is For This workbook is for learners who: 📌 Core Shift:Workbook #1 = Learning with AIWorkbook #2 = Thinking independently with AI 🧠 Workbook Philosophy AI should sharpen judgment — not replace it. This workbook trains learners to: … Read more
🚀 Vibe Coding — Issue #15 From Individuals to Teams: Adopting Vibe Coding Without Chaos Team Culture • Shared Standards • Guardrails • Trust • Sustainable AI Adoption Up to now, Vibe Coding has focused largely on individual mastery. Issue #15 answers the next hard question: What happens when everyone on the team starts using … Read more
Why Google Apps Script Couldn’t Convert My H2 Headings (and the Fix That Actually Works) If you’ve ever tried to programmatically convert Heading 2 → Heading 3 in Google Docs using Apps Script, you probably expected something simple like: And yet… nothing happened.Or worse: Exception: Unexpected error while getting the method or property setHeading on … Read more
🚀 Vibe Coding — Issue #14 From Chaos to Clarity: Real-World Vibe Coding Case Studies Before & After • Practical Workflows • What Changed • What Didn’t • Lessons Learned Up to now, Vibe Coding has focused on ideas, systems, and paths. Issue #14 answers the natural next question: What does this actually look like … Read more