How to Automatically Remove Number-Only Paragraphs from Google Docs Using Apps Script

by

Are you looking to clean up a Google Docs document by removing paragraphs that contain only numbers? Perhaps you’re dealing with a document that has excess numbering or placeholders that need clearing out. Google Apps Script provides a powerful way to automate this task directly within your document environment. Here’s a step-by-step guide on how to create and run a script to automatically remove number-only paragraphs from a Google Docs document.

Step 1: Open Your Google Docs Document

Start by opening the Google Docs document you want to edit. Make sure you have editing permissions for this document.

Step 2: Access the Apps Script Editor

To begin writing your script, access the Apps Script editor by clicking on Extensions in the menu bar, then select Apps Script. This will open a new tab where you can write and manage your scripts.

Step 3: Write the Script

Once in the Apps Script editor, you may see some default code or an empty script file. Replace whatever is there with the following script:

function removeNumberOnlyParagraphs() {
  var doc = DocumentApp.getActiveDocument();
  var body = doc.getBody();
  var paragraphs = body.getParagraphs();

  for (var i = paragraphs.length - 1; i >= 0; i--) {
    var text = paragraphs[i].getText();
    if (text.trim().match(/^\d+$/)) {
      paragraphs[i].removeFromParent();
    }
  }
}

Step 4: Save and Run the Script

After pasting the script, click the floppy disk icon or press Ctrl+S to save it. To run the script, click on the play button or select the function removeNumberOnlyParagraphs from the dropdown menu and then click the play button.

Understanding the Script

  • getActiveDocument(): This function fetches the currently open document.
  • getBody(): Retrieves the body of the document where your content is.
  • getParagraphs(): Generates a list of all paragraphs in the document.
  • Regular Expression (/^\d+$/): The script uses this regular expression to check if a paragraph contains only digits. It ensures that the entire content of a paragraph is numeric.
  • removeFromParent(): If a paragraph matches the condition (only numbers), this command removes it from the document.

Permissions and Authorizations

When you run the script for the first time, Google will prompt you to review permissions. You’ll need to authorize the script to interact with your Google Docs on your behalf.

Conclusion

Google Apps Script is an incredibly versatile tool that can simplify document management tasks. By automating the removal of number-only paragraphs, you can quickly clean up your documents and focus on the content that matters. Whether you’re preparing a document for publication or analyzing text data, this script can save you time and effort. Give it a try and see how it can improve your workflow!