Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
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
JavaScript DOM Game Dev (Beginner-Friendly): Build a “Reaction + Score” Click Game If you can select an element, listen for a click, and update text on the page, you can build a game. The DOM (Document Object Model) is the browser’s “live” representation of your HTML. When you write JavaScript that changes what’s on screen—moving … Read more
Learning something new shouldn’t feel overwhelming, slow, or frustrating — yet for many learners, it still does. We reread the same material.We watch videos twice.We get stuck, unsure what to do next. Generative AI changes this — not by replacing learning, but by transforming how we learn. That’s why I created the AI-Assisted Learning Quickstart … Read more
https://github.com/lsvekis/Apps-Script-Code-Snippets/tree/main/google-apps-script-chunking-pattern If you’ve ever run a Google Apps Script and hit this dreaded error: Exceeded maximum execution time —you’re not alone. This happens a lot when working with Google Docs, Sheets, Drive, or Gmail, especially when looping through large documents, spreadsheets, or folders. The good news?You don’t need to rewrite everything or give up on … Read more