Google Apps Script

Managing lengthy documents can be a daunting task, especially when sections like the Table of Contents (ToC) become cluttered or outdated. Whether you’re refining a report, preparing a manuscript, or updating a collaborative project, having the ability to automate the removal of specific sections can save you valuable time and effort. In this blog post, … Read more

Here is a Google Apps Script to convert a Google Doc to a PDF and save it to your Google Drive. The script accepts the document’s ID, converts it to a PDF, and saves the file in a specified folder. Script function convertDocToPdf() { const docId = “YOUR_DOCUMENT_ID”; // Replace with your Google Doc ID … Read more

This Google Apps Script demonstrates the power of automation in Google Workspace. Whether you’re managing files in Google Drive or cleaning up messy Google Docs, this script offers a simple yet effective solution. Here’s a Google Apps Script function that performs the following tasks on a Google Doc: Script: function formatDocumentSpacing() { const doc = … Read more

Google Apps Script is a powerful tool for automating tasks in Google Workspace. In this post, we’ll explore a script that integrates seamlessly with Google Sheets, helping you manage files in Google Drive and clean up Google Docs with ease. Features of the Script This script offers three main functionalities: How It Works 1. Adding … Read more

Steps to Implement: Code: function listFilesInFolder() { const folderId = “YOUR_FOLDER_ID”; // Replace with your Folder ID const folder = DriveApp.getFolderById(folderId); const files = folder.getFiles(); const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); // Clear existing content in the sheet sheet.clear(); // Add headers sheet.appendRow([“File Name”, “File ID”, “File Path”]); while (files.hasNext()) { const file = files.next(); const fileName … Read more

If you’ve ever found yourself manually converting single-item lists into headings in Google Docs, you’ll appreciate how much time automation can save. With Google Apps Script, you can create a script to identify single-item lists with specific font sizes, remove their list formatting, and convert them into regular headings. This post introduces a powerful function, … Read more

This script identifies specific words or phrases (e.g., Example:, Code Snippet:, Instructions:, Solution:) that constitute the entire paragraph or element in a Google Docs document and converts them to bold text. The Script function boldSpecificPhrases() { const doc = DocumentApp.getActiveDocument(); // Access the active Google Doc const body = doc.getBody(); // Get the document’s body … Read more

When working on documents such as quizzes, FAQs, or study guides, it’s common to have questions labeled with a specific format, like “Question 1”, “Question 2”, etc. Manually bolding these question labels can be tedious, especially in lengthy documents. But with Google Apps Script, you can automate this task effortlessly! In this post, we’ll create … Read more

When working on structured documents, especially educational materials or guides, it’s common to have sections labeled with examples (e.g., Example 1:, Example 2:). Formatting these sections manually as headings can be time-consuming. With Google Apps Script, you can automate this task! In this blog post, we’ll create a script to identify all elements starting with … Read more