Code Snippet

Google Apps Script that removes the starting numbers from any H3 paragraph

by

What this script does: Remember, every time you want to remove numbers from H3 headings, you have to manually run the script from the Extensions > Macros menu.

Test function with Apps Script for ChatGPT

by

Creating a test function for your Google Apps Script code involves simulating responses from the external API and the Google services without actually making requests or creating documents. This is because Google Apps Script does not support traditional unit testing frameworks or libraries directly. However, you can structure your code to simulate parts of it … Read more

copy header content and footer in doc to new doc

by

Streamline Your Documentation Process with Google Apps Script Automation In the fast-paced world of business and technology, efficiency is key. That’s where the power of automation comes into play, especially when dealing with documentation and content management. Today, I’m thrilled to share a revolutionary Google Apps Script that’s set to change how you manage your … Read more

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