Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
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 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
This set of exercises continues your journey through JavaScript, covering more advanced concepts and practical problem-solving techniques. Keep practicing and experimenting! Section 4: Intermediate to Advanced Concepts (Exercises 31-40) Exercise 31: Error Handling with try…catch Exercise 32: Understanding this Keyword Context Exercise 33: Arrow Functions (=>) Exercise 34: Object Destructuring Exercise 35: Array Destructuring Exercise … 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
📋 What You’ll Learn 1. What Is localStorage? Method What it does setItem(key, value) Save a string under key getItem(key) Retrieve string for key (or null) removeItem(key) Delete entry for key clear() Wipe all keys in this origin 2. Why JSON.stringify / JSON.parse? Since localStorage only holds strings, to store an object you must: 3. … Read more
In today’s fast-paced digital environment, automating routine formatting tasks can save you a lot of time. One common need is to highlight sentences that end with a question mark—especially when reviewing documents or preparing Q&A content. In this blog post, we’ll walk through how to create a Google Apps Script that scans through your Google … Read more
When working with Google Apps Script to extract and display Google Docs content in a web app, you might encounter a scenario where the <body> element in the exported HTML contains unwanted class attributes. These classes can affect styling and cause inconsistencies when rendering the content on your website. In this blog post, we’ll walk … Read more
If you’re working with Google Apps Script to automate tasks in Google Sheets, you may encounter issues that require debugging and improvements. In this blog post, we’ll analyze a given script, fix potential issues, and improve the overall functionality. Understanding the Code The script creates a custom menu in Google Sheets and provides various functions: … Read more