Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script
https://gdg.community.dev/events/details/google-gdg-cloud-edmonton-presents-devfest-edmonton-2024-1 I wanted to take a moment to express my deepest gratitude to the organizers of GDG Cloud Edmonton for giving me the opportunity to speak at DevFest 2024 on November 22nd. It was truly an honor to present “Power Up with Apps Script & Gemini AI” to such an enthusiastic and engaged audience. DevFest … Read more
Are you looking for a way to dynamically list files from a Google Drive folder, complete with file names, sizes, and links, that you can easily share on a website or embed in an HTML page? With Google Apps Script, you can achieve this efficiently. This blog post introduces a script function, listFilesInFolder(folderId), that generates … Read more
Why Update the Document Title? When translating a document, it’s easy to overlook the title. Updating the title ensures that the entire document, including its metadata, is fully translated, giving your audience a clear understanding of its purpose. It also improves organization and retrieval when searching through Google Drive. The Code to Update the Document … Read more
If you’ve ever faced the challenge of translating a Google Doc, you know it can be tedious to copy-paste content into a translation tool. Luckily, Google Apps Script offers a seamless way to integrate translation right into your Google Docs. In this post, we’ll explore how to create a custom Google Apps Script function that … Read more
Google Apps Script for Google Workspace: Comprehensive Guide Google Apps Script enables you to automate and extend Google Workspace apps such as Gmail, Sheets, Docs, Slides, Forms, Calendar, and Drive. This guide covers the fundamentals, practical examples, exercises, and quiz questions to master Google Workspace automation. What is Google Apps Script for Google Workspace? Google … Read more
Google Apps Script for Google Forms: Comprehensive Guide Google Apps Script for Forms enables you to automate and customize Google Forms by creating forms programmatically, managing responses, and integrating them with other Google Workspace apps. This guide includes examples, detailed explanations, exercises, and multiple-choice questions to help you master Google Forms automation. What is Google … Read more
Removes both multi-paragraph and single-paragraph language-specific text patterns from a specified Google Document In the ever-evolving landscape of content creation, efficiency is paramount. Whether you’re a developer documenting your code, a blogger crafting tutorials, or a student compiling research, managing and formatting content within Google Docs can sometimes become a tedious task. One common challenge … Read more
1. Understanding the Current Behavior If the current project relies on the absence of a date to determine whether a certificate should be sent, this logic works but may not be explicitly clear to the user. Adding a more deliberate mechanism like a “Processing Flag” column provides better control and transparency. 2. Adding a Flag … Read more
Script that displays a pop-up message if the user selects more than one cell at a time and tries to insert the date. This will help ensure users follow the intended workflow. Step-by-Step Guide 1. Set Up the Script function onEdit(e) { // Get the active spreadsheet and range const range = e.range; const sheet … Read more
Google Apps Script allows you to interact with external web services and APIs, enabling you to integrate your scripts with a wide range of online platforms and services. This chapter introduces RESTful APIs and demonstrates how to consume and interact with them using Google Apps Script. What Are RESTful APIs? Key Concepts Making HTTP Requests … Read more