Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
If you’re just getting started with Google Apps Script, don’t worry—each function is explained clearly, with details on how to use it in your Google Sheets to make your life easier. So, let’s dive into it! How to Add These Custom Formulas If you missed the steps on how to add custom formulas to your … Read more
Why Use Custom Formulas in Google Sheets? Google Sheets already comes packed with tons of functions, but there are times when you need something more specialized. Custom formulas allow you to simplify calculations, automate repetitive tasks, and introduce unique functionality into your spreadsheets. The best part is that creating these custom functions is easier than … Read more
Editing text in Google Docs can sometimes become repetitive and time-consuming, especially when you need to apply specific formatting to certain elements throughout the entire document. Luckily, Google Apps Script allows you to automate many tasks, saving you valuable time and ensuring consistency. Today, we’ll look at a script that does just that: it automatically … Read more
If you’ve ever had to manually edit paragraphs in a Google Doc, you know it can be a tedious task. For example, imagine working through a document where you must find every paragraph starting with “// Exercise X:” and convert them into proper headings. Not only is this repetitive, but it’s also easy to make … 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