Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
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
Want to know who opens the emails you send from Google Sheets? In this post, we’ll build a pixel-based email open tracker using Google Apps Script and log opens directly into your spreadsheet. What you’ll learn: 1. Project Setup 2. Server-side Code (Code.gs) Paste the following into Code.gs. Comments explain each section. What’s happening here? … Read more
Google Sheets is a remarkable tool for everything from personal budgeting to enterprise-level data analysis. But the built-in functions sometimes leave gaps when you need a specialized calculation, custom text manipulation, or seamless API integration. That’s where Google Apps Script comes in—it lets you craft your own formulas (called custom functions) to extend Sheets beyond … Read more
Tracking whether your emails are opened can be incredibly useful, whether you’re sending newsletters, important notifications, or just want to know if your message reached your audience. In this post, I’ll walk you through how to create a simple Email Open Tracker using Google Apps Script and a sleek front-end interface styled with Tailwind CSS. … Read more
Google Docs is an incredible tool for writing, collaboration, and documentation—but did you know you can unlock even more power with Google Apps Script? With just a few lines of code, you can automate repetitive tasks, enforce formatting standards, analyze content, and streamline your workflow. On Github at https://github.com/lsvekis/Apps-Script-Code-Snippets Today, I’m sharing 100 ready-to-use Google … Read more
Google Apps Script is a powerful way to automate, customize, and supercharge your workflow in Google Docs. Whether you want to clean up references, format your document, or do advanced text processing, a simple script can save you hours. Here are 10 essential Google Apps Script snippets every Google Docs power user should know! 1. … Read more
If you’ve ever copied and pasted content into a Google Doc, you know the pain: Over time, your documents can become cluttered and hard to manage. But what if you could automate the cleanup process in a single click? With Google Apps Script, you can! Below, I’ll share a script that cleans up your Google … Read more
My Google I/O 2025 Experience: A Front-Row Seat to the Future of AI This year, I had the incredible privilege of attending Google I/O 2025 — and let me tell you, it was one of the most exciting, jam-packed, and inspiring tech events I’ve ever been part of. Google showcased the cutting edge of what’s … Read more