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 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
Vibe Teaching — Issue #3 The AI Copy-Paste Trap (And Why Students Are Learning Less) AI is one of the most powerful learning tools ever created. But something surprising is happening. In some classrooms, students are actually learning less. Not because AI is bad. Because it’s being used poorly. This is the AI Copy-Paste Trap. … Read more
Vibe Learning Framework A Visual System for Learning Faster in the Age of AI Executive Overview Learning is undergoing one of the most significant transformations in human history. For centuries, education focused on transferring knowledge from experts to students. This system worked when information was limited and difficult to access. However, the modern world operates … Read more