Apps Script Code Examples

When working with structured documents in Google Docs, it’s common to start headings with a number and a period (e.g., “1. Introduction”). However, if you decide to remove these numbered prefixes from your H3 headings for a cleaner look, manually editing each heading can be time-consuming, especially in large documents. Thankfully, Google Apps Script offers … Read more

In Google Docs, using bold text is a common way to highlight key points or section titles. However, if you’re looking to standardize your document formatting by turning bolded lines into proper headings, this can be a tedious task to do manually. Fortunately, Google Apps Script can help! In this post, we’ll walk you through … Read more

When working with large Google Docs, you may need to remove specific phrases that occur as standalone lines. These could be placeholders, outdated notes, or boilerplate text that no longer applies. Manually deleting these lines can be a hassle, especially if they appear throughout the document. Luckily, Google Apps Script provides an easy way to … Read more

Introduction If you work with Google Docs frequently, you’ve probably encountered documents with list items that contain nothing but blank spaces. These empty list items can clutter your document, disrupt its flow, and detract from readability. Manually cleaning them up can be time-consuming, especially in large documents. Fortunately, Google Apps Script provides a quick solution … Read more

Introduction When dealing with text documents, especially in Google Docs, you might come across lines that follow a particular numbering format. For instance, in documents generated by automated tools or text imports, lines with just a number followed by a period (like “1.” or “2.”) can clutter up the content, making it harder to read … Read more

Formatting content in Google Docs can sometimes require manual adjustments that are both time-consuming and prone to errors, especially when working with large documents. One common formatting issue involves headings that start with unnecessary characters, such as colons, which can disrupt the visual flow and readability of your document. In this post, I’ll show you … Read more

Google Apps Script is a powerful tool that enables you to automate tasks and extend the functionality of Google Workspace apps, including Google Docs. In this blog post, we’ll explore a practical script that merges paragraphs into the preceding H3 headings and removes trailing colons from those headings. This can be especially useful for formatting … Read more

In this blog post, we will delve into a Google Apps Script function that calculates the cost per item, considering any applicable discounts. This script is especially useful for e-commerce platforms or any other scenarios where discounts and coupon codes are used to determine the final cost of products. We will explain the code in … Read more

Google Apps Script is a powerful tool that allows you to automate tasks and enhance your Google Sheets capabilities. In this blog post, we will demonstrate how to use Google Apps Script to calculate the total cost from a sample data table. This script can be especially useful for financial calculations, budgeting, or any scenario … Read more

In this blog post, we will explore how to use Google Apps Script to copy data from one Google Sheet to another. Specifically, we will copy five columns, excluding one column, and ensure that our destination sheet has an auto-incrementing number for the first column. Additionally, we will eliminate any duplicate rows in the process. … Read more