Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script for Gmail: Comprehensive Guide Google Apps Script allows you to automate Gmail tasks such as sending emails, managing labels, and searching messages. This guide provides step-by-step instructions, code examples, and exercises for mastering Gmail automation with Apps Script. What is Google Apps Script for Gmail? Google Apps Script provides access to Gmail … Read more
Introduction: Have you ever encountered a Google Docs document cluttered with empty or blank lines? These unnecessary spaces can make your document look unprofessional and harder to read. Thankfully, with the power of Google Apps Script, you can automate the process of identifying and removing all empty or blank lines in your document. In this … Read more
How It Works: How to Use: This script will reset all font styles in the document to default values. Let me know if you’d like any additional features!
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 Sheets Custom Formulas: Comprehensive Guide Custom formulas in Google Sheets are created using Google Apps Script, which allows you to build powerful, reusable functions for advanced spreadsheet operations. This guide explains how to create, use, and troubleshoot custom formulas in Google Sheets, with detailed examples, exercises, and quiz questions. What are Custom Formulas? Custom … Read more
Google Apps Script Web Apps: Comprehensive Guide Google Apps Script allows you to create web apps to interact with users via a browser interface. This guide covers creating, deploying, and managing web apps using Google Apps Script, with examples, exercises, and multiple-choice questions. What is a Google Apps Script Web App? A web app built … 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
