Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
To create a Google Apps Script for Google Sheets that processes a range of cells by taking each cell’s string value, separates it by the first comma found in the string, and then pastes the remaining part of the string into the following column, follow these steps. This script will iterate over a specified range, … Read more
To create a Google Apps Script that takes the value of a cell in Google Sheets, and separates the last two items in the string by a space, moving them to new columns in the same row, follow these steps. This script will loop through a specified range in your sheet, split the content of … Read more
Google Apps Script Multiple Choice Quiz 🚀 Unlock the Power of Google Apps Script with Our Comprehensive Guide! 🚀 Mastering Google Apps Script: A Comprehensive Guide Are you ready to unlock the full potential of Google Apps Script and revolutionize your workflow within Google Workspace? Look no further! In this comprehensive guide, we’ll dive deep … Read more
Title: Automatically Convert Questions to H3 Headings in Google Docs Have you ever found yourself writing a lengthy document in Google Docs, only to realize later that you need to format questions differently to make them stand out? If so, you’ll appreciate this handy Google Apps Script function called convertQuestionToH3(). In this post, we’ll dive … Read more
You can create a Google Apps Script for Google Docs that converts any text element ending with a question mark to an H3 element. Here’s a basic example of how you can achieve this: Here’s how you can set up and use this script: This script will iterate through all paragraphs in the document and … Read more
Mastering Google Drive Organization: List All Files and Folders with Google Apps Script Organizing your digital files is a critical component of personal and professional efficiency. Google Drive users, in particular, can accumulate a vast array of files and folders over time, making it challenging to keep track of everything. Fortunately, Google Apps Script provides … Read more
In today’s digital age, managing files and folders efficiently is crucial for productivity. Google Drive, being one of the most widely used cloud storage services, offers a vast array of features for file management. However, navigating through a plethora of files and folders can sometimes be daunting. This is where Google Apps Script comes into … Read more
Automating Inventory Management with Google Apps Script In the fast-paced world of business, inventory management is a critical task that can significantly impact operations. Efficient inventory management ensures that businesses can meet demand without overstocking, thus saving costs and optimizing space. Today, we introduce a Google Apps Script that automates inventory restocking alerts and reporting, … Read more
How To update all the bullet list items in a Google Doc to use the HOLLOW_BULLET glyph type. This script will iterate over every list item in the document and change its glyph type to HOLLOW_BULLET if it is a bullet list item. This operation directly affects the appearance of list items in the document. … Read more
Google Docs, Google Apps Script is commonly used to automate and extend its capabilities, making document creation, collaboration, and management more efficient. Here are the top 10 common Google Apps Script uses specifically tailored for Google Docs: 1. Automated Document Generation function createDocumentFromTemplate() { var templateId = ‘TEMPLATE_DOCUMENT_ID_HERE’; var documentId = DriveApp.getFileById(templateId).makeCopy().getId(); var doc = … Read more