Google recently announced that it is bringing the V8 JavaScript runtime to the Google Apps Script environment, and the community, myself included, reacted with much enthusiasm. This is amazing! https://t.co/Qmbb0MIugx — Jeff Everhart (@J_Everhart383) February 6, 2020 There are a lot of things to be excited about with this new change, but I also realized […]
Read MoreLots of the Google Apps Script projects that people are working on start with a Google Spreadsheet as a base. Sometimes a Google Form writes data to a spreadsheet that triggers other events, or you have a Sheet you’ve imported that you want to use to coordinate a larger workflow. This post will describe different […]
Read MoreIn this quick tutorial, we’re going to build a simple little menu add-on for Google Docs that lets you translate text into another language. Some of this functionality may be baked into Google Docs at this point, but this should be a good tutorial that wraps together a few different services and methods of augmenting […]
Read MoreIt’s been awhile since I have written anything to do with Google Apps Script, so I decided to start exploring some features of the Apps Script world that are new to me. When I first got started with Apps Script almost 6 years ago, there were lots of things I wanted to do, but just […]
Read MoreOccasionally, when you are running a Google Script attached to a spreadsheet or document, the triggers that run those scripts can sometimes start to malfunction. Over the last five years, I haven’t been able to identify meaningful patterns for why these triggers and the associated scripts fail, but it just happens sometimes. However, here are […]
Read MoreFor the most part, I love working with Google App Script. The APIs are what you expect them to be. Most of the features are well-documented. Heck, I’ve even tried to build Google Sheets into a small relational database. But after you’ve been around the block for awhile, you realize there is this odd black […]
Read MoreGoogle Sheets tends to be my go to whenever I need to build a really lightweight application that has a limited life span. Usually, these things typically involve a short turnaround or some type of very well-defined set of requirements. After Tom did some work demonstrating the utility of silent Google Forms submissions using JS […]
Read MoreTypeerror: cannot read property “values” from undefined is one of the most persistent and frequent errors you can get when doing any type of scripting in Google Apps Script. One of the most frequent questions I get on this blog, so I decided to dedicate a post to helping people troubleshoot this pesky error. First, […]
Read MoreUsing custom menus can help you automate and streamline certain tasks in Google Apps Script by creating easy-to-use interfaces so other people can run and benefit from your code. In this post, we are going learn how to add custom menus to Google Docs, Sheets, and Forms using Google Apps Script. Adding custom menus allows […]
Read MoreI’ve got another Google Apps Script tutorial here for everyone, and this time we’ll be taking a look at one of the advanced services provided by Google Apps. Most of what we’ve talked about so far involves building on top of one of the existing Google Apps services, but this one is entirely new and […]
Read More