Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script provides a powerful way to automate tasks in Google Sheets. If you’re looking to manipulate specific columns in a spreadsheet based on their lengths, this blog post will guide you through the process using rowLength and columnLength. Step-by-Step Guide function selectSpecificColumns() { // Open the spreadsheet and get the active sheet var … Read more
Google Apps Script is a powerful tool for automating tasks in Google Sheets. One common task is copying data from one sheet to another without creating duplicates. In this post, we’ll walk through a script that accomplishes this using Google Apps Script. Scenario Imagine you have a sheet named “Orders” that contains statements of orders. … Read more
If you frequently work with Google Docs, you might encounter documents with inconsistent whitespace at the beginning or end of lines. Manually removing these spaces can be tedious and time-consuming. Fortunately, Google Apps Script provides a way to automate this task, ensuring your document is clean and well-formatted. In this blog post, we’ll walk through … Read more
Are you tired of manually formatting questions in your Google Docs? With Google Apps Script, you can automate this tedious task and ensure consistency throughout your document. In this blog post, we’ll show you how to create a script that identifies lines starting with a number followed by ‘Question:’, removes the number, and converts the … Read more
If you regularly work with Google Docs, you might find yourself manually formatting text to improve readability. For instance, you might want to highlight questions in your document by converting them into headings. With Google Apps Script, you can automate this process, saving time and effort. In this blog post, we’ll walk through a script … Read more
In today’s fast-paced digital world, maintaining the quality of documents is crucial, especially when dealing with templates that are used repeatedly. Google Apps Script offers a powerful way to automate tasks in Google Docs, ensuring consistency and quality. In this blog post, we will explore how to implement automatic quality checks for title headings in … Read more
Are you looking to enhance your Google Apps Script skills? Whether you’re a beginner or looking to refine your abilities, these 10 essential coding exercises will help you get a solid grasp of Google Apps Script. Each exercise comes with complete code and explanations, providing a comprehensive learning experience. Exercise 1: Creating a Custom Function … Read more
Google Apps Script provides powerful tools to interact with Google services, including Google Contacts. In this blog post, we’ll explore how to use the Advanced People Service in Google Apps Script to filter contacts by a specific label and list all contacts along with their labels. We’ll walk through two key functions: getContactsByLabel and listContactsAndLabels. … Read more
Google Apps Script is an incredible tool that allows you to extend the functionality of Google Sheets. By using Apps Script, you can create custom menus, automate tasks, and integrate with other Google services. In this blog post, we’ll explore how to add a custom menu to Google Sheets that triggers a popup alert, handle … Read more
Google Apps Script is a powerful tool that allows you to automate tasks within Google Workspace. One of its many capabilities is sending emails to a group of contacts. In this blog post, we’ll walk through the steps to create a script that sends an email to a group of contacts stored in a Google … Read more