Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
📧 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
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
Why This Post Exists If you’ve tried to clone heading styles (H1–H6, Title, Subtitle) from one Google Doc to another using Apps Script, you probably hit this wall: Invalid JSON payload received. Unknown name “updateNamedStyles”… Yep—updateNamedStyles isn’t supported for write operations in the Docs API (at least for now). You can read the named styles, … 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
It was an honour to speak and participate in the Build with AI event in San Francisco on May, 23rd 2025 https://gdg.community.dev/events/details/google-gdg-silicon-valley-presents-a-low-codeno-code-hackathon-for-building-bold-fast-and-smart
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