Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
š 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
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