Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
Learn how to automate repetitive tasks and complex workflows using Google Apps Script triggers. This chapter discusses different types of triggers, such as time-driven and event-based triggers, and shows you how to set them up to automate tasks like sending emails, updating sheets, and processing data at scheduled intervals. Automating workflows with script triggers can … Read more
No function is perfect on the first try. This chapter guides you through the debugging process and teaches you how to optimize your Google Apps Script functions for performance and efficiency. Learn best practices for testing and refining your functions to ensure they run smoothly. Writing custom functions in Google Apps Script is a powerful … Read more
Book Source Code on GitHub https://github.com/lsvekis/Sheets-Custom-Formulas-Book Get the Best Selling Book Free for the next 4 days US https://www.amazon.com/dp/B0D59Q4J1T CAN https://www.amazon.ca/dp/B0D59Q4J1T 1 : Mastering Basic Custom Functions In this opening chapter, we introduce the foundational concepts of Google Apps Script for custom functions in Google Sheets. Begin by learning how to create simple functions that … Read more
If you’ve adjusted the font size of your H1 headings in Google Docs and want to reset them back to the default size, Google Apps Script offers a simple solution to automate this process. In this blog post, we’ll guide you through creating a script to reset the font size of all H1 headings to … Read more
If you’re looking to enhance the formatting of your Google Docs by adding a space and a horizontal line above all H1 headings, you’re in the right place! In this tutorial, we’ll walk you through creating a Google Apps Script to automate this task. Step-by-Step Guide How the Script Works This script iterates through all … Read more
How to Remove All Blank Lines from a Google Doc Using Google Apps Script Google Docs is a versatile tool, but sometimes it requires a bit of customization to fit your needs perfectly. If you’ve ever faced the tedious task of removing all blank lines from a lengthy document, you’re in luck. With Google Apps … Read more
In today’s blog post, we’ll explore a useful Google Apps Script function that helps automate a common task: resizing and centering images in a Google Doc. This script ensures that all images are resized to 75% of the page width and are centered for a cleaner, more professional look. The Script Below is the complete … Read more
In this blog post, we will explore how to fix and improve a function written in Google Apps Script that removes blank lines from a Google Docs document. This can be particularly useful for cleaning up documents with unnecessary blank lines. Original Function Here is the original removeBlankLines function: function removeBlankLines(docId) { try { var … Read more
📢 FREE Kindle Promotion Alert! Get your copy of “Coding with Google Apps Script: A Step-by-Step Journey” absolutely FREE until May 22, 2024! US https://www.amazon.com/dp/B0D3TZXG39 CAN https://www.amazon.ca/dp/B0D3TZXG39 “Coding with Google Apps Script: A Step-by-Step Journey”, authored by Laurence Lars Svekis, serves as a comprehensive guide for anyone keen on mastering Google Apps Script (GAS) through … Read more
