Google Apps Script

Google Apps Script

Automate Formatting Questions with Google Apps Script

by

If you regularly work with Google Docs, you might find yourself manually formatting text to improve readability. For instance, you might want to highlight questions in your document by converting them into headings. With Google Apps Script, you can automate this process, saving time and effort. In this blog post, we’ll walk through a script … Read more

Automate Quality Checks for Title Headings in Google Docs Using Google Apps Script

by

In today’s fast-paced digital world, maintaining the quality of documents is crucial, especially when dealing with templates that are used repeatedly. Google Apps Script offers a powerful way to automate tasks in Google Docs, ensuring consistency and quality. In this blog post, we will explore how to implement automatic quality checks for title headings in … Read more

Power Up with Apps Script & Gemini AI

by

Presentation by Laurence Svekis Presentation Overview Laurence Svekis delivered a comprehensive presentation titled “Power Up with Google Apps Script” at the Google IO Extended + Build with AI event. The talk focused on empowering users with the capabilities of Google Apps Script to automate tasks, customize workflows, and integrate various services within the Google Workspace … Read more

Mastering Google Apps Script: 10 Essential Coding Exercises

by

Are you looking to enhance your Google Apps Script skills? Whether you’re a beginner or looking to refine your abilities, these 10 essential coding exercises will help you get a solid grasp of Google Apps Script. Each exercise comes with complete code and explanations, providing a comprehensive learning experience. Exercise 1: Creating a Custom Function … Read more

Managing Google Contacts with Google Apps Script: Filtering by Labels and Listing All Contacts

by

Google Apps Script provides powerful tools to interact with Google services, including Google Contacts. In this blog post, we’ll explore how to use the Advanced People Service in Google Apps Script to filter contacts by a specific label and list all contacts along with their labels. We’ll walk through two key functions: getContactsByLabel and listContactsAndLabels. … Read more

Creating a Custom Menu in Google Sheets with Google Apps Script

by

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

How to Email a Group of Contacts Using Google Apps Script

by

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

Inspiring Day at Google IO Extended + Build with AI Power up with Apps Script

by

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

Creating a Google Apps Script to List Images in a Folder with Descriptions

by

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

Advanced Email Template Interaction with Google Apps Script

by

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