Apps Script Code Examples

How to Remove or Override the Class in Google Docs HTML Export Using Apps Script

by

When working with Google Apps Script to extract and display Google Docs content in a web app, you might encounter a scenario where the <body> element in the exported HTML contains unwanted class attributes. These classes can affect styling and cause inconsistencies when rendering the content on your website. In this blog post, we’ll walk … Read more

Fixing and Understanding Google Apps Script Code: A Detailed Breakdown

by

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

Apps Script Get UI

by

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

Google Docs document and bolds specific words

by

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

Google Apps Script project for automating formatting in Google Docs

by

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

Google Apps Script that converts all Heading 3 styles to Heading 2 in a Google Docs document

by

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

Automation of numbering Heading 2 titles using Google Apps Script in Google Docs

by

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

Automate Google Docs: Remove Numbering from Heading 2 Using Apps Script

by

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

Automate Google Docs: Convert H3 Headings to Bold Text Using Apps Script

by

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

Remove Paragraph Indentations in Google Docs Using Apps Script

by

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