Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
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
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
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
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
From Friday, April 18 through Monday, May 5, 2025, we’re giving away nine of our best‑selling AI and coding guides on Amazon at no cost. Whether you’re curious about front‑end development, Python, Node.js, Google Apps Script, or mastering AI tools, there’s something here for every learner. Grab them while they’re free! 1. Build Websites with … 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
Introduction Google Docs provides a robust set of formatting tools, but sometimes, you may need to make bulk changes to your document styles programmatically. Instead of manually changing each heading, you can automate the process using Google Apps Script. In this tutorial, we’ll walk through a simple Google Apps Script that updates all Heading 2 … 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
The getUi() context error in Google Apps Script occurs when you try to call getUi() outside of a valid UI context. Here’s why it happens and how to fix it. 🔴 Error Message Exception: Cannot call getUi() from this context. 🛠️ Why Does This Happen? ✅ Correct Ways to Use getUi() Solution 1: Ensure It’s … Read more