Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
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
Google Docs is already a versatile writing tool, but with Apps Script you can make it truly powerful. I’ve created a single-file utility pack called Doc Power Tools that adds a custom menu to your Google Docs with 10 of the most-requested automation features—things like inserting a clickable Table of Contents, cleaning formatting, running mail … Read more
PDF download Day 1: Introduction to Google Apps Script Welcome to your first day! Today is all about understanding what Google Apps Script is and writing your very first line of code. What is Google Apps Script? Google Apps Script is a cloud-based scripting language for light-weight application development in the Google Workspace platform. It’s … Read more
Day 1 – Introduction to Google Apps Script Goals: Topics: Code Example: Practice: Quiz (3 questions): Day 2 – Working with Google Sheets Goals: Topics: Code Example: Practice: Quiz (2 questions): Day 3 – Reading and Writing Ranges Goals: Code Example: Practice: Quiz (2 questions): Day 4 – Loops and Logic in Apps Script Goals: … Read more
This post walks through what the provided code does and how to set up the Google Sheet it expects. When you’re done, you’ll have a lightweight web app that: What the Code Does (at a glance) 1) doGet(e) — serve the web app 💡 Note about getActiveUser()This returns a non-empty email when your script runs … Read more
100 high-impact, copy-pasteable Google Sheets Apps Script snippets How to use A. Setup & Quality-of-Life 1) Add a Custom Menu Creates a “Sheet Tools” menu with quick actions. function onOpen() { SpreadsheetApp.getUi() .createMenu(‘Sheet Tools’) .addItem(‘Clear Selected Range’, ‘clearSelectedRange’) .addItem(‘Timestamp Selected Cells’, ‘timestampSelection’) .addToUi(); } function clearSelectedRange() { const range = SpreadsheetApp.getActiveRange(); if (range) range.clearContent(); } … Read more
📧 Send Custom Emails from Google Sheets Using Apps Script If you’ve ever needed to send personalized emails to multiple recipients—such as confirmation emails, reminders, or announcements—Google Apps Script offers a powerful way to automate this process using data from a Google Sheet. In this post, you’ll learn how to create a simple mail merge … Read more
📊 Automatically Timestamp Data Entries with Google Apps Script When working with Google Sheets, it’s often helpful to automatically add timestamps whenever data is entered or updated. Whether you’re tracking form submissions, logging status updates, or managing tasks, having an automatic “last modified” or “created on” column can boost clarity and accountability. In this blog … Read more