Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script is an incredible tool that allows you to extend the functionality of Google Sheets. By using Apps Script, you can create custom menus, automate tasks, and integrate with other Google services. In this blog post, we’ll explore how to add a custom menu to Google Sheets that triggers a popup alert, handle … Read more
When running JavaScript code, encountering an “Uncaught ReferenceError” can be frustrating. This error usually means that you’re trying to use a function or variable that hasn’t been defined. In this post, we’ll address the specific error “Uncaught ReferenceError: readLine is not defined” and provide a solution to fix it. The Problem HTML and JavaScript code … Read more
Google Apps Script is a powerful tool that allows you to automate tasks within Google Workspace. One of its many capabilities is sending emails to a group of contacts. In this blog post, we’ll walk through the steps to create a script that sends an email to a group of contacts stored in a Google … Read more
Creating a responsive navigation bar that sticks to the bottom of the page is a great way to enhance the user experience on a website. This type of navigation bar remains visible to users as they scroll through content, making it easy to access key links at any time. In this blog post, we’ll cover … Read more
Buig thank you for the organizers and attendees of Google IO Extended + Build with AI in Waterloo this past weekend. Reflecting on an Inspiring Day at Google IO Extended + Build with AI https://gdg.community.dev/events/details/google-gdg-waterloo-presents-google-io-extended-build-with-ai I had the incredible honor of presenting at the Google IO Extended + Build with AI event, hosted by GDG … Read more
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