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 and extend the functionality of Google Apps. In this blog post, we will explore how to create a Table of Contents (TOC) in a Google Docs document using Google Apps Script. This is particularly useful if you have a lengthy document with … Read more
We will explore how to create a Google Apps Script that lists all the image files in a specific Google Drive folder, converts them to Base64, and writes their details (name, URL, MIME type, and a generated description) into a Google Sheets spreadsheet. We will use the Google Gemini Pro Vision API to generate detailed … Read more
Creating dynamic and interactive email templates with Google Apps Script can significantly enhance your customer interaction and streamline your workflow. In this blog post, we’ll walk you through how to create email templates with buttons that interact with your Google Sheet or send customized responses directly to your customers. Step 1: Set Up Your Google … Read more
Creating a contact list using Google Apps Script is a practical way to manage contacts efficiently within Google Sheets. This blog post will guide you through the steps to set up a contact list, write the necessary script, and understand each part of the code. Step 1: Set Up Your Google Sheet First, create a … Read more
steps to retrieve all existing results from a Google Sheet and display them back into a web app using an HTML table. Google Apps Script makes it easy to connect your Google Sheets data with a custom web interface. Step 1: Set Up Your Google Sheet First, make sure you have a Google Sheet with … Read more
Automating Line Removal in Google Docs using Google Apps Script Google Apps Script offers an excellent way to automate tasks in Google Docs, making document management more efficient. One practical application is removing specific lines within paragraphs that contain certain phrases. In this blog post, we’ll walk through creating a script to remove lines containing … Read more
Removing Specific Paragraphs in Google Docs using Google Apps Script Google Apps Script provides a powerful way to automate and enhance the functionality of Google Docs. One common task you might encounter is the need to remove specific paragraphs that contain only certain phrases or single words. In this blog post, we’ll walk through how … Read more
Maintaining a consistent heading structure in your Google Docs is crucial for readability and organization, especially in lengthy documents. If you find yourself needing to change all H3 headings to H2 headings, doing it manually can be tedious and time-consuming. Luckily, Google Apps Script allows you to automate this process. In this blog post, we’ll … Read more
Keeping your Google Docs well-organized and visually appealing can be a challenging task, especially when dealing with large documents. One common formatting requirement is to resize H3 headings and add horizontal lines above them for better separation and clarity. Instead of manually editing each heading, you can automate this process using Google Apps Script. In … Read more
Introduction Do you often find yourself needing to clean up specific headings in your Google Docs? Maybe your document has numerous H3 headings that start with “Question” followed by a number, and you want to streamline these headings by removing the redundant word and number. This manual task can be time-consuming and prone to errors. … Read more