Apps Script Code Examples

If you’re working with Google Apps Script to automate tasks in Google Sheets, you may encounter issues that require debugging and improvements. In this blog post, we’ll analyze a given script, fix potential issues, and improve the overall functionality. Understanding the Code The script creates a custom menu in Google Sheets and provides various functions: … Read more

The getUi() context error in Google Apps Script occurs when you try to call getUi() outside of a valid UI context. Here’s why it happens and how to fix it. 🔴 Error Message Exception: Cannot call getUi() from this context. 🛠️ Why Does This Happen? ✅ Correct Ways to Use getUi() Solution 1: Ensure It’s … Read more

Here’s a Google Apps Script that scans a Google Docs document and bolds specific words (Objective, Code, and Explanation) when they appear on their own lines. Features: Google Apps Script: function boldSpecificWords() { var doc = DocumentApp.getActiveDocument(); var body = doc.getBody(); var paragraphs = body.getParagraphs(); var wordsToBold = [“Objective”, “Code”, “Explanation”]; paragraphs.forEach(paragraph => { var … Read more

Features: function resetHeadingSizes() { var doc = DocumentApp.getActiveDocument(); var body = doc.getBody(); var paragraphs = body.getParagraphs(); // Define default font sizes for headings var headingSizes = { [DocumentApp.ParagraphHeading.HEADING1]: 24, [DocumentApp.ParagraphHeading.HEADING2]: 20, [DocumentApp.ParagraphHeading.HEADING3]: 18, [DocumentApp.ParagraphHeading.HEADING4]: 16, [DocumentApp.ParagraphHeading.HEADING5]: 14, [DocumentApp.ParagraphHeading.HEADING6]: 12 }; // Iterate through paragraphs and reset heading sizes paragraphs.forEach(paragraph => { var heading = paragraph.getHeading(); … Read more

Here’s a Google Apps Script that converts all Heading 3 (H3) styles to Heading 2 (H2) in a Google Docs document. It loops through all the paragraphs and updates the heading styles accordingly. Steps to Use: Apps Script: function convertH3toH2() { var doc = DocumentApp.getActiveDocument(); var body = doc.getBody(); var paragraphs = body.getParagraphs(); for (var … Read more

Here’s a Google Apps Script that scans a Google Doc, finds all Heading 2 paragraphs, and adds sequential numbering before each heading. Apps Script Code function numberHeading2InDoc() { var doc = DocumentApp.getActiveDocument(); var body = doc.getBody(); var paragraphs = body.getParagraphs(); var count = 1; // Start numbering from 1 for (var i = 0; i … Read more

If you work with structured documents, you may encounter headings that are automatically numbered, such as: 📌 “207. Create a Dynamic Weather Widget” However, in many cases, you might want to remove the numbering while keeping the actual heading text intact. Instead of manually editing each heading, you can automate the process using Google Apps … Read more

Google Docs provides an easy way to format text using different heading styles. However, if you ever find yourself needing to convert all Heading 3 (H3) text into bolded text while maintaining readability, you can automate the process using Google Apps Script. In this blog post, we’ll walk through a simple script that scans a … Read more

When working with Google Docs, formatting inconsistencies can sometimes cause unnecessary indentations, making your document look uneven or misaligned. If you frequently deal with documents where paragraphs have unwanted indentations, manually adjusting each one can be a time-consuming task. Luckily, Google Apps Script allows us to automate this process and remove all paragraph indentations with … Read more

Google Docs is a fantastic tool for creating and editing documents, but sometimes formatting can get in the way. Have you ever found yourself with a document full of bullet points that you’d rather see as regular paragraphs? Whether you’re cleaning up notes or preparing a more formal document, automating this conversion can save you … Read more