Apps Script Code Examples

Google Apps Script is a powerful tool that lets you automate tasks and enhance the functionality of your Google Sheets. In this post, we’ll walk you through how to create a script that filters data from a sheet named main and copies rows with non-empty values in columns A, B, and C into a new … Read more

When working on large Google Docs, organizing content systematically can be daunting, especially if you’re dealing with sections categorized under specific headings. This is where Google Apps Script comes to the rescue! In this blog post, we’ll explore a function, reorganizeDocByHeading2, that reorganizes the content of a Google Doc based on predefined categories under “Heading … Read more

Apps Script Code function countHeading4InDocument() { const DOCID = ‘YOUR_DOCUMENT_ID_HERE’; // Replace with your Document ID const doc = DocumentApp.openById(DOCID); const body = doc.getBody(); const paragraphs = body.getParagraphs(); let heading4Count = 0; // Iterate through all paragraphs for (let i = 0; i < paragraphs.length; i++) { const paragraph = paragraphs[i]; if (paragraph.getHeading() === DocumentApp.ParagraphHeading.HEADING4) … Read more

Apps Script Code function addBlankLineAndBoldExplanation() { const DOCID = ‘YOUR_DOCUMENT_ID_HERE’; // Replace with your Document ID const doc = DocumentApp.openById(DOCID); const body = doc.getBody(); const paragraphs = body.getParagraphs(); // Iterate through all paragraphs in the document for (let i = 0; i < paragraphs.length; i++) { const paragraph = paragraphs[i]; const text = paragraph.getText().trim(); // … Read more

Apps Script Code function addHorizontalLineAboveHeading4() { const DOCID = ‘YOUR_DOCUMENT_ID_HERE’; // Replace with your Document ID const doc = DocumentApp.openById(DOCID); const body = doc.getBody(); const paragraphs = body.getParagraphs(); // Iterate through the paragraphs in reverse order for (let i = paragraphs.length – 1; i >= 0; i–) { const paragraph = paragraphs[i]; // Check if … Read more

Organizing a Google Doc can often involve repetitive tasks like updating headings or restructuring content. One such common task is converting specific headings to a different style while modifying their text content. In this blog post, we’ll explore a handy Google Apps Script that automatically updates Heading 3 elements to Heading 2, transforms their text … Read more

Managing content in a Google Doc can be tedious, especially when dealing with repetitive headings and disorganized structure. If you’ve ever faced the challenge of consolidating duplicate categories while retaining their content, this blog post is for you. We’ll explore a simple Google Apps Script that automates this task, ensuring your document stays clean, organized, … Read more

Google Docs is an excellent tool for creating and managing documents, but sometimes the formatting can get messy, especially when headings have inconsistent styles. Whether it’s due to manual adjustments or imported content, fixing heading styles manually can be tedious. Fortunately, Google Apps Script provides a simple solution to reset all headings in a document … Read more

If you work extensively with Google Docs, you’ve probably found yourself needing to clean up headings or rearrange content. Repetitive tasks like updating headings or removing redundant lines can consume valuable time. Thankfully, Google Apps Script provides a powerful way to automate such tasks. In this post, we’ll walk through a Google Apps Script function … Read more