Apps Script Code Examples

Read and log data from the first cell in a Google Sheets spreadsheet

by

Objective: Read and log data from the first cell in a Google Sheets spreadsheet. Code: function readSpreadsheetData() {   const ss = SpreadsheetApp.getActiveSpreadsheet()   const sheet = ss.getSheetByName(‘Sheet1’);   const range = sheet.getRange(‘A1’);   const value = range.getValue();   Logger.log(value); } Instructions: Explanation: This script gets the active sheet of the current spreadsheet, accesses cell A1, reads its value, and … Read more

50 Exercises 55 Quiz Questions Getting started with Google Apps Script

by

Check out our comprehensive guide on “Getting Started with Google Apps Script If you’re looking to level up your Google Apps Script skills, this guide is a must-read. It covers 50 Exercises and 55 Quiz Questions to help you become a scripting pro. 🤓 🔥 Here are some key objectives covered in the guide: #GoogleAppsScript … Read more

Update Docs page elements update finding a H3 and combine it with the next paragraph

by

Here’s a breakdown of how the code works: In summary, this script is designed to find Heading 3 paragraphs in the document, take the content of the next paragraph, and replace the content of the Heading 3 paragraph with it, effectively merging the two paragraphs while removing the original next paragraph.

Adjust line indentation with apps script in Docs

by

To adjust the indentation of list items properly in a Google Document using Apps Script, it’s essential to use the correct properties and methods. Unfortunately, the setIndentStart and setIndentFirstLine methods I mentioned earlier do not exist in the Google Apps Script Document service. For list items, you can adjust the indentation level via the setGlyphType … Read more

Format List items with Apps Script

by

Google Apps Script that finds list items in a Google Document, resets their formatting to mimic “Normal” text style while maintaining them as list items (but without bullet or numbering formatting), and ensures they are properly indented, you can follow these steps. Since Google Docs inherently treats list items differently from normal text, direct conversion … Read more

Google Apps Script that updates the format of list items in a Google Document to the default format

by

Google Apps Script that updates the format of list items in a Google Document to the default format, you can use the following approach. This script will iterate through all elements in the document, identify list items, and apply default formatting to them. “Default formatting” can vary based on your requirements, but for the sake … Read more

Apps Script to remove bullet format from Doc

by

Google Apps Script to remove bullet formatting from list items in a Google Document, you need to modify the script to not only reset the formatting of the list items but also to convert them into regular text paragraphs. Here’s how you can adjust the previously provided script: This script goes through each element in … Read more

Apps script for docs that updates all heading1 text to normal text

by

To create a Google Apps Script that updates all text styled as Heading 1 to Normal text in a Google Document, follow these steps. This script will iterate through all the elements in the document, check if they are styled as Heading 1, and if so, change their style to Normal text. This script will … Read more

Bold words in your Doc using Google Apps Script

by

Creating an Apps Script to search a Google Document for elements (like text) that start with a particular word or set of words and then updating those words to be bold requires using Google Apps Script’s Document service. Here’s a step-by-step guide to creating such a script: This script only applies to text elements and … Read more

Google Apps Script to reset all fonts to normal within Workspace Docs

by

You can create a Google Apps Script to reset all normal text (including list items) to the default font size in a Google Docs document. Here’s a script that does that: Here’s how to use this script: This script will set the font size of all normal text (excluding headers and titles) and list items … Read more