Apps Script Code Examples

Create doc move to specific folder

by

Below is a Google Apps Script that creates a new Google Document and moves it to a specific folder in Google Drive. This script assumes that you already have the folder’s ID where you want to place the new document. After the script runs, it will create a new Google Document and move it to … Read more

Make a copy of an existing document copy the complete documen including the header footer and style

by

To copy an entire Google Document including headers, footers, and styles directly, you don’t need to individually replicate each element’s content as I previously described. Instead, you can use Google Drive’s copy function for a more straightforward approach. This function automatically copies all content, maintaining the original formatting, headers, and footers. Here’s how you can … Read more

Apps script to remove duplciate rows from a sheet

by

Below is a simple Google Apps Script that you can use to remove duplicate rows from a Google Sheet. This script assumes that your data starts in the first row and column of the sheet and that rows are considered duplicates if every cell in the row matches another row. To use this script, follow … Read more

Apps script for docs that clears font size for all paragraphs resets to the default keeps the bold and other styling

by

To create a Google Apps Script for Google Docs that clears the font size of all paragraphs and resets them to the default size while retaining other formatting such as bold, italics, etc., you can use the following script: This script iterates through all paragraphs in the document, resets their font size to the default … Read more

Find and update H3 Paragraphs using Apps Script

by

UpdateH3Paragraphs In today’s digital age, the efficiency and automation of document formatting can significantly enhance productivity. Google Docs users, in particular, can benefit from Google Apps Script, a powerful tool designed to extend the functionality of Google Workspace, including Docs, Sheets, and Forms. In this blog post, we’ll delve into a specific use case: a … Read more

Apps script that removes indents at the start of a paragraph in docs

by

To create a Google Apps Script that removes indents at the start of each paragraph in a Google Document, follow these instructions: After you run this script, it will iterate through all the paragraphs in your document and remove any indents at the beginning of them. This is particularly useful for ensuring consistency across your … Read more

Automating Google Docs: Splitting Headings for Better Structure

by

apps script for a doc that will select h3 paragraphs, if they contain a colon split the content at the first colon, keep the first part as h3 move the second part of the string to a new paragraph following the first one To create a Google Apps Script that processes paragraphs in a Google … Read more

Apps script for docs to check if the paragraph ends with a question mark if it does convert it to an h3

by

To create a Google Apps Script that checks if a paragraph in a Google Document ends with a question mark and if so, converts it to a heading 3, follow these steps: This script will iterate through all paragraphs in your document, check if they end with a question mark, and if they do, the … Read more

Apps script to select h3 paragraphs in docs that start with a number and convert them to bolded text

by

To create a Google Apps Script that selects H3 paragraphs in a Google Document which start with a number and then converts them to bold text, you can use the following script: To use this script, follow these steps: This script will scan through all the paragraphs in your document, and if it finds any … Read more

Streamline Your Email Outreach with Google Sheets and Apps Script

by

In today’s fast-paced digital world, effective communication is key to success. Whether you’re a business owner, marketer, or freelancer, reaching out to contacts via email is a common task. However, crafting personalized emails for each recipient can be time-consuming and laborious. But fear not! In this post, I’ll introduce you to a simple yet powerful … Read more