Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
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
AI Chart Builder for Google Sheets https://github.com/lsvekis/Apps-Script-Code-Snippets Automatically generate charts from natural language using Google Apps Script + Gemini. Instead of manually configuring charts, users can simply describe the visualization they want. Example: “Create a bar chart of revenue by region” Apps Script will analyze the sheet and build the chart automatically. ⭐ What You … Read more
https://github.com/lsvekis/Apps-Script-Code-Snippets Artificial intelligence becomes far more useful when it can answer questions using your own data. One of the most practical ways to do this is to connect AI to a Google Sheet and create a chatbot that can read spreadsheet content, respond to questions, and stay grounded in the data already stored in the … Read more
https://github.com/lsvekis/Apps-Script-Code-Snippets 🚀 Apps Script + Gemini Mastery — Issue #13 AI Spreadsheet Formula Generator for Google Sheets Generate complex spreadsheet formulas from plain English using Apps Script + Gemini. ⭐ What You Will Build In this issue you will build an AI Formula Assistant for Google Sheets that can: 🧠 Convert plain language requests into … Read more