Apps Script Code Examples

Bold words in your Doc using Google Apps Script

by

Creating an Apps Script to search a Google Document for elements (like text) that start with a particular word or set of words and then updating those words to be bold requires using Google Apps Script’s Document service. Here’s a step-by-step guide to creating such a script: This script only applies to text elements and … Read more

Google Apps Script to reset all fonts to normal within Workspace Docs

by

You can create a Google Apps Script to reset all normal text (including list items) to the default font size in a Google Docs document. Here’s a script that does that: Here’s how to use this script: This script will set the font size of all normal text (excluding headers and titles) and list items … Read more

Google Apps Script to create a custom function that cleans and formats text in a Google Docs document

by

Here’s a basic example that removes extra spaces and trims the text: To use this script: This script will clean the text by removing extra spaces and trimming leading and trailing spaces. You can modify the cleanText function to include other text cleaning operations as needed. Remember to save and run the script whenever you … Read more

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