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 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