Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
To remove indentation in paragraphs in a Google Doc using Apps Script, you can modify the paragraph attributes. Here’s a script to remove indentation from all paragraphs in the document: This script iterates through all paragraphs in the document and sets both the first line and start indentation to 0, effectively removing any indentation from … Read more
To create a Google Apps Script that updates all paragraphs styled as “Normal text” in a Google Doc to have a font size of 11 and not be bold, follow these instructions. This script will go through your Google Doc and apply these formatting changes to all paragraphs that are designated as “Normal text.” This … Read more
To create a Google Apps Script that changes paragraphs styled as Heading 3 (H3) to regular paragraphs in a Google Doc, unless they end with a question mark (in which case they are left as H3), you can follow these steps. This script uses Google Apps Script, a Javascript-based platform that lets you extend Google … Read more
To modify the previous Google Apps Script so that it selects paragraphs that start with a number followed by a period (indicating a numbered list item or similar structure) and then updates those paragraphs to use the Heading 3 style, follow these steps. This script will loop through all paragraphs in a Google Document, check … Read more
To create a Google Apps Script that updates the font size of <h3> elements in a Google Document to a larger size, you will need to follow these steps. The script will loop through the document, identify all <h3> styled paragraphs, and increase their font size. Here’s a basic script example that increases the font … Read more
OVER 150+ Exercises Getting started with Google Apps Script SHEETS Google Sheets stands as an incredibly versatile tool for individuals and organizations alike, offering far more than meets the eye at first glance. Whether you’re managing a small project or orchestrating complex data analysis, the capabilities of Google Sheets can significantly enhance productivity and data … Read more
To create a Google Apps Script that bolds the start of a paragraph if it starts with “code”, “explanation”, or “objective”, and only bolds the first word while leaving the remaining content intact, you can follow the steps below. This script will iterate through all the paragraphs in the document, check if they start with … Read more
Creating a Google Apps Script to process Google Docs documents in the manner you’ve described involves using the Google Docs API provided within Apps Script. The script will: Here’s a basic script that accomplishes this: To use this script: Please note, when running scripts that modify documents for the first time, Google will ask for … Read more
To create a Google Apps Script that processes each row in a Google Sheet, checking the last part of a string in a specific column, and if that last part is all numeric, splits it off and copies it to the next column, follow these steps. This script assumes you want to check and process … Read more
To create an Apps Script that removes blank rows in a Google Sheet, you can follow the steps below. This script will scan through the sheet for any rows that are entirely blank and remove them. Here’s a simple script to do that: That’s it! Now you have a script that can remove all blank … Read more