Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Vibe Teaching — Issue #7 Beyond Prompts: Designing AI-Powered Learning Systems Most educators start using AI with prompts. “Explain this…”“Create a lesson…”“Generate questions…” And that’s a good start. But it’s only the beginning. Because the real power of AI in education isn’t just in individual prompts. It’s in systems. The Limitation of One-Off Prompts Using … Read more
🚀 Apps Script + Gemini Mastery — Issue #18 https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects AI Google Docs Content Refiner Rewrite, summarize, improve, and transform documents automatically using Google Apps Script + Gemini. ⭐ What You Will Build In this issue, you’ll build an AI Content Refiner for Google Docs that can: ✍️ Rewrite content in different tones📄 Summarize long … Read more
🚀 Apps Script + Gemini Mastery — Issue #17 AI Spreadsheet Cleaner + Fixer Automatically clean, standardize, and fix messy spreadsheet data using Google Apps Script + Gemini. ⭐ What You Will Build In this issue, you’ll build an AI Data Cleaner that can: 🧹 Fix inconsistent formatting🔤 Standardize capitalization📅 Normalize dates📊 Clean categories and … Read more
Vibe Teaching — Issue #6 Teaching Students How to Use AI (Properly) Most students are already using AI. But here’s the problem: They don’t know how to use it well. They type vague prompts.They accept the first answer.They don’t question accuracy.They don’t refine responses. And as a result… They don’t learn effectively. The Hidden Skill … Read more
🚀 Apps Script + Gemini Mastery — Issue #16 AI Spreadsheet Data Analyzer Use Apps Script + Gemini to automatically analyze spreadsheet data, identify trends, detect anomalies, and generate plain-English insights. ⭐ What You Will Build In this issue, you’ll build an AI Data Analyzer for Google Sheets that can: 📊 Read spreadsheet data🧠 Analyze … Read more
🚀 Vibe Coding — Issue #24 Decisions Under Uncertainty: Making Better Technical Choices with AI Decision-Making • Tradeoffs • Uncertainty • Risk • Clarity Over Confidence Every developer makes decisions. But the hardest ones aren’t about syntax —they’re about uncertainty. Issue #24 is about navigating those decisions with clarity. 🧠 The Illusion of Certainty Many … Read more
Vibe Teaching — Issue #5 Designing AI-Resilient Assignments Let’s be honest. Most traditional assignments are now AI-solvable in seconds. Essays.Summaries.Basic coding tasks.Definitions.Explanations. Students don’t even need to think anymore. And that creates a problem. Because if AI can complete the assignment… What exactly is being assessed? The Wrong Goal: “AI-Proof” Assignments Some educators are trying … Read more
Vibe Teaching — Issue #4 AI as Your Teaching Co-Designer Most conversations about AI in education focus on one question: Will AI replace teachers? But that question misses something much more interesting. The real shift happening right now is this: AI can become the most powerful teaching assistant ever created. Not because it replaces educators. … Read more
Thinking Together: Collaboration, Pair Programming & AI as a Team Member Collaboration • Shared Reasoning • AI Pair Programming • Team Alignment • Better Decisions Modern development is rarely a solo activity. Most real progress happens through collaboration: AI is now entering that environment. Issue #23 explores how AI changes the way developers collaborate. 🧠 … Read more
🚀 Apps Script + Gemini Mastery — Issue #15 https://github.com/lsvekis/Apps-Script-Code-Snippets AI Spreadsheet Dashboard Generator Automatically generate a complete analytics dashboard from spreadsheet data using Google Apps Script + Gemini. Instead of manually building charts and layout, users can simply describe the dashboard they want. Example request: “Create a sales dashboard with revenue by region and … Read more