Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
🚀 Apps Script + Gemini Mastery — Issue #5 https://github.com/lsvekis/Build-an-AI-Email-Assistant-for-Gmail Build an AI Email Assistant for Gmail Draft replies, summarize long threads, extract tasks, detect tone, and create a Gmail sidebar — all powered by Gemini. ⭐ What You Will Build in Issue #5 A complete AI Email Assistant for Gmail that can: 📩 Summarize … Read more
🚀 Apps Script + Gemini Mastery — Issue #4 https://github.com/lsvekis/rag-script-Gemini-Rag Bring context-aware AI answers to your own documents — summaries, explanations, knowledge extraction, and more. ⭐ What You Will Build in Issue #4 A fully functioning RAG pipeline, completely in Apps Script: This is the same technique used in advanced AI apps — now fully … Read more
1. What is Google Apps Script primarily used for? A. Building Android appsB. Automating and extending Google Workspace appsC. Managing Google Cloud infrastructureD. Designing static HTML websites Correct answer: BExplanation: Google Apps Script is a JavaScript-based platform used to automate, integrate, and extend Google Workspace apps like Sheets, Docs, Gmail, Forms, and Drive. It’s not … Read more
🚀 Apps Script + Gemini Mastery — Issue #3 AI Data Analyst for Google Sheets Ask AI questions about your data. Get summaries, trends, anomalies, and insights — automatically analyzed inside Sheets. ⭐ What You Will Build in Issue #3 A full AI Data Analyst sidebar for Google Sheets that can: 🔍 Analyze selected ranges📊 … Read more
Issue #2 https://github.com/lsvekis/apps-Script-Gemini-Repo AI Content Generator for Google Docs Write blog posts, lesson plans, summaries, outlines & formatted documents using Gemini — all from a custom Apps Script menu. ⭐ What You Will Build in Issue #2 A full AI Content Generator inside Google Docs with menu items like: AI Tools → Generate Blog Post … Read more
https://github.com/lsvekis/Chunk-your-data-Google-Apps-Script How to Chunk Data in Google Apps Script (So You Don’t Hit “Exceeded Maximum Execution Time”) If you work with large spreadsheets or big Drive folders in Google Apps Script, you’ve probably seen this error: Exception: Exceeded maximum execution time Most Apps Script executions have a hard time limit (often around 6 minutes per … Read more
🚀 Apps Script + Gemini Mastery — Issue #1 “Your First AI-Powered Script: Build a Smart Document Analyzer” A newsletter series for experienced Google Apps Script developers who want to level up with AI-powered automation, real-world exercises, and fully working code. ⭐ Welcome to the Series This series will teach you how to: Each issue … Read more
📘 Lesson 1 — Your First API Call with Google Apps Script (UrlFetchApp Guide) Blog Post #1 in the Apps Script + APIs + Gemini Series Working with APIs is one of the most important skills you can learn as a Google Apps Script developer. Whether you’re building dashboards, automating workflows, or integrating AI tools … Read more
Gemini just made Google Docs a whole lot smarter. In this upgrade, you’ll unlock five new AI-powered tools that supercharge your writing workflow—expanding content, rewriting tone, generating titles, extracting bullet-point insights, and even proofreading your text. With a clean Apps Script file and a custom “Gemini AI” menu, any Google Doc becomes your own intelligent … Read more
Github https://github.com/lsvekis/20-Gemini-Exercises Google Docs & Google Sheets AI Helpers with Custom Menus This toolkit lets you add Gemini-powered AI features directly into: All with: 🧱 1. Project Structure You’ll create two separate container-bound projects: A) Google Docs toolkit (Doc-bound) Files: B) Google Sheets toolkit (Sheet-bound) Files: The same SharedHelpers.gs code can be reused in both … Read more