Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
In today’s fast-paced digital world, effective communication is key to success. Whether you’re a business owner, marketer, or freelancer, reaching out to contacts via email is a common task. However, crafting personalized emails for each recipient can be time-consuming and laborious. But fear not! In this post, I’ll introduce you to a simple yet powerful … 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
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
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
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