Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
This weekend, I had the privilege of presenting at DevFest USF (University of South Florida) — part of the world’s largest community-driven tech conference hosted by Google Developer Groups. Held on November 15, 2025, at the USF Engineering Building II in Tampa, the event brought together an incredible community of developers, students, innovators, and tech … Read more
GitHub https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects/tree/main/summarizer 🌐 Building a Web Article Summarizer & Citation Extractor with Google Sheets + Gemini AI Have you ever wished you could drop a list of article URLs into Google Sheets and instantly get structured summaries — complete with titles, key quotes, named entities, and estimated reading time?In this exercise, we’ll create exactly that … Read more
🌍 Build an AI Translator & Tone Converter in Google Sheets (with Gemini & Apps Script) Github https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects 🚀 Overview In this exercise, you’ll learn how to connect Google Sheets to Gemini’s REST API using Apps Script, enabling you to automatically translate text and rewrite it in different tones — all directly from your spreadsheet. … Read more
Artificial intelligence is no longer limited to chat interfaces — you can now embed powerful AI tools directly into your favorite Google Workspace apps. In this tutorial, we’ll walk through how to build an AI Text Rewriter inside Google Sheets using Google Apps Script and the Gemini REST API. GitHub https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects/tree/main/AI%20Text%20Rewriter%20in%20Google%20Sheets By the end, you’ll … Read more
Code at GitHub https://github.com/lsvekis/Apps-Script-Survey/tree/main Build a Data-Driven Survey Web App with Google Sheets + Apps Script If you’ve ever wished Google Forms gave you more control over styling, page flow, and your data model, this pattern is for you. Below is a practical, beginner-friendly recipe for building a custom, multi-page survey that reads questions from … Read more
Getting Started with Vibe Coding 1.1 What is Vibe Coding? Vibe Coding is a way of learning programming that removes fear and friction. Instead of sitting in front of a blank screen, unsure of where to begin, you describe what you want in plain English and use AI to help you turn it into working … Read more
How to Use These Exercises Exercise 1: Hello, World! 👋 Objective: Learn the most basic function of Apps Script: creating a function and logging a message to the execution log. Instructions: Write a script that logs the message “Hello, World!” to the console. Solution: Explanation: Exercise 2: Send a Simple Email 📧 Objective: Use the … Read more
Welcome to Your Ultimate Guide to Google Apps Script Ever find yourself lost in a sea of repetitive tasks within Google Sheets, Docs, or Gmail? Have you ever thought, “There has to be a better way to do this”? There is, and you’ve found it. Enter Google Apps Script, the powerful, cloud-based scripting platform built … Read more
Download files When I released my 100 Google Apps Script examples for Google Sheets, one of the most common follow-up requests was: “Can I run all the examples automatically, without launching them one by one?” The answer is yes—and the solution is a master runner function that launches and tests all the functions in the … Read more
Download PDF guide Comprehensive 28-day guide to learning Google Apps Script, designed for complete beginners. Each day’s lesson should take less than an hour to complete. How to Use This Guide Welcome to your 28-day journey into Google Apps Script! This guide is designed to take you from a complete beginner to someone who can … Read more