Apps Script Code Examples

Automating Document Formatting: Reset Font Sizes in Google Docs with Apps Script

by

Creating an Apps Script to reset font sizes to default for headings and paragraphs in a Google Doc involves iterating through the elements of the document and changing their font size based on their type. Below is a basic script that does this. Note that Google Docs does not have a single “default font size” … Read more

100 Plus Google Apps Script Exercises Code Examples PDF guide more than 130 pages FREE

by

100+ Exercises  Google Apps Script Exercises Explore what you can do with Google Apps Script in Workspace.   Useful Code examples to get your started with Google Apps Script Log a Custom Message Purpose: Learn how to log a message in Apps Script. function logMessage() { Logger.log(‘Hello, Google Apps Script!’); } Explanation: This script uses the … Read more

How to remove multiple lines that contain text using Google Apps Script Doc clean up

by

provided code in detail. It consists of two functions: removeMultipleSpecificLines and removeBlankLines. These functions are designed to manipulate the content of a Google Docs document. removeMultipleSpecificLines() Explanation: removeBlankLines() Explanation: This function is similar to the previous one but is specifically designed to remove blank lines (paragraphs with no content) from the document. These two functions … Read more

Remove numbers at the start of a heading or any page element in Google Docs Google Apps Script Code

by

You can create a Google Apps Script to remove the first numbers up to the first period in Google Docs from all page elements if the element begins with a number. Here’s a sample script that you can use: Here’s how to use the script: The script will go through all the text elements in … Read more

Add a Horizontal Rule above each element that starts with a certain word in Google Docs using Apps Script

by

Creating an Apps Script to add a horizontal rule above each element that begins with the word “Question” in a Google Docs document involves searching the document for paragraphs starting with “Question” and then inserting a horizontal rule above those paragraphs. Here’s how you can do it: Here’s the Apps Script: This script iterates through … Read more

Remove blank lines in your Google Doc with Apps Script

by

To create an Apps Script that removes blank lines from a Google Docs document, you can follow these steps. This script will go through the document, identify any paragraphs that consist only of whitespace or are completely empty, and remove them. Here’s the Apps Script: This script retrieves all the paragraphs in the document and … Read more

Remove header or other styling from an element that begins with a certain word Google Apps Script Code Snippet

by

To create a Google Apps Script that removes a heading in a Google Docs document if an element (paragraph) starts with a specific word from an array of words, follow these steps: This script iterates through all paragraphs in your document, checks if the first word of a paragraph matches any word in the triggerWords … Read more

Google Apps Script that bolds elements in a Google Docs document that begin with any word

by

To create a Google Apps Script that bolds elements in a Google Docs document that begin with any word from a given array of words, follow these steps: This script searches your document for each word in the searchWords array. When it finds an occurrence of any word, it applies bold formatting to that word. … Read more

Google Apps Script that removes a number from a page element with specific identifiers

by

To create a Google Apps Script that removes a number located directly after the word “Question” and before a colon (“:”) in a Google Docs document, follow these steps: function removeQuestionNumber() {var body = DocumentApp.getActiveDocument().getBody();var text = body.getText();var paragraphs = body.getParagraphs(); for (var i = 0; i < paragraphs.length; i++) {var paragraphText = paragraphs[i].getText();// Check … Read more

Apps Script Remove Blank Lines from Docs Document

by

Creating a Google Apps Script to remove blank lines from a Google Docs document is a great way to clean up and streamline your document. Here’s how you can write a script for this purpose: Here’s an example script: This script iterates through all paragraphs in the document in reverse order (to avoid indexing issues … Read more