Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
🚀 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
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
Real-World Automation Patterns for Google Workspace https://github.com/lsvekis/Apps-Script-Code-Snippets/tree/main/google-apps-script-50-more-snippets-201-250 Google Apps Script becomes truly powerful when you move beyond basic examples and start building real automation systems. That’s exactly what this collection delivers. This set of 50 additional Google Apps Script snippets (201–250) focuses on practical, reusable building blocks you can plug directly into production workflows inside: … Read more
If you regularly work with long documents, you’ve probably encountered one of the most annoying formatting problems: Double spaces scattered throughout your text. This often happens when content is: Manually fixing these spacing issues can take a significant amount of time — especially in large documents. The good news? You can solve this problem instantly … Read more
Formatting large documents in Google Docs can quickly become tedious—especially when inconsistent font sizes are scattered throughout your content. A common issue many users face is having body text accidentally formatted at a larger size, such as 24 pt, when it should be standard reading size like 16 pt. Instead of manually searching and fixing … Read more
What Each Snippet Does (Copy/Paste Ready) https://github.com/lsvekis/Apps-Script-Code-Snippets/tree/main/examples If you’ve already mastered the basics of Google Apps Script, the fastest way to level up is to study real automation patterns—then reuse them in your own projects. This guide walks through 100 additional Apps Script examples (101–200) across: Each example is working code (copy/paste), and below you’ll … Read more
Apps Script + Gemini Mastery — Issue #12 AI Meeting Notes → Action Plan for Google Docs Turn raw meeting notes into structured decisions, action items, and follow-up emails using Apps Script + Gemini. https://github.com/lsvekis/Apps-Script-Code-Snippets ⭐ What You Will Build You’ll build an AI-powered tool that: 📝 Takes messy meeting notes (copied or written in … Read more
Images can quickly break the layout of a Google Doc.If you’ve ever pasted screenshots, charts, or photos into a document, you’ve probably had to manually resize each one so it fits nicely on the page. Good news: Google Apps Script can automate this completely. In this post, you’ll learn how to use a simple Apps … Read more
https://github.com/lsvekis/Apps-Script-Code-Snippets 🚀 Apps Script + Gemini Mastery — Issue #11 AI Email Draft Assistant for Gmail Generate reply drafts from a Gmail thread using Apps Script + Gemini (tone + action items + subject options). ⭐ What You Will Build You’ll build an AI assistant that: 📥 Pulls the most recent email thread from Gmail … Read more
https://github.com/lsvekis/Apps-Script-Code-Snippets If you’ve ever worked on a long Google Doc with lots of images, you know the pain:some images are too large, some too small, and manually resizing each one is tedious and inconsistent. The good news? Google Apps Script can handle this automatically. In this post, you’ll learn how to use a simple Apps … Read more