Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
AI-Assisted Learning Workbook #3 Teaching, Designing, and Leading Learning with AI Using AI to Create Better Learning Experiences (Without Losing the Human Element) How This Workbook Fits the Series This workbook focuses on learning design, not just personal learning. By the end, readers will know how to use AI to: This is about teaching better, … Read more
https://github.com/lsvekis/100-NodeJS-Snippets 1) Basic “Hello World” HTTP server What it does: Starts a basic HTTP server on port 3000.Use it for: Quick sanity checks, learning request/response basics. 2) Minimal server with routing (no frameworks) What it does: Routes by URL with if statements.Use it for: Tiny services, prototypes, understanding routing fundamentals. 3) Read JSON body from … Read more
https://github.com/lsvekis/100-CSS-Snippets 1) Modern CSS Reset (minimal) Does: Prevents common layout surprises (box sizing, default margins, media sizing).Use it: Put at the top of your stylesheet for consistent baseline behavior. 2) Fluid Container Does: Keeps content readable on large screens and padded on small screens.Use it: Wrap page sections in .container. 3) Responsive Typography (clamp) Does: … Read more
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