It’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 MoreI’ve been doing more lately working with APIs of different sorts, and I recently stumbled onto some cool ways to use Google Sheets to connect with APIs and store the data very easily in a spreadsheet. Having completed the linked project in less than an hour, I was really interested in figuring out the pros […]
Read MoreOne of the coolest things about working with Google Apps Script is the overall versatility of the Google Apps ecosystem. I’ve written pretty extensively about how to use Google Apps Script to do a lot of more business focused things, like send an email with Google Forms submissions, sending an attachment with Google Forms submission, […]
Read MoreIn this blog post, we’re going to look at how to use Google App Script to create a Google Calendar with a Google Form. This tutorial will build on some of the same code and concepts we’ve been working with in some earlier blog posts, so feel free to check those out: Send a confirmation […]
Read More