Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script is a powerful tool that allows you to automate tasks across Google Workspace applications. In this blog post, we’ll walk through how to use Apps Script to update a specific paragraph in a Google Doc that contains only the words “Multiple Choice Questions” and change its formatting to an H4 heading. Step-by-Step … Read more
Printing documents programmatically can be very useful in automating workflows, especially when dealing with repetitive tasks. Google Apps Script provides a way to print documents from Google Docs, either as a whole or selectively. In this blog post, I’ll guide you through creating a Google Apps Script that prints an entire document or specific parts … Read more
Connecting data from an Excel sheet to a Google Sheet can streamline your workflow, especially if you are transitioning from Microsoft Excel to Google Sheets. Google Apps Script provides a powerful way to automate this process. In this blog post, I’ll guide you through the steps to connect data from an Excel sheet to a … Read more
In this blog post, I’ll show you how to send an HTML email using Google Apps Script and an HTML file as the source. This is a powerful way to enhance your emails with custom styles and layouts. Prerequisites Before we start, ensure you have: Step-by-Step Guide Step 1: Create an HTML file First, you … Read more
Integrating with Other Google Services Finally, explore how Google Apps Script interacts with other Google services like Drive, Calendar, and Google Forms. This chapter provides practical examples of scripts that integrate multiple services, enhancing the functionality of your Sheets by connecting them with the broader ecosystem of Google applications. Google Apps Script is not limited … Read more
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
Enhance the usability of your Google Sheets by adding custom menus and user interface components. This chapter guides you through the process of designing and implementing custom menus, dialog boxes, and other UI elements that make your scripts user-friendly and accessible to a broader audience. Enhancing the usability of your Google Sheets by adding custom … 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
