Apps Script Code Examples

Comprehensive Guide to Google Apps Script for Google Sheets

by

Welcome to this in-depth guide on Google Apps Script for Google Sheets. Whether you’re a beginner or looking to enhance your spreadsheet automation skills, this guide is designed to help you master Google Apps Script in the context of Google Sheets. We’ll cover everything from setting up your environment to building complex scripts, complete with … Read more

Streamlining Your Google Docs: Automatically Removing the “Table of Contents” Section with Google Apps Script

by

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

Convert Doc to PDF

by

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

Apps Script that Cleans doc add spacing above each heading

by

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

Streamline Your Workflow with Google Apps Script: Managing Files and Cleaning Docs Effortlessly

by

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

Google Apps Script that selects all files in a specified Google Drive folder and lists their details

by

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

Google Apps Script that will split your Google Doc into separate documents based on Heading 1

by

Below is a Google Apps Script that will split your Google Doc into separate documents based on Heading 1 (H1) tags, using the H1 text as the new document titles. The new documents will be saved in a folder within your Google Drive. Script Code: function splitDocByHeading() { var doc = DocumentApp.getActiveDocument(); var body = … Read more

Automate Formatting in Google Docs with Google Apps Script

by

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

Script to Bold Specific Words and Phrases in Google Docs

by

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

Automate Text Styling in Google Docs: Bold Questions with Google Apps Script

by

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