Posts tagged google apps script
We needed to do a survey at work that included some open ended questions. We don't have access to a survey platform like Qualtrics, so we have to u...
Read more
Google Apps Script projects can be published as web apps when you’re done with them. This is helpful if you’re building a tool with a simple UI (us...
Read more
One of my favorite things about Google Apps Script is that I can get information from an API and write it directly to a shared document or spreadsh...
Read more
We're getting ready to launch a digital teaching and learning course for staff that is based on the TPACK framework. A few years ago, we started ou...
Read more
This is a revisit to a post I wrote four years ago in which we used a spreadsheet and Google's nifty little hidden JSON data endpoint to serve data...
Read more
My small team relies on automation to make things run. Part of our PD process is a Google Form workflow that kicks off calendar events, document cr...
Read more
If you're brand new to unit testing, start with the first post in this series to get caught up. Part 1: QUnit Setup Part 2: Simple Tests Part 3: Ad...
Read more
If you're brand new to unit testing, start with the first post in this series to get caught up. Part 1: QUnit Setup Part 2: Simple Tests Part 3: Ad...
Read more
If you're brand new to unit testing, start with the first post in this series to get caught up. Part 1: QUnit Setup Part 2: Simple Tests Part 3: Ad...
Read more
If you're brand new to unit testing, start with the first post in this series to get caught up. Part 1: QUnit Setup Part 2: Simple Tests Part 3: Ad...
Read more
I'm not good at writing testable code. I'm more of a 'figure it out when it breaks' kind of hobby programmer. The problem with this is that I am co...
Read more
tl;dr I have a Google Apps Script project getting a major overhaul. If you want to look at the code and contribute, it's on GitHub. A couple years ...
Read more
My Google account is managing a lot of document creation at school. I set up a lot of autoCrat projects to create docs alongside several utility sc...
Read more
Some quick notes of my progress on updating DocuTube in the Docs Addon store: Search by Default Search videos in the addon popup window Video, chan...
Read more
If you work in big systems, sometimes you come across a situation where you want to share a single tab of a Google Sheet with someone else rather t...
Read more
Adding to the list of things to blog so I don’t forget about them in the future, I built an event manager web app for prom. Sales Writing data to/f...
Read more
My coworker, Kat, needed to set up meetings with our 13 elementary schools. Appointment slots would have been a lot of clicking back and forth on c...
Read more
This is another entry into the “fun, but probably not feasible” folder. A colleague and I have been trying to show the importance of getting a know...
Read more
I thought I was ready for some beta testing of the Slide Tweeter AddOn. Unfortunately, I’ve run into a snag with authenticating some of the code. W...
Read more
Note 2024-03-20 - This post has been updated with a correct video embed as well as a GitHub Gist link for the source code. The code has not been te...
Read more
A short update to my post about tweeting Google Slides presentations after some work this weekend. – Working AddOn menu prototyped. – Check if a us...
Read more
An app called Keynote Tweet has been around (in various working and non-working states) since the late 2000’s and let users auto-tweet images of th...
Read more
I have a Google Sheet which displays all upcoming PD in the district. It also tracks registrations for people through a web app. I’ve documented th...
Read more
An interesting Stack Overflow question popped up about auto-translating one document into another when edits are made. Most Google services have th...
Read more
Get in touch
Comments are always open. You can get in touch by sending me an email at
brian@ohheybrian.com