Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Sheets is an incredibly versatile tool for managing and organizing data. However, if you want to get notified when new data is added, you need to set up some automation. With Google Apps Script, you can create a script to send email notifications whenever a new row is added to a specific sheet. This … Read more
Google Apps Script is a powerful tool that allows you to automate tasks across Google Workspace. In this tutorial, we will walk you through the process of resizing all images in a Google Doc to 90% of their page size using Google Apps Script. This can be particularly useful for ensuring consistency and optimizing the … Read more
How to Do Custom Form Validation with Google Apps Script in a Web App Google Apps Script provides a powerful platform for creating web applications that interact with Google Workspace. One common requirement for web apps is form validation. In this blog post, we’ll walk through how to implement custom form validation using Google Apps … Read more
Google Apps Script is a versatile tool for automating tasks within Google Workspace. However, encountering errors like “data not defined” can be frustrating. In this blog post, we’ll troubleshoot a common issue in a script that displays Google Sheets data in a dialog box. Understanding the Error The error message “data not defined” typically indicates … Read more
Google Apps Script is a powerful tool that allows you to automate tasks across Google’s suite of apps. One practical use case is to create an API endpoint that outputs data from a Google Sheet as JSON. This can be particularly useful for integrating Google Sheets data with other applications. In this blog post, I’ll … Read more
In this tutorial, we will create a Google Apps Script that highlights duplicates in a specified column of a Google Sheet. The script will ignore the first occurrence of each value and only highlight subsequent duplicates. This can be particularly useful for data analysis, ensuring that you can easily spot repeated entries. Step-by-Step Guide Step … Read more
Google Apps Script is a powerful tool for automating tasks across Google Workspace applications. In this blog post, we will walk through how to use Google Apps Script to update specific paragraphs in a Google Doc. We will cover two functionalities: We’ll also include an image to enhance the visual appeal of this post. Step-by-Step … Read more
JavaScript is a powerful and versatile language, but it comes with its own set of quirks and oddities. Understanding these can help you write better code and debug issues more effectively. Here are ten lesser-known JavaScript quirks, complete with detailed examples. 1. Type Coercion in Comparisons JavaScript performs type coercion when comparing values with == … Read more
Printing documents programmatically can be very useful in automating workflows, especially when dealing with repetitive tasks. Google Apps Script provides a way to print documents from Google Docs, either as a whole or selectively. In this blog post, I’ll guide you through creating a Google Apps Script that prints an entire document or specific parts … Read more
Connecting data from an Excel sheet to a Google Sheet can streamline your workflow, especially if you are transitioning from Microsoft Excel to Google Sheets. Google Apps Script provides a powerful way to automate this process. In this blog post, I’ll guide you through the steps to connect data from an Excel sheet to a … Read more