Google Apps Script

Google Apps Script

Google Apps Script that locks the first row as a heading

by

Script: function lockFirstRowAsHeading() { // Open the active spreadsheet var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); // Check if the first row is already frozen if (sheet.getFrozenRows() !== 1) { // Freeze the first row sheet.setFrozenRows(1); } // Notify the user SpreadsheetApp.getUi().alert(“The first row has been locked as a heading.”);} How It Works: Steps to Use: Result: The … Read more

Creating a Filtered Sheet in Google Sheets with Google Apps Script

by

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

London Ontario 2025 Summary of the Presentation: Unleashing the Power of Google Apps Script and Gemini

by

Meet me at https://gdg.community.dev/events/details/google-gdg-london-presents-google-devfest-2024-london-on-ca/ Devfest in London Jan 25, 11:00 AM – 3:00 PM (EST) Western University, 1151 Richmond St, London, N6A 3K7 This presentation by Laurence Svekis explores the integration of Google Apps Script and Gemini AI to streamline workflows, enhance automation, and unlock new possibilities in Google Workspace. It provides an overview of Apps Script as a … Read more

Organizing Your Google Docs with Apps Script: A Guide to Sorting Sections by Headings

by

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 that counts the number of Heading 4 elements in a Google Doc

by

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 that adds a blank line above every occurrence of the word

by

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 that adds a horizontal line above each Heading 4

by

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

Automating Document Formatting: Convert and Update Heading 3 to Heading 2 in Google Docs

by

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

Automating Document Cleanup: Consolidate Duplicate Categories in Google Docs with Apps Script

by

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

Resetting Google Docs Heading Styles with Google Apps Script

by

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