Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
If you’ve ever found yourself needing to merge specific headings in your Google Docs with the following paragraph, you’re not alone. Whether it’s for organizing content, creating structured documents, or simply for aesthetic reasons, this task can be tedious when done manually. Fortunately, Google Apps Script offers a powerful way to automate this process. In … Read more
Expanding on our previous exercises, here are three more coding challenges to further enhance your skills with Google Apps Script. These exercises will guide you through creating a custom function, automating calendar events, and generating PDF files from Google Sheets data. Exercise 7: Create a Custom Function to Calculate the BMI Objective:Create a custom function … Read more
Continuing from our previous blog post, here are three more coding exercises for Google Apps Script. These exercises will help you deepen your understanding of Apps Script by creating custom functions, manipulating Google Sheets data, and integrating with external APIs. Exercise 4: Create a Custom Function to Convert Celsius to Fahrenheit Objective:Create a custom function … Read more
Google Apps Script is a powerful tool that allows you to automate tasks across Google Workspace products like Google Sheets, Docs, and Gmail. In this blog post, we’ll walk you through three coding exercises that will help you get started with Google Apps Script. These exercises range from creating custom functions in Google Sheets to … Read more
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
Sorting a column of dates and times in a specific format, like “Sun, Jun 2, 2024, 11:42 PM,” can be a useful feature when managing schedules, logs, or any time-sensitive data. Google Apps Script provides a powerful way to automate this process. In this blog post, we’ll walk through the steps to write an Apps … 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