Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
Introduction: Google Apps Script allows you to extend the functionality of Google Sheets by creating custom formulas and functions. These custom functions behave just like built-in spreadsheet functions and can be used directly within cells. By leveraging custom functions, you can perform complex calculations, manipulate data, and integrate external services directly from your spreadsheet. This … Read more
I. Introduction to Google Apps Script GAS is a powerful cloud-based scripting language that extends the functionality of Google Workspace applications like Sheets, Docs, Gmail, and Drive. It allows users to automate tasks, manipulate data, and build custom solutions within the Google Workspace ecosystem. Key Features: II. Bound vs. Standalone Scripts GAS offers two script … Read more
Google Apps Script is a powerful tool that allows users to automate tasks, extend Google Workspace apps, and integrate with external services. It’s a cloud-based scripting language, similar to JavaScript, designed to be accessible for both novice and experienced developers. In this post, we’ll explore the key functionalities and capabilities that make Google Apps Script … Read more
Short-Answer Quiz Instructions: Answer each question in 2-3 sentences. Short-Answer Quiz Answer Key Essay Questions Glossary of Key Terms TermDefinitionApps ScriptA cloud-based scripting language for extending the functionality of Google Workspace applications.Bound ScriptA script associated with a specific Google Workspace document (e.g., Google Sheet, Doc). It can access and manipulate the document’s data.Standalone ScriptAn independent … Read more
Formatting documents can be time-consuming, especially when you have a large Google Doc with numerous bolded paragraphs that need to be converted into specific headings. Fortunately, Google Apps Script allows you to automate this task with a few lines of code! This post will guide you through creating a Google Apps Script to find all … Read more
To remove blank paragraphs in a Google Document, you can use Google Apps Script to detect and delete paragraphs that contain no text or only whitespace characters. Here’s a simple script to accomplish this task: Step-by-Step Guide Script Code /** * Adds a custom menu to the Google Docs UI for easy access. */function onOpen() … Read more
When working with structured documents in Google Docs, you may find yourself needing to identify paragraphs that start with a number and a period (like “121.” or “15.”) and turn them into headings while removing the leading numbers. With Google Apps Script, you can automate this task, saving time and ensuring consistency across your document. … Read more
Adding a horizontal line with spacing above headings can make a document visually appealing and easier to navigate. This can be especially helpful in long Google Docs where distinct section dividers improve readability. Instead of adding these lines manually, you can automate the task using Google Apps Script! In this guide, we’ll walk through an … Read more
Blank lines in a document can clutter its appearance, making it look disorganized and harder to read. Manually going through a long document to remove these blank lines can be tedious, especially if you’re working with large or collaboratively edited files. Thankfully, Google Apps Script offers a quick solution to automatically detect and remove empty … Read more
When working on a collaborative document, it’s easy for different font sizes and styles to accumulate, especially if multiple people have been editing. If you’re looking to restore a consistent, clean appearance throughout your Google Doc, resetting all text to the default font size and style can help bring uniformity. Instead of manually changing the … Read more