Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
Keyboard Shortcuts for Google Apps Script Editor Google Apps Script is a powerful tool for automating tasks across Google Suite products, including Google Sheets, Docs, and Forms. To enhance your coding efficiency in the Apps Script Editor, mastering a set of keyboard shortcuts is essential. In this post, we’ll cover some of the most useful … Read more
Explore the Latest Google Apps Script Code Snippets on GitHub Check out my new code snuippets for apps script on GitHub https://github.com/lsvekis/Apps-Script-Code-Snippets/tree/main oogle Apps Script (GAS) continues to be a powerful tool for automating and enhancing Google Workspace applications. Recently, a series of exciting new GAS projects have been added to GitHub by user lsvekis. … Read more
Email communication often requires sending multiple documents or files at once. Whether you’re sending weekly reports, project documents, or promotional materials, attaching multiple files to an email can significantly enhance your communication. Google Apps Script provides a straightforward way to automate sending emails with multiple attachments from Google Drive or any other accessible online storage. … Read more
Managing a large volume of hyperlinks in Google Sheets can become cumbersome, especially if these links frequently need updates based on external data. Google Apps Script provides a versatile solution with its UrlFetchApp service, which can be used to fetch real-time data and dynamically update links in your sheets. This tutorial will guide you through … Read more
Sending personalized and visually appealing emails can be a tedious task, especially when dealing with a large list of recipients. Google Apps Script provides a powerful and flexible way to automate this process, using data from Google Sheets to send customized, styled emails to a list of recipients. This blog post will guide you through … Read more
Keeping track of events in Google Calendar is straightforward, but sometimes specific queries like checking for all-day events on a particular date require a bit more finesse. Google Apps Script offers a powerful way to interact with your Google Calendar programmatically. This post will walk you through creating a script to check for all-day events … Read more
Managing presentations can often require updating content frequently to keep up with new information or changes. Google Apps Script provides a powerful way to automate updates in Google Slides. This blog post will show you how to programmatically select specific slides and text boxes within them, and update their contents. What You’ll Need Step 1: … Read more
Creating presentations from lengthy documents can be a tedious task, especially when you need to transfer key points and sections manually. This blog post will guide you through automating the process using Google Apps Script, enabling you to convert sections of a Google Docs document into a series of slides on a Google Slides presentation. … Read more
Automatically Add Google Form Responses to Google Calendar with Google Apps Script Integrating Google Forms with Google Calendar can streamline various tasks such as scheduling appointments, booking events, or organizing meetings directly from form submissions. In this tutorial, we will guide you through creating a simple Google Apps Script that automatically adds events to your … Read more
Laurence Svekis at “Build with AI” GDG Surrey Event Harnessing the Power of Google Apps Script Recently, the “Build with AI” event hosted by Google Developer Groups (GDG) Surrey at the British Columbia Institute of Technology brought together developers and AI enthusiasts to delve into the latest in Generative AI technologies and applications. Among the … Read more