Apps Script Code Examples

Google Apps Script to Automatically Update Heading Styles in Google Docs

by

Do you find yourself manually updating heading styles in your Google Docs to keep things consistent? If so, you’re not alone—and luckily, there’s a simple way to automate the process using Google Apps Script. In this tutorial, you’ll learn how to write a script that updates all Heading 4 elements to Heading 2, and then … Read more

Automatically Bold Questions in Google Docs Using Apps Script

by

In today’s fast-paced digital environment, automating routine formatting tasks can save you a lot of time. One common need is to highlight sentences that end with a question mark—especially when reviewing documents or preparing Q&A content. In this blog post, we’ll walk through how to create a Google Apps Script that scans through your Google … Read more

How to Update Heading 2 to Heading 1 in Google Docs Using Google Apps Script

by

Introduction Google Docs provides a robust set of formatting tools, but sometimes, you may need to make bulk changes to your document styles programmatically. Instead of manually changing each heading, you can automate the process using Google Apps Script. In this tutorial, we’ll walk through a simple Google Apps Script that updates all Heading 2 … Read more

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