Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
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
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
📊 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
Google Apps Script is a powerful tool that helps you automate and extend Google Workspace apps like Sheets, Docs, Gmail, and Drive. Whether you’re a beginner or a seasoned scripter, these tips will help you write cleaner, faster, and more reliable code. ✅ 1. Use getActive() Sparingly While SpreadsheetApp.getActiveSpreadsheet() and DocumentApp.getActiveDocument() are convenient, they rely … Read more
When using Google Apps Script to copy data from one sheet to a log sheet, a common issue arises: the new sheet ends up with an empty first row. This typically happens when the data insertion starts from getLastRow() + 1, even when the sheet is brand new and completely empty. Here’s how we fix … Read more
This document provides a comprehensive collection of Google Apps Script examples tailored for Google Docs. Each script is designed to automate common tasks, enhance productivity, and extend the functionality of your documents. 1. Basic Document Access & Creation These scripts cover the fundamental ways to access existing documents, create new ones, and get references to … Read more
Discover My Latest Code Repositories & Downloadable Guides 📚💻 I’ve been hard at work over on GitHub crafting practical code examples and in-depth guides for web developers, automation enthusiasts, and Google Apps Script fans. Below you’ll find all my active repositories—each packed with hands‑on examples—and links to downloadable PDF versions so you can study offline … Read more