Apps Script Code Examples

Downloadable PDF Guides and Code Snippets and Resources

by

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

Track Email Opens in Google Sheets with Apps Script

by

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

Unlock the Power of Google Sheets: 100 Custom Formulas You Can’t Live Without

by

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

How to Build an Email Open Tracker with Google Apps Script and Tailwind CSS

by

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

100 Google Apps Script Snippets to Supercharge Your Google Docs

by

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

10 Google Apps Script Snippets to Instantly Power Up Your Google Docs

by

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

Supercharge Your Google Docs: Clean Up Messy Documents with Google Apps Script

by

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

What is Google Apps Script

by

Think of Google Apps Script as “JavaScript for Google”: it’s a simple way to automate and extend Google Sheets, Docs, Forms, Gmail, and other Workspace apps—all without leaving your browser. Here’s the quick-and-dirty on how to get started: Why it feels magic Give it a try: open the Script Editor in a blank Sheet, paste … Read more

Google Apps Script Triggers

by

In Google Apps Script, triggers are special functions that let your scripts run automatically in response to certain events—either in your Google Workspace documents (Sheets, Docs, Forms, etc.) or on a time-driven schedule. They fall into two broad categories: 1. Simple Triggers // Example: Simple onOpen trigger to add a custom menufunction onOpen(e) { SpreadsheetApp.getUi() … Read more

Google Apps Script to Automatically Update Heading Styles in Google Docs

by

Do you find yourself manually updating heading styles in your Google Docs to keep things consistent? If so, you’re not alone—and luckily, there’s a simple way to automate the process using Google Apps Script. In this tutorial, you’ll learn how to write a script that updates all Heading 4 elements to Heading 2, and then … Read more